Leave a Reply

2 Comments on "ASP.NET Monsters #108: Using the LIKE operator in Entity Framework Core 2.0"

Notify of
avatar

DavidPaquette
Guest
DavidPaquette
1 month 12 days ago

@RSuter: Case sensitivity in SQL Server is dependant on the collation settings at either the database or column level.  The default setting for SQL Server is Case Insenstive. I’m not entirely sure how collation affects the LEFT function. I have not tested that.docs.microsoft.com/en-us/sql/t-sql/statements/collations

RSuter
Guest
RSuter
1 month 13 days ago

I think “like” is case insensitive in sql and thus left() is required to to verify casing. I also think that “like” is not removed because it is faster then left() so mssql can quickly search with like and verify with left(). What do you think?

wpDiscuz