Linq to SQL case sensitivity causing problems
- by Roger Lipscombe
I've seen this question, but that's asking for case-insensitive comparisons when the database is case-sensitive. I'm having a problem with the exact opposite.
I'm using SQL Server 2005, my database collation is set to Latin1_General_CI_AS.
I've got a table, "User", like this:
CREATE TABLE [dbo].[User] (
[Id] [int] IDENTITY(1,1) NOT NULL,
…