Entity Framework - case insensitive Contains?

Entity Framework and Case Insensitive String Search

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?

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 ...

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...

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...

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...

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...

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"...

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 ...

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...

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...