public virtual void TestDateTimeDateDiffHourNew()
{
DateTime dt = new DateTime(1997, 8, 25, 0, 0, 0);
DateTime dt1 = new DateTime(1996, 1, 15, 10, 20, 30);
var expected = (dt - dt1).Hours;
var actual = db.Orders.Select(o => o.OrderDate == dt && SqlFunctions.DateDiff(DateParts.Hour, o.OrderDate, dt1) == expected).FirstOrDefault();
Assert.IsNotNull(actual);
var expected1 = (dt - dt1).TotalHours;
#if SQLite || Oracle
var item = db.Orders.Where(o => o.OrderDate == dt && SqlMethods.DateDiffHour(dt1, o.OrderDate) == (int)expected1).FirstOrDefault();
Assert.IsNotNull(item);
#else
var item = db.Orders.Where(o => o.OrderDate == dt && SqlFunctions.DateDiff(DateParts.Hour, dt1, o.OrderDate) - 1 == (int)expected1).FirstOrDefault();
Assert.IsNotNull(item);
#endif
}