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

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

Can anyone given an example for each on LINQ..? And how to开发者_如何转开发 achieve the same result with Extension methods...?

---

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

---

Found a nice article with examples which shows SQL joins with LINQ