StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3674590
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2010-09-09T07:31:42.233
FavoriteCount
0
LastActivityDate
2010-09-09T07:31:42.233
LastEditDate
LastEditorUserId
0
OwnerUserId
259769
ParentId
3658028
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
What you're trying to do here isn't a particularly good thing to do with Linq as Linq is meant to be for querying data and not updating it. Your <code>Select</code> statement is relying on side-effects to perform the update. This generally should be avoided. However, you can still do what you want. To start with, I re-arranged your query as: <pre><code>var items = obj1 .Where(w => w.Key == iKey) .Select(c => { c.Value = newValue; return c; }) .ToArray(); </code></pre> Then I refactored it as such: <pre><code>Func<Obj, string, Obj> update = (c, v) => { c.Value = v; return c; }; var items = (from w in obj1 where w.Key == iKey select update(w, newValue)).ToArray(); </code></pre> This still has the side-effect, but I made it more explicit (and hopefully more readable). Given this refactoring, the <code>UPDATE</code> query involving the two lists becomes: <pre><code>var UPDATE = (from o1 in obj1 join o2 in obj2 on o1.Key equals o2.Key select update(o1, o2.Value)).ToArray(); </code></pre> If you wanted to do this without side-effects, I would suggest the following: <pre><code>var items = from w in obj1 where w.Key == iKey select (Action)(() => w.Value = newValue); Array.ForEach(items.ToArray(), a => a()); var UPDATE = from o1 in obj1 join o2 in obj2 on o1.Key equals o2.Key select (Action)(() => o1.Value = o2.Value); Array.ForEach(UPDATE.ToArray(), a => a()); </code></pre> You might not like this syntax, so you could easily write quick extension method on <code>IEnumerable<Action></code> to invoke the actions and would make the code look like this: <pre><code>(from w in obj1 where w.Key == iKey select (Action)(() => w.Value = newValue)).Invoke(); (from o1 in obj1 join o2 in obj2 on o1.Key equals o2.Key select (Action)(() => o1.Value = o2.Value)).Invoke(); </code></pre> I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POLinq to objects Update
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USEnigmativity
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
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.