public void TestNestClass()
        {
            var connectString = TestUtils.GetLocalDBConnectionString();
            Database.SetInitializer(new DropCreateDatabaseAlways<NestContext>());
            var context = new NestContext(connectString);
            context.NestInits.Add(new NestInit());
            context.SaveChanges();

            var a1 = new ABulk {};
            var a2 = new ABulk {B = new B { } };
            var a3 = new ABulk {B = new B { Value2 = "a" } };
            var a4 = new ABulk {Value1 = "a", B = new B { Value2 = "a" } };
            
            using (var connection = new SqlConnection(connectString))
            {
                connection.Open();
                var aTypeAccessor = TypeAccessorManager<ABulk>.GetAccessorForTable(new TargetTable("NestClassTest", connectString, "dbo.AEFs"));
                var aReader = new BulkDataReader<ABulk>(aTypeAccessor, new[] { a1, a2, a3, a4 });
                using (var aCopy = new SqlBulkCopy(connection))
                {
                    foreach (var map in aReader.ColumnMappings)
                    {
                        aCopy.ColumnMappings.Add(map);
                    }
                    aCopy.DestinationTableName = "dbo.AEFs";
                    aCopy.WriteToServer(aReader);
                }
            }

            Assert.AreEqual(1, context.AAs.FirstOrDefault().Id);
            Assert.AreEqual(1, context.AAs.Count(a => a.Value1 == "a"));
            Assert.AreEqual(3, context.AAs.Count(a => a.Value1 == "-"));
            Assert.AreEqual(2, context.AAs.Count(a => a.Value2 == "a"));
            Assert.AreEqual(2, context.AAs.Count(a => a.Value2 == "--"));
        }
        public void TestReferenceLoopDepth()
        {
            var connectString = TestUtils.GetLocalDBConnectionString();
            //init database
            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>.GetAccessorForTable(new TargetTable(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 TestReader()
        {
            var connectString = TestUtils.GetLocalDBConnectionString();
            //init database
            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>.GetAccessorForTable(new TargetTable(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>.GetAccessorForTable(new TargetTable(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>.GetAccessorForTable(
                        new TargetTable(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();

        }
Exemple #5
0
        public void TestReader()
        {
            var connectString = TestUtils.GetLocalDBConnectionString("TestReader2");
            //init database
            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> .GetAccessorForTable(new TargetTable(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> .GetAccessorForTable(new TargetTable(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> .GetAccessorForTable(
                        new TargetTable(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);
        }