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