Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. var list = (from message in db.BLOGS_MESSAGES
  2. where message.BLOG_ID == blogId
  3. orderby message.CREATED_DATE descending
  4. select new BlogMessage()
  5. {
  6. AUTHORS = **(from author in message.AUTHORS
  7. select author.USERS).ToArray()**,
  8. CREATED_BY = message.CREATED_BY,
  9. CREATED_DATE = message.CREATED_DATE,
  10. BLOG_MESSAGE_ID = message.POST_ID,
  11. MESSAGE_TITLE = message.TITLES.TITLE,
  12. TAGS = **(from tag in message.TAGGED_MESSAGES
  13. select tag.TAGS).ToArray()**,
  14. LOGIN = message.USERS.LOGIN,
  15. MESSAGE = message.MESSAGES.MESSAGE,
  16. MESSAGE_ID = message.MESSAGE_ID,
  17. POST_NOTE = message.POST_NOTES.Sum(x => (long?)x.NOTE) ?? 0 / message.POST_NOTES.Count(),
  18. }).ToList();
  19.  
  20. var mlist = (from message in db.BLOGS_MESSAGES
  21. where ....
  22. orderby ....
  23. select new {
  24. AUTHORS = (from author in message.AUTHORS
  25. select author.USERS),
  26. ....
  27. }
  28.  
  29. List<BlogMessage> list = new List<BlogMessage>();
  30. foreach(var item in mlist)
  31. {
  32. list.Add(new BlogMessage()
  33. {
  34. AUTHORS = item.AUTHORS.ToArray(),
  35. ...
  36. });
  37. }
  38.  
  39. var step1 = db.BLOGS_MESSAGES
  40. .Where(...)
  41. .Select(message => new {
  42. Authors = message.AUTHORS.Select(a => a.USERS), // No .ToArray()
  43. ...
  44. }).ToList();
  45.  
  46. var step2 = step1.Select(message => New BlogMessage {
  47. Authors = message.Authors.ToArray(),
  48. ...
  49. }).ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement