I really want the ADO.NET vNext team to comment on these 2 things. These have been bothering me for some time now. 1) the 'where is what executed' problem. See: http://www.thedatafarm.com/blog/2007/02/13/TheShadowySideOfLINQToSQL.aspx It contains a Linq query which actually doesn't result in a single query but in a query which results are evaluated in-memory, which isn't expected at all, and thus will result in a lot of queries. (point 2 in that blog). When is what executed in the db and when is
Read More...