public async Task CanUseModelWithDateTimeOffsetAsync()
{
var serviceCollection = new ServiceCollection();
serviceCollection.AddEntityFrameworkMySQL()
.AddDbContext <QuickContext>();
var serviceProvider = serviceCollection.BuildServiceProvider();
using (var context = serviceProvider.GetRequiredService <QuickContext>())
{
try
{
context.Database.EnsureCreated();
var dt = DateTime.Now;
var e = new QuickEntity {
Name = "Jos", Created = dt
};
context.QuickEntity.Add(e);
context.SaveChanges();
var result = await context.QuickEntity.FirstOrDefaultAsync();
Assert.Equal(dt, result.Created);
}
catch (Exception)
{
throw;
}
finally
{
context.Database.EnsureDeleted();
}
}
}
public void CanUseModelWithDateTimeOffset()
{
var serviceCollection = new ServiceCollection();
serviceCollection.AddEntityFrameworkMySQL()
.AddDbContext <QuickContext>();
var serviceProvider = serviceCollection.BuildServiceProvider();
using (var context = serviceProvider.GetRequiredService <QuickContext>())
{
try
{
context.Database.EnsureCreated();
DateTimeOffset dt = DateTime.Now;
var e = new QuickEntity {
Name = "Jos", Created = dt
};
context.QuickEntity.Add(e);
context.SaveChanges();
var row = context.QuickEntity.FirstOrDefault();
Assert.AreEqual(dt, row.Created);
}
finally
{
context.Database.EnsureDeleted();
}
}
}
