Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns.

Which options does OpenAccess and LINQ provide to perform string matching? Into which SQL is the LINQ expression translated?
Let's use a simple class model for this post: a Person with a FirstName, a LastName and a NickName. Let's assume parameters with the name simpleParam (string) and manyParam (ICollection<string>).


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

Computer Tutorials,Programming,String,String Comparison