使用linq和亚音速3

var qry = DB.Select.From(\"EventListing\").OrderDesc(\"CreatedOn\").Where(\"StartTime\", Comparison.GreaterThan,
SelectedDate.AddDays(-1));
// TODO LIMIT TO TOP (based on Max) RESULTS
// where StartTime is the same date as SelectedDate
//qry.TopSpec = \"5\";
var events = qry.ExecuteTypedList<EventListing>();

Take()

var qry = DB.Select.From(\"EventListing\").OrderDesc(\"CreatedOn\").Where(\"StartTime\", Comparison.GreaterThan, SelectedDate.AddDays(-1)).Take(5);