Caporegime
Please don't use L2S - it is unfinished and very difficult to work with in some scenarios, and once implemented, very difficult to untangle!
Example of why it's hard to use:
The above query will not work in L2S! the LinkedObjects property will be an EntitySet which does not implement IQueryable, only IEnumerable, so it cannot map the Any() function to SQL.
Example of why it's hard to use:
Code:
return dataContext.Objects.Where(each => each.LinkedObjects.Any(oo => oo.SomeProperty == "foo"));
The above query will not work in L2S! the LinkedObjects property will be an EntitySet which does not implement IQueryable, only IEnumerable, so it cannot map the Any() function to SQL.
Last edited: