StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC# LINQ select from list
primarykey
Id
3370549
data
AcceptedAnswerId
3370570
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-07-30T10:19:14.177
FavoriteCount
0
LastActivityDate
2010-07-30T20:24:04.980
LastEditDate
2010-07-30T11:36:52.003
LastEditorUserId
21234
OwnerUserId
310787
ParentId
0
PostTypeId
1
Score
0
ViewCount
495
LastEditorDisplayName
text
Body
i asked this a few weeks ago, but couldnt get any of the suggested answers working, so i would be grateful for any help on this: i have a list of event Ids returned from an xml document as shown below <pre><code>public IEnumerable<EventFeed> GetEventIdsByEventDate(DateTime eventDate) { return (from feed in xmlDoc.Descendants("Show") from ev in feed.Elements("Event") where Convert.ToDateTime(ev.Attribute("Date").Value).ToShortDateString() == eventDate.ToShortDateString() select new EventFeed() { EventShowCode = feed.Attribute("Code").Value }).ToList(); } </code></pre> i now need to query my database to match events that equal the eventIds returned from the above method. so i would have something like: select * from eventsdb where eventId in GetEventIdsByEventDate() how can i do this using LINQ thanks kb Hi Prutswonder, ive created the method below based on your suggestion <pre><code>public IEnumerable<EventFeed> foo(DateTime str) { var foo = from f in GetAllEventsFromDatabase().ToList() where GetAllEventsByDate(str).Contains(f.EventShowCode) select e; return (IEnumerable<EventFeed>) foo; } </code></pre> but on compile i get the following error <pre><code>Error 7 The type arguments for method 'System.Linq.Enumerable.Contains<TSource>(System.Collections.Generic.IEnumerable<TSource>, TSource)' cannot be inferred from the usage. Try specifying the type arguments explicitly. </code></pre> GetAllEventsFromDatabase: <pre><code>public IEnumerable<EventFeed> GetAllEventsFromDatabase() { var allEvents = from eventsList in GetEventsList() select new EventFeed() { EventName = eventsList.Title, EventSummary = eventsList.Introduction, EventShowCode = eventsList.EventId, EventImageSmall = eventsList.EventImageThumbUrl, EventUrl = eventsList.Url, EventSortBy = eventsList.SortOrder }; return allEvents.OrderBy(x => x.EventSortBy); } </code></pre>
Tags
<c#><linq>
Title
C# LINQ select from list
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USskaffman
UserOwnerUserId
1. USkb.
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
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.