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