if u use profiler to check the query against ur database..

u find out it's a mess for sure. with linq to entity framework, u don't have control what kind of query it generates and whether is db query engine friendly.

Ling is generally abused by any means, just be cautious.