public void TestDbBulkInserter()
{
//init db
Database.SetInitializer(new DropCreateDatabaseAlways <InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter <Entity2>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var entities = new Entity2[]
{
new Entity2(1)
{
Key = "a", Value = 0.5f
},
new Entity2(2)
{
Key = "b", MyLeg = new Leg()
{
LegInt = 5, LegString = "bleg"
}
},
new Entity2(3)
{
Value = 0.7f
},
};
inserter.ProcessAsync(entities, true).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
}
public void TestDbBulkInserter()
{
//init db
Database.SetInitializer(new DropCreateDatabaseAlways<InsertContext>());
var connectString = TestUtils.GetLocalDBConnectionString();
var context = new InsertContext(connectString);
context.Inits.Add(new Init2());
context.SaveChanges();
var inserter = new DbBulkInserter<Entity2>(
connectString,
"dbo.Seods",
DataflowOptions.Default,
GSProduct.SEOD);
var entities = new Entity2[]
{
new Entity2(1) { Key = "a", Value = 0.5f },
new Entity2(2) { Key = "b", MyLeg = new Leg() { LegInt = 5, LegString = "bleg" } },
new Entity2(3) { Value = 0.7f },
};
inserter.ProcessAsync(entities, true).Wait();
//test result
Assert.AreEqual(3, context.Seods.Count());
Assert.AreEqual("b", context.Seods.Find(2).Name);
Assert.AreEqual("b", context.Seods.Find(2).Name2);
Assert.AreEqual(5, context.Seods.Find(2).LegInt);
Assert.AreEqual("bleg", context.Seods.Find(2).LegString);
Assert.AreEqual(-2f, context.Seods.First(s => s.Id == 2).Price);
Assert.AreEqual("default", context.Seods.First(s => s.Id == 3).Name);
Assert.AreEqual(0.7f, context.Seods.First(s => s.Id == 3).Price);
Assert.AreEqual(2, context.Seods.Find(3).LegInt);
Assert.AreEqual("LegString", context.Seods.Find(3).LegString);
}
