Case Insensitive String Search and Entity Framework

Entity Framework options to map list of strings or list of int (List<string>)

Although I dislike answering my own questions, here is what I did to get the solution:...Following my discovery of this ...Advanced Types... link I tried a few different implementations, and in the end I came up with this....It is not necessary to do several joins in order to get the list items since the List values are directly stored on the datab...

Entity Framework - case insensitive Contains?

I utilize SQL Server and EF6....Contains... corresponds to...LIKE '%@p0%'... This, in my situation, is not case-sensitive. in my situation:...db.Counties.Where(x => x.CountyName.Contains(term)).ToList(); ...tasks as required. Details are in ...Sjoerd responds....

Entity Framework search records with a list of strings?

Do you need this:...ctx.posts.Where(post => words.Any(word => post.Title.Contains(word)))

Entity Framework LINQ contains not case insensitive

According to the comments, it appears that the OP is first casting the IQueryable list to an ICollection, which means that any ensuing LINQ is executed "locally" without the opportunity to be converted to SQL....For instance,... // Should be IQueryable<T> ICollection<User> users = context.Users; // This is executed in code rather than S...

How do you check if a string contains any strings from a list in Entity Framework?

I'm late to the party, but you could use the ...Nuget package for SearchExtensions... to do the following....var result = context.Data.Search(x => x.Name, x => x.Code).Containing(searchTerms); ...This creates an expression tree, which means the query will still be conducted on the server (and not in memory), effectively running the SQL you wanted t...

Entity Framework 6 Code First case insensitive string association

ZZZ_tmp

Entity Framework varchar foreign key case insensitive

ZZZ_tmp

EF code first migrations from Pascal Case Properties to lower case columns

ZZZ_tmp

Searching for multiple strings using single database query with entity framework and LINQ

ZZZ_tmp

Case insensitive name of tables and properties in Entity Framework 6

ZZZ_tmp