public void MinOfDateTimeColumnWithoutGroupBy() { DateTimeValueResults r = new DateTimeValueResults(); q = Select.Results(r.Value). From(e). Columns(Min.Of(e.LastActivityDate).As(r.Value)); AssertSql("SELECT MIN(LastActivityDate) Value FROM Employee"); AssertRowCount(1); AssertRow(DateTime.MinValue); }
public void MaxOfDateTimeColumnWithoutGroupBy() { DateTimeValueResults r = new DateTimeValueResults(); q = Select.Results(r.Value). From(e). Columns(Max.Of(e.LastActivityDate).As(r.Value)); AssertSql("SELECT MAX(LastActivityDate) Value FROM Employee"); AssertRowCount(1); AssertRow(new DateTime(2009, 2, 2, 21, 36, 0)); }