Web technology

web developers learning site

Archive for the tag “join”

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 };

Post Navigation