No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
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 …
I have the same problem with multiple joins. Here is the query: [code] 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 = …
The End.