public override Task DateTimeOffset_Contains_Less_than_Greater_than(bool async) { var dto = GearsOfWarQueryMySqlFixture.GetExpectedValue(new DateTimeOffset(599898024001234567, new TimeSpan(1, 30, 0))); var start = dto.AddDays(-1); var end = dto.AddDays(1); var dates = new[] { dto }; return(AssertQuery( async, ss => ss.Set <Mission>().Where( m => start <= m.Timeline.Date && m.Timeline < end && dates.Contains(m.Timeline)))); }
public override Task Where_datetimeoffset_milliseconds_parameter_and_constant(bool async) { var dateTimeOffset = GearsOfWarQueryMySqlFixture.GetExpectedValue(new DateTimeOffset(599898024001234567, new TimeSpan(1, 30, 0))); // Literal where clause var p = Expression.Parameter(typeof(Mission), "i"); var dynamicWhere = Expression.Lambda <Func <Mission, bool> >( Expression.Equal( Expression.Property(p, "Timeline"), Expression.Constant(dateTimeOffset) ), p); return(AssertCount( async, ss => ss.Set <Mission>().Where(dynamicWhere), ss => ss.Set <Mission>().Where(m => m.Timeline == dateTimeOffset))); }