This only works with SubSonic 2.1!

C#:
  1. var query = new Select().Top("1").From(TreeHtmlExports.Schema)
  2.             .Where(TreeHtmlExports.Columns.TreeId).IsEqualTo(treeId)
  3.             .OrderDesc(TreeHtmlExports.Columns.DateCreated);
  4.            
  5. Dal.TreeHtmlExportsCollection treeHtmlExportsCollection =
  6.     query.ExecuteAsCollection<TreeHtmlExportsCollection>();

Ciao! Lieven Cardoen aka Johlero