Linq to SQL – table join with multiple where clause
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;
}
leave a comment