No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I have the same problem with multiple joins. Here is the query: Data data = (from scr in entities.SponsoredCharitableReportsSet from company in entities.CompanySet.Where(c => c.ID == scr.CompanyID) from user in entities.UserSet.Where(u => u.MemberID == scr.MemberID) where scr.ID == DetailsID orderby scr.DateRequested, company.CompanyName, user.FullName select new Data { ID = (company …
|
|
|
Hi, I want to left outer join 2 tables called a and b.In the Where clause I want to check properties from both tables i.e like this [CODE] var query = from a in data.A join b in data.B on a.id == b.id where a.marks = 1 && b.archived == …
|