What could possibly be different between the table in a DataContext and an IQueryable<Table> when do
- by Nate Bross
I have a table, where I need to do a case insensitive search on a text field.
If I run this query in LinqPad directly on my database, it works as expected
Table.Where(tbl => tbl.Title.Contains("StringWithAnyCase")
In my application, I've got a repository which exposes IQueryable objects which does some initial filtering and it looks like…