StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFiltering sets of data from within another set
primarykey
Id
14695554
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-02-04T21:00:50.893
FavoriteCount
1
LastActivityDate
2013-02-04T22:00:36.970
LastEditDate
2013-02-04T21:29:50.443
LastEditorUserId
76337
OwnerUserId
1532045
ParentId
0
PostTypeId
1
Score
0
ViewCount
87
LastEditorDisplayName
text
Body
I've been reading the docs and tutorials on LINQ queries but can't seem to get it right. I have a model similar to this one and am using entity framework to persist it: <pre><code>public class Question { public int Id {set;get;} public string Question {set;get;} public DateTime DateCreated {get;set;} public List<Answer> Answers {set; get;} } public class Answer { public int Id {set; get;} public string UserAnswer {get;set;} public DateTime DateAnswered {get;set;} public User TheUserWhoAnswerd {get;set;} } public class User { public int Id { get;set;} public string UserName {get;set;} public DateTime DateCreated {get;set;} public List<Question> Questions { get;set;} } The data context has something like this public HashSet<Question> AllOfTheQuestionsDb {get;set;} public HashSet<Answer> AllOfTheAnswersDb {get;set;} public HashSet<User> AllOfTheUsersDb {get;set;} </code></pre> My flow is similar to stack overflow --trivia style. The system can assign questions to users (question are generated by the system i.e. admin , and initially don't belong to anyone). After that, the same questions can be assigned to multiple different users. each user can then answer the question. The question holds a list of answers that were given to it. So for instance if question 1 was assigned to users 1 through 10, but only user 2 and 4 answered, that question will only have 2 answers in the "Answers list". My goal is to be able to do some basic sorts and selects on the data source. For instance: <ol> <li>For a given user - UserA -, return all questions where UserA did not answer that question.</li> <li>for all questions in system, return all users that the question was assigned to but that user did/didn't answer</li> <li>selecting questions and answers for a user that were/were not answered after a given date</li> </ol>
Tags
<c#><linq><select><set>
Title
Filtering sets of data from within another set
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJohn Saunders
UserOwnerUserId
1. USAvner Barr
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POFiltering sets of data from within another set
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
2. VO
 singulars
 PostPostId
 POFiltering sets of data from within another set
 UserUserId
 USAvner Barr
 VoteTypeVoteTypeId
 VTFavorite
3. VO
 singulars
 PostPostId
 POFiltering sets of data from within another set
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.