public void DbFunctions_CreateDateTimeOffset_does_not_throw_if_year_does_not_have_4_digits()
{
using (var ctx = new ArubaContext())
{
var query = ctx.AllTypes.Select(
a => a.c30_datetimeoffset == DbFunctions.CreateDateTimeOffset(8, 2, 29, 1, 1, 1, 1));
Assert.DoesNotThrow(() => query.Count());
}
}
public void CreateDateTimeOffset()
{
this.context.DateTimeOffsetFieldEntities.Add(
new DateTimeOffsetFieldEntity()
{
Offset = DateTimeOffset.Now
});
this.context.SaveChanges();
#if !EFOLD
var q = this.Entities
.Select(x =>
DbFunctions.CreateDateTimeOffset(x.Offset.Year, 1, 1, 0, 0, 0, 60));
#else
var q = this.Entities
.Select(x =>
EntityFunctions.CreateDateTimeOffset(x.Offset.Year, 1, 1, 0, 0, 0, 60));
#endif
var q2 = q.AsEnumerable().Where(x => x.Value.Offset.TotalHours == 1);
q.Should().NotBeEmpty();
}
public void DbFunctionsTests_CreateDateTimeOffset_Test()
{
this.AssertException <NotSupportedException>(() => {
this.GetOrderQuery().Select(x => DbFunctions.CreateDateTimeOffset(YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, -5)).First();
});
}
