public void Can_use_SQL_Server_default_values() { using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var honeyDijon = context.Add(new KettleChips { Name = "Honey Dijon" }).Entity; context.SaveChanges(); Assert.Equal(new DateTime(2035, 9, 25), honeyDijon.BestBuyDate); var buffaloBleu = context.Add(new KettleChips { Name = "Buffalo Bleu", BestBuyDate = new DateTime(2111, 1, 11) }).Entity; context.SaveChanges(); Assert.Equal(new DateTime(2111, 1, 11), buffaloBleu.BestBuyDate); } using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { Assert.Equal(new DateTime(2035, 9, 25), context.Chips.Single(c => c.Name == "Honey Dijon").BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11), context.Chips.Single(c => c.Name == "Buffalo Bleu").BestBuyDate); } }
public void Can_use_SQL_Server_default_values() { using (var context = new ChipsContext(_serviceProvider, TestStore.Name)) { context.Database.EnsureCreated(); context.Chippers.Add(new Chipper { Id = "Default" }); context.SaveChanges(); var honeyDijon = context.Add(new KettleChips { Name = "Honey Dijon" }).Entity; var buffaloBleu = context.Add(new KettleChips { Name = "Buffalo Bleu", BestBuyDate = new DateTime(2111, 1, 11) }).Entity; context.SaveChanges(); Assert.Equal(new DateTime(2035, 9, 25), honeyDijon.BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11), buffaloBleu.BestBuyDate); } using (var context = new ChipsContext(_serviceProvider, TestStore.Name)) { Assert.Equal(new DateTime(2035, 9, 25), context.Chips.Single(c => c.Name == "Honey Dijon").BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11), context.Chips.Single(c => c.Name == "Buffalo Bleu").BestBuyDate); } }
public void Can_use_Firebird_default_values() { using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var honeyDijon = context.Add( new KettleChips { Name = "Honey Dijon" }).Entity; var buffaloBleu = context.Add( new KettleChips { Name = "Buffalo Bleu", BestBuyDate = DateTime.Parse("11/01/2111", CultureInfo.InvariantCulture) }).Entity; context.SaveChanges(); Assert.Equal(DateTime.Parse("09/25/2035", CultureInfo.InvariantCulture), honeyDijon.BestBuyDate); Assert.Equal(DateTime.Parse("11/01/2111", CultureInfo.InvariantCulture), buffaloBleu.BestBuyDate); } using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { Assert.Equal(DateTime.Parse("09/25/2035", CultureInfo.InvariantCulture), context.Chips.Single(c => c.Name == "Honey Dijon").BestBuyDate); Assert.Equal(DateTime.Parse("11/01/2111", CultureInfo.InvariantCulture), context.Chips.Single(c => c.Name == "Buffalo Bleu").BestBuyDate); } }
public void Can_use_Npgsql_default_values() { using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var honeyDijon = context.Add(new KettleChips { Name = "Honey Dijon" }).Entity; var buffaloBleu = context.Add(new KettleChips { Name = "Buffalo Bleu", BestBuyDate = new DateTime(2111, 1, 11, 0, 0, 0, DateTimeKind.Utc) }).Entity; context.SaveChanges(); Assert.Equal(new DateTime(2035, 9, 25, 0, 0, 0, DateTimeKind.Utc), honeyDijon.BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11, 0, 0, 0, DateTimeKind.Utc), buffaloBleu.BestBuyDate); } using (var context = new ChipsContext(_serviceProvider, "DefaultKettleChips")) { Assert.Equal(new DateTime(2035, 9, 25, 0, 0, 0, DateTimeKind.Utc), context.Chips.Single(c => c.Name == "Honey Dijon").BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11, 0, 0, 0, DateTimeKind.Utc), context.Chips.Single(c => c.Name == "Buffalo Bleu").BestBuyDate); } }
public void Can_use_SQL_Server_default_values() { var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .UseLoggerFactory <LoggerFactory>() .ServiceCollection .BuildServiceProvider(); using (var context = new ChipsContext(serviceProvider, "KettleChips")) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var honeyDijon = context.Add(new KettleChips { Name = "Honey Dijon" }); context.SaveChanges(); Assert.Equal(new DateTime(2035, 9, 25), honeyDijon.BestBuyDate); var buffaloBleu = context.Add(new KettleChips { Name = "Buffalo Bleu", BestBuyDate = new DateTime(2111, 1, 11) }); context.SaveChanges(); Assert.Equal(new DateTime(2111, 1, 11), buffaloBleu.BestBuyDate); } using (var context = new ChipsContext(serviceProvider, "KettleChips")) { Assert.Equal(new DateTime(2035, 9, 25), context.Chips.Single(c => c.Name == "Honey Dijon").BestBuyDate); Assert.Equal(new DateTime(2111, 1, 11), context.Chips.Single(c => c.Name == "Buffalo Bleu").BestBuyDate); } }
public void SampleUsage() { using (var context = new ChipsContext("chips")) { context.Database.EnsureCreated(); context.Add(new PringleChips { Id = Guid.NewGuid().ToString(), Name = "Honey Dijon" }); context.Add(new PringleChips { Id = Guid.NewGuid().ToString(), Name = "Ranch", BestBuyDate = new DateTime(2112, 2, 22) }); context.SaveChanges(); } }
public void Constructed_update_statement_uses_default_when_commandTimeout_not_configured() { var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddSingleton <IModificationCommandBatchFactory, TestSqlServerModificationCommandBatchFactory>() .BuildServiceProvider(); using (var context = new ChipsContext(serviceProvider)) { context.Database.EnsureCreated(); context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos" }); context.SaveChanges(); Assert.Null(GlobalCommandTimeout); } }
public void Constructed_update_statement_uses_commandTimeout_not_configured_in_context() { var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddSingleton<SqlServerModificationCommandBatchFactory, TestSqlServerModificationCommandBatchFactory>() .BuildServiceProvider(); using (var context = new ChipsContext(serviceProvider, "KettleChips")) { context.Database.EnsureCreated(); context.Database.AsRelational().Connection.CommandTimeout = 88; context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos" }); context.SaveChanges(); Assert.Equal(88, globalCommandTimeout); } }