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