Linq join query for Asp.net
Here Suppliers and Customers are two tables. Common key company name. Now the linq join query... 1. var q = from s in db.Suppliers join c in db.Customers on s.City equals c.City select new { Supplier = s.CompanyName, Customer = c.CompanyName, City = c.City }; 2. var q = from s in db.Suppliers join c in db.Customers on s.City equals c.City into scusts join e in db.Employees on s.City equals e.City into semps select new { s, scusts, semps };