Code Snipets

Linq to SQL – table join with multiple where clause

Posted in C#, Linq by mauliksoni on December 30, 2010


public IQueryable<CustomerActivity> GetCustomerActivityResult(string sUser,DateTime ReportDate)
 {
 CustomerDataClassesDataContext db = new CustomerDataClassesDataContext();

 var customeractivity = from ca in db.CustomerActivities
 join acts in db.ActivitySummaries
 on ca.ActivitySummaryID equals acts.ActivitySummaryID
 where acts.Name == sUser && acts.Date == ReportDate
 select ca;
 return customeractivity;
 }

Tagged with:
Follow

Get every new post delivered to your Inbox.