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);
}
