Entity Framework - case insensitive Contains?

entity-framework

Question

I want a solution to this problem that does not involve ToUpper or ToLower, as I use in the code below;

var upper = term.ToUpper();
using (var db = this.DataContext)
{
    return db.Counties.Where(x => x.CountyName.ToUpper().Contains(upper)).ToList();
}

I am using entitly framework so the C# solution of using StringComparison.CurrentCultureIgnoreCase does not work. It does work for Equals, EndsWith and StartsWith, but not Contains.

1
35
7/8/2018 3:50:31 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I use EF6 and Sql Server and Contains is mapped to LIKE '%@p0%' which is case insensitive in my case. So in my case:

db.Counties.Where(x => x.CountyName.Contains(term)).ToList();

works as needed. More info in Sjoerd answer.

8
5/23/2017 12:09:14 PM

Related Questions

Case Insensitive String Search and Entity Framework

I have a Entity Framework entity with a string Property named Description.... Searching for all entities where the Description contains a string is as simple as: ...var res = from u ctx.Users where u.Description.contains(str) select u; ...But suppose I want to support case insensitive search?
entity-framework linq
asked by sternr

What is the equivalent of "CASE WHEN THEN" (T-SQL) with Entity Framework?

as illustrated by the following, the linq equivalent of transact sql CASE WHEN THEN is the conditional operator ...?:... :...from u in Users select new { name = u.Login, imported = (u.ImportedId != null ) ? 1 : 0 } ...is translated as ...SELECT 1 AS [C1], [Extent1].[Login] AS [Login], CASE WHEN ([Extent1].[ImportedId] IS NOT NULL) THEN 1 ELSE 0 ...
c# entity-framework sql tsql
asked by tschmit007

Entity Framework 6 error - ICollection does not contain a definition for sub-entity

I'm using Entity Framework 6 with MVC and I'm using this query in the controller:... using (var context = new MyDbContext()) { IQueryable<ContentArticle> query; query = context.ContentArticle.Where( c => c.ContentArticleSubdivisions.Subdivisions.Name == subdivision ...The compiler is com...
asp.net-mvc-5 c# entity-framework-6
asked by Chris Halcrow

Entity Framework LINQ contains not case insensitive

It's never been case sensitive for me, but I guess that is just how I set my database up. You can definitely use your first option of converting them both to upper case, EF doesn't pull them into memory to do that, just informs SQL server to do it. For example:...string searchTerm = "Some Text"; dbcontext.Table.Where (t => t.Column.ToLower().Conta...
asp.net-mvc c# entity-framework linq sql-server
asked by Ben

Entity Framework 6 Code First case insensitive string association

I'm migrating an LINQ to SQL project to EF 6.1.3 Code First. The problem I'm facing is:...I have 2 tables, Incidents with debtorNo column (varchar(20) not null) and Debtors With a No column (varchar(20) not null) which is the primary key. The schema cannot change because these tables are populated by an external system on which I have no control. T...
c# entity-framework entity-framework-6
asked by fanisch

Entity Framework varchar foreign key case insensitive

A couple of years ago the following question was asked: ...Entity Framework nvarchar Case Sensitivity on Foreign key.......In short the answer was: EF uses the CLR to compare the keys of lazily loaded associations and always does that in a case sensitive manner, even though the database is set to a case insensitive collation....Unfortunately, the p...
c# entity-framework entity-framework-6 sql-server
asked by AroglDarthu

Define SQL table primary key as case sensitive using Entity Framework Code First

Entity Framework doesn't have anything built in to do this - it will always create your database and columns using the default collation. However, you can manually run some SQL in a migration ...Up()... method to modify the collation of a specific column:...Sql("ALTER TABLE yourTable ALTER COLUMN YourColumn VARCHAR(50) COLLATE Latin1_General_CS_AS"...
c# ef-code-first ef-fluent-api entity-framework-6 sql-server
asked by DavidG

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

In Entity Framework 6 Code First, is there a way (perhaps via Data Annotations or Fluent API) so that the database generated by Migrations has lower case column names, even though my model classes have Pascal Casing properties?...I.e. This class:... public class Person { public int PersonId { get; set; } public string FirstName ...
.net ef-code-first ef-code-first-mapping ef-migrations entity-framework-6
asked by Fabricio Rodriguez

Case Sensitive with Entity Framework Code First

I create database with Entity Framework CodeFirst. I look other questions but any of them has not spesific answer.I try to save this two KEY's as a different rows to my table.:...12E60AED-7491-49B3-8006-78ECEA63B376 12e60aed-7491-49b3-8006-78ecea63b376...This is my class for attribute:...[AttributeUsage(AttributeTargets.Property, AllowMultiple = tr...
c# code-first entity-framework entity-framework-6
asked by Heidi T.

Case insensitive name of tables and properties in Entity Framework 6

I am in the process of migrating the database from SQL to postgres. The application code is using Entity framework 6. I am facing issues with case sensitivity as postgres stores table, column names in lower case unless using double quotes....The data present in postgres is in lower case (table and column names). With Entity framework 6, I am facing...
entity-framework entity-framework-6 npgsql
asked by user13332671

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow