In my humble in opinion, Linq needs better outer join support.  See this stackoverflow thread on how to perform a full join.

Do I stand alone?  Does anyone else find this very limiting?

Nowadays I pretty much use LinqPad and only SSMS and SQL when I have to.  Linq is definitely not an improvement with outer joins.  For most everything else I do, Linq is more efficient to develop.

 

MD