StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1174690
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
2009-07-24T15:11:20.340
CreationDate
2009-07-23T21:46:06.617
FavoriteCount
0
LastActivityDate
2010-03-30T13:59:03.070
LastEditDate
2010-03-30T13:59:03.070
LastEditorUserId
81641
OwnerUserId
81641
ParentId
553918
PostTypeId
2
Score
29
ViewCount
0
LastEditorDisplayName
text
Body
Note: Since it's in EF v1, we will NOT have PersonLocation and PersonRole generated as entities like what LINQ2SQL does (The answer above domonstrating LINQ2SQL scenario, which doesn't apply to the question.) Solution 1: <pre><code>Persons.Include("Role").Include("Location") // Include to load Role and Location .Where(p => p.Role.Any(r => r.description == "Student") && p.Location.Any(l => l.description == "Amsterdam")).ToList(); </code></pre> This looks nice and straightforward, but this generates ugly SQL script and its performance is ok. Solution 2: Here are breakdowns. <pre><code> // Find out all persons in the role // Return IQuerable<Person> var students = Roles.Where(r => r.description == "Student") .SelectMany(r => r.Person); // Find out all persons in the location // Return IQuerable<Person> var personsInAmsterdam = Locations.Where(l=> l.description == "Amsterdam") .SelectMany(l=>l.Person); // Find out the intersection that gives us students in Admsterdam. // Return List<Person> var AdmsterdamStudents = students.Intersect(personsInAmsterdam).ToList(); </code></pre> Combine three steps above into one: <pre><code> //Return List<Person> var AdmsterdamStudents = Roles.Where(r => r.description == "Student") .SelectMany(r => r.Person) .Intersect ( Locations .Where(l=> l.description == "Amsterdam") .SelectMany(l=>l.Person) ).ToList(); </code></pre> It's sort of verbose. But this generates clean SQL query and performs well.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POEntity framework and many to many queries unusable?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USstoto
UserOwnerUserId
1. USstoto
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COGreat answer, works with EF too where the accepted answer here doesn't work with EF
 singulars
 PostPostId
 PO
 UserUserId
 USPaul
2. COReally awesome answer to a sticky problem.
 singulars
 PostPostId
 PO
 UserUserId
 USWyatt Barnett

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.