code_junkie

SubSonic Collection Top 1

Nov 12th, 2011
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. Dal.TreeHtmlExportsCollection treeHtmlExportsCollection =
  2. new Dal.TreeHtmlExportsCollection().Where(Dal.TreeHtmlExports.Columns.TreeId, treeId).
  3. OrderByDesc(Dal.TreeHtmlExports.Columns.DateCreated).Load();
  4.  
  5. var query = new Select()
  6. .Top("1")
  7. .From(TreeHtmlExports.Schema)
  8. .Where(TreeHtmlExports.Columns.TreeId).IsEqualTo(treeId)
  9. .OrderDesc(TreeHtmlExports.Columns.DateCreated);
  10.  
  11. treeHtmlExportCollection = query.ExecuteAsCollection<TreeHtmlExportsCollection>();
Add Comment
Please, Sign In to add comment