Hi can anyone explain how DLinq determines the order that where clauses appear in the SQL that is generated. I was under the impression that the order in which clauses are placed can have a real effect on the speed at which records are filtered and returned. For example if I select a record that is mapped to another table and then take the IQueryable result and say .Where(x=>x.blah == blah) then the primary key of the second table appears to be placed after the where blah = blah in the SQL. Is
Read More...