We are having several issues where the result from a LINQ does not match the data that we expect and get from a sql query. My latest issue should return all the data in the table (232 rows) but it only returns 187. This is a straight query, no conditions. I am pretty frustrated at this point and need some ideas to discover where the problem lies.
Our other issue is a a query that depending on the conditions return wildly different data (rows) and neither reflected the actual results a sql query would. The resulting queries of the linq statements where too different to even diff. These conditions should not have resulted in any additional joins yet the resulting queries where vastly different.