score:13
Accepted answer
The problem has nothing to do with LINQ. LINQ is just an abstraction mechanism allowing you to query different datasources using the same syntax. If you are using MSSQL by default it will have SQL_Latin1_General_CP1_CI_AS
collation which is case insensitive (Notice the CI
in the name). So when your LINQ query gets translated to SQL (select * from Members where Name = 'BOB'
) and run it will return results. So basically you might need to change the collation
of your SQL server database to one that is case sensitive if you want to perform case sensitive lookups with it.
Source: stackoverflow.com
Related Articles
- == by default is case insensitive in c# linq
- LINQ Contains Case Insensitive
- linq case insensitive (without toUpper or toLower)
- can linq expression be case insensitive
- LINQ to DataSet case insensitive group by
- Case insensitive Contains with Dynamic Linq
- Entity Framework LINQ contains not case insensitive
- Linq case insensitive join
- Case insensitive string compare in LINQ expression
- how to build case insensitive strong typed LINQ query in c#?
- LINQ string contains another string case insensitive
- LINQ Source Code Available
- Linq performing case insensitive comparison
- MongoDB c# driver: Case Insensitive Compare using in or contains on a list using linq
- creating Linq to sqlite dbml from DbLinq source code
- C# LINQ use xml with case insensitive queries
- Case Insensitive Array.Contains in Linq Query
- Case insensitive LIKE condition in LINQ (with Regular Expression)
- case insensitive dynamic search for linq to entities
- linq case insensitive and trimmed comparison
- LINQ case insensitive
- LINQ query: How to do case insensitive query?
- Create an iQueryable which is case insensitive for unit testing linq to entities - NSubstitute
- source code for LINQ 101 samples
- Make LINQ expression case insensitive
- How can I do case insensitive string search with Linq and SQL Server?
- Check String contain all elements in list using Linq and case insensitive
- How to make contains method case insensitive in linq to sql
- c# Linq or code to extract groups from a single list of source data
- linq Expression.Coalesce and case insensitive in the same query
- Select Statement DrillDown
- Adding LINQ to my classes
- Linq How to Join and get 2 tables values
- Entity Framework Linq embed lambda expressions into a reusable function
- Retrieve values from Session in ASP.NET
- Linq-to-SQL combining two Expression<Func<T, bool>> ("where clause") with and/or
- How to count list items grouped by an embedded list
- Creating a KeyValuePair list by iterating over an array
- EF Core LINQ GROUPBY Then Select to get more than one properties of the entity
- Simple LINQ query
- c# wpf MVVM Get ObservableList from ObservableDictionary
- LINQ to Entity query optimization
- What's elegant way to rewrite following LINQ statement using extension methods?
- Foreach on collection cast to IEnumerable work slower than without cast?
- Format LookUp values, retrieved from WebServices
- Loop through a List<string> but only take a part of each string inside
- LINQ to SQL Server 2000: "Must declare variable '@p0'"
- LINQ in LinqPad count how many times a word shows up
- Checking if a generic IEnumerable is empty
- Can I test a single object against a LINQ function?