code_junkie

Why would LINQ to SQL perform better than a straight SQL query?

Nov 11th, 2011
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. public IQueryable<SystemNews> GetSystemNews()
  2. {
  3. using (var t = new TransactionScope(TransactionScopeOption.Required,
  4. new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted }))
  5. {
  6. var results = from s in _datacontext.SystemNews
  7. let member = GetMemberInfo(s.MemberID)
  8. let determination = GetDetermination(s.DeterminationID.Value)
  9. let daimoku = GetDaimoku(s.DaimokuID.Value)
  10. let entry = GetEntry(s.EntryID.Value)
  11. let encouragment = GetEncouragement(s.EncouragementID.Value)
  12. select new SystemNews
  13. {
  14. NewsDate = s.NewsDate,
  15. MemberID = s.MemberID,
  16. PhotoID = s.PhotoID.Value,
  17. DeterminationID = s.DeterminationID.Value,
  18. DaimokuID = s.DaimokuID.Value,
  19. EntryID = s.EntryID.Value,
  20. EncouragementID = s.EncouragementID.Value,
  21. Member = new LazyList<Members>(member),
  22. Determination = new LazyList<Determinations>(determination),
  23. Daimoku = new LazyList<MemberDaimoku>(daimoku),
  24. Entry = new LazyList<MemberEntries>(entry),
  25. Encouragement = new LazyList<MemberEncouragements>(encouragment),
  26. IsDeterminationComplete = s.IsDeterminationComplete.Value
  27. };
  28. return results;
  29. }
  30. }
  31.  
  32. _datacontext.Log = Console.Out;
Add Comment
Please, Sign In to add comment