public void WhereClauseWithGetDatePartDayOfYear1() { var store = new EntityStore(_dbConnection); var order = store.GetSingle <Order>(o => SqlFunctions.GetDayOfYear(o.OrderDate) <= DateTime.Now.DayOfYear); Xunit.Assert.NotNull(order); }
public void WhereClauseWithGetDatePartDayOfYear() { var store = new EntityStore(_dbConnection); var singleEmployee = store.GetSingle <Employee>(e => SqlFunctions.GetDayOfYear(e.Birthdate) >= 100); Xunit.Assert.NotNull(singleEmployee); }
public void WhereClauseWithGetDatePartDayOfYear2() { var store = new EntityStore(_dbConnection); var dayOfYear = 17; var order = store.GetSingle <Order>(o => dayOfYear >= SqlFunctions.GetDayOfYear(o.OrderDate)); Xunit.Assert.NotNull(order); }