How to achieve different types on joins with LINQ..?

Question

On Sql server we have multiple joins viz. left outer join, right outer join, full outer join, self join

Can anyone given an example each on LINQ..? And how to achieve the same result with Extension methods...?

Answer 1

I have found one of the best ways to learn how to convert SQL to Linq-To-SQL is via a product named Linqer. It will convert most any SQL into L2S. It's not free, about $50. But it comes with a 30 day trial period. You can generate a lot of queries in 30 days.

http://www.sqltolinq.com/home