Linq2Sql Many:Many question, How would you do this?

This may work for your case from q in Questions select new ListQuestion { Tags = q.QuestionTags. Select(qt => qt. Tag), QuestionId = q.ID, Title = q.

Title }.

This may work for your case; from q in Questions select new ListQuestion { Tags = q.QuestionTags. Select(qt => qt. Tag), QuestionId = q.ID, Title = q.

Title }.

It works. Thx a alot. I can't see how the actual query looks like.

I would like to avoid that there is fired 1 query for every question to get the tags. – TT. Dec 16 '08 at 8:42 Does this do TWO round trips to the DB?

I've got the same exact question here: stackoverflow. Com/questions/371279/… – Pure. Krome Dec 16 '08 at 13:34 No, there will be only one round trip to the DB.

– yapiskan Dec 17 '08 at 9:02.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.