These two statements look the same logically to me, but they're resulting in different SQL being generated: #1 var people = _DB.People.Where(p => p.Status == MyPersonEnum.STUDENT.ToString()); var ids = people.Select(p => p.Id); var cars = _DB.Cars.Where(c => ids.Contains(c.PersonId)); #2 string s = MyPersonEnum.STUDENT.ToString(); va...
I previously asked a question about chaining conditions in Linq To Entities. Now I use LinqKit and everything works fine. I want to see the generated SQL and after reading this answer, I use LinqPad. This is my statement: var predProduct = PredicateBuilder.True<Product>(); var predColorLanguage = PredicateBuilder.True<ColorLanguage>();...
Sql Server 2008 R2 Express. NHibernate 2.1.2.4. I get SQL like: SELECT customer0_.Id as Id1_0_ FROM customers customer0_ WHERE customer0_.Id=@p0; @p0 = 11111111-1111-1111-1111-111111111111 ...which returns 0 records even though there is Customer in there with that Id. The SQL Server column datatype is UNIQUEIDENTIFIER. <session-f...