private async Task DumpToDB(IEnumerable <T> data, string destTable, string connectionString, string destLabel) { using (var bulkReader = new BulkDataReader <T>(TypeAccessorManager <T> .GetAccessorByDestLabel(destLabel, connectionString, destTable), data)) { using (var conn = new SqlConnection(connectionString)) { await conn.OpenAsync(); using (var bulkCopy = new SqlBulkCopy(conn)) { foreach (SqlBulkCopyColumnMapping map in bulkReader.ColumnMappings) { bulkCopy.ColumnMappings.Add(map); } bulkCopy.DestinationTableName = destTable; bulkCopy.BulkCopyTimeout = 0; bulkCopy.BatchSize = m_bulkSize; // Write from the source to the destination. await bulkCopy.WriteToServerAsync(bulkReader); } } } }
public void TestReferenceLoopDepth() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory); var connectString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\loop.mdf;Initial Catalog=loop;Integrated Security=True;Connect Timeout=30"; //init database System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways <LoopContext>()); var context = new LoopContext(connectString); context.LoopInits.Add(new LoopInit()); context.SaveChanges(); var loopA = new LoopA { Name = "loopA", LoopB = new LoopB { Name = "loopB", LoopC = new LoopC { LoopA = new LoopA { Name = "loopA2" } } } }; using (var connection = new SqlConnection(connectString)) { connection.Open(); var tableName = "dbo.LoopEntities"; var accessor = TypeAccessorManager <LoopA> .GetAccessorByDestLabel(GSProduct.AD, connectString, tableName); var reader = new BulkDataReader <LoopA>(accessor, new[] { loopA }); using (var bulkCopy = new SqlBulkCopy(connection)) { foreach (SqlBulkCopyColumnMapping map in reader.ColumnMappings) { bulkCopy.ColumnMappings.Add(map); } bulkCopy.DestinationTableName = tableName; bulkCopy.WriteToServer(reader); } } Assert.AreEqual("loopA", context.LoopEntities.FirstOrDefault().Name); }
public void TestReader() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory); var connectString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\TestReader.mdf;Initial Catalog=mytest;Integrated Security=True;Connect Timeout=30"; //init database System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways <MyContext>()); var context = new MyContext(connectString); context.Inits.Add(new Init()); context.SaveChanges(); #region init sample data var entities = new List <Entity> { new Entity { Id = 1, PersonName = "zhang san", PhoneNumber = "110", Location = new Location { RoadNumber = 1, RoadName = "first" } }, new Entity { Id = 2, PersonName = "li si", PhoneNumber = "119", // Location = new Location{RoadNumber = 2, RoadName = "second", RoadMap = new RoadMap{Id=2}} Address = new Address { AddressNumber = 10 } } }; var entities2 = new List <Entity> { new Entity { Id = 3, PersonName = "wang er", PhoneNumber = "120" } }; #endregion #region add to db using (var connection = new SqlConnection(connectString)) { connection.Open(); // Wd: var wdAccessor = TypeAccessorManager <Entity> .GetAccessorByDestLabel(GSProduct.WD, connectString, "dbo.Wds"); var wdReader2 = new BulkDataReader <Entity>(wdAccessor, entities); using (var bulkCopy = new SqlBulkCopy(connection)) { foreach (SqlBulkCopyColumnMapping map in wdReader2.ColumnMappings) { bulkCopy.ColumnMappings.Add(map); } bulkCopy.DestinationTableName = "dbo.Wds"; bulkCopy.WriteToServer(wdReader2); } //Cd: var cdAccessor = TypeAccessorManager <Entity> .GetAccessorByDestLabel(GSProduct.CD, connectString, "dbo.Cds"); var cdReader2 = new BulkDataReader <Entity>(cdAccessor, entities); using (var bulkCopy = new SqlBulkCopy(connection)) { foreach (SqlBulkCopyColumnMapping map in cdReader2.ColumnMappings) { bulkCopy.ColumnMappings.Add(map); } bulkCopy.DestinationTableName = "dbo.Cds"; bulkCopy.WriteToServer(cdReader2); } //Wd 2: use debug model to test whether this new WdAccessor is new build or not //right: this WdAccessor should just get from TypeAccessorManager, it can not be rebuild. var wdAccessor2 = TypeAccessorManager <Entity> .GetAccessorByDestLabel(GSProduct.WD, connectString, "dbo.Wds"); var wdReader22 = new BulkDataReader <Entity>(wdAccessor2, entities2); using (var bulkCopy = new SqlBulkCopy(connection)) { foreach (var map in wdReader22.ColumnMappings) { bulkCopy.ColumnMappings.Add(map); } bulkCopy.DestinationTableName = "dbo.Wds"; bulkCopy.WriteToServer(wdReader22); } } #endregion #region reader from db and test whether data is exist. //wd Assert.AreEqual(3, context.Wds.Count()); Assert.AreEqual("li si", context.Wds.FirstOrDefault(w => w.WdId == 2).Name); Assert.AreEqual("110", context.Wds.FirstOrDefault(w => w.WdId == 1).PhoneNumber); var entity = context.Wds.FirstOrDefault(); Assert.AreEqual(entity.PhoneNumber, entity.PhoneNumber2); //Cd Assert.AreEqual(2, context.Cds.Count()); Assert.AreEqual("110", context.Cds.FirstOrDefault(c => c.CdId == 1).PhoneNum); Assert.AreEqual("first", context.Cds.FirstOrDefault(c => c.CdId == 1).RoadName); Assert.AreEqual(null, context.Cds.FirstOrDefault(c => c.CdId == 2).RoadName); //Cd default value,the roadnum's default value is -1 Assert.AreEqual(-1, context.Cds.FirstOrDefault(c => c.CdId == 2).RoadNum); Assert.AreEqual(null, context.Cds.FirstOrDefault(c => c.CdId == 2).RoadName); //Cd not Product Property Assert.AreEqual(10, context.Cds.FirstOrDefault(c => c.CdId == 2).AddressNumber); #endregion context.Dispose(); }
public void TestNestClass() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory); var connectString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\nestClassTest.mdf;Initial Catalog=nestClassTest;Integrated Security=True;Connect Timeout=30"; System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways <NestContext>()); var context = new NestContext(connectString); context.NestInits.Add(new NestInit()); context.SaveChanges(); var a = new A { AId = 1, B = new B { BId = 2, A = new A { AId = 3 } } }; var b = new B { BId = 1, A = new A { AId = 2, B = new B { BId = 3 } } }; using (var connection = new SqlConnection(connectString)) { connection.Open(); var aTypeAccessor = TypeAccessorManager <A> .GetAccessorByDestLabel("test1", connectString, "dbo.AAs"); var aReader = new BulkDataReader <A>(aTypeAccessor, new[] { a }); using (var aCopy = new SqlBulkCopy(connection)) { foreach (var map in aReader.ColumnMappings) { aCopy.ColumnMappings.Add(map); } aCopy.DestinationTableName = "dbo.AAs"; aCopy.WriteToServer(aReader); } var bTypeAccessor = TypeAccessorManager <B> .GetAccessorByDestLabel("test2", connectString, "dbo.BBs"); var bReader = new BulkDataReader <B>(bTypeAccessor, new[] { b }); using (var bCopy = new SqlBulkCopy(connection)) { foreach (var map in bReader.ColumnMappings) { bCopy.ColumnMappings.Add(map); } bCopy.DestinationTableName = "dbo.BBs"; bCopy.WriteToServer(aReader); } } Assert.AreEqual(1, context.AAs.FirstOrDefault().AId); Assert.AreEqual(1, context.BBs.FirstOrDefault().BId); }