Why isn't this short circuit in lambda working?
c#, linq, linq-to-sql
Solution
Is the `.Where` being used on a `Table<>`?
If so, then before any data can be grabbed, it must convert the LINQ to SQL and to do that it must convert the `string` into a `decimal`. It's not trying to actually perform the comparisons yet, it's trying to build the constructs necessary to retrieve data.
Problem
Why linq is trying to check second expression anyway? ``` .Where(t => String.IsNullOrEmpty(someNullString) || t.SomeProperty >= Convert.ToDecimal(someNullstring)) ``` What is usual workaround? Update: It is about LINQ to SQL, of course. It cannot translate to SQL.