Пример #1
0
        public static void Bulk()
        {
            if (Db.DbMaintenance.IsAnyTable("UnitIdentity1", false))
            {
                Db.DbMaintenance.DropTable("UnitIdentity1");
            }
            Db.CodeFirst.InitTables <UnitIdentity1>();
            Db.DbMaintenance.TruncateTable <UnitIdentity1>();
            var data = new UnitIdentity1()
            {
                Name = "jack"
            };

            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data
            });
            var list = Db.Queryable <UnitIdentity1>().ToList();

            if (list.Count != 1 || data.Name != list.First().Name)
            {
                throw new Exception("unit Bulk");
            }
            data.Name = "2";
            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data,
                data
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.Count != 3 || !list.Any(it => it.Name == "2"))
            {
                throw new Exception("unit Bulk");
            }
            Db.Fastest <UnitIdentity1>().BulkUpdate(new List <UnitIdentity1>()
            {
                new UnitIdentity1()
                {
                    Id   = 1,
                    Name = "222"
                },
                new UnitIdentity1()
                {
                    Id   = 2,
                    Name = "111"
                }
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.First(it => it.Id == 1).Name != "222")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 2).Name != "111")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 3).Name != "2")
            {
                throw new Exception("unit Bulk");
            }
            Db.CodeFirst.InitTables <UnitIdentity111>();
            Db.DbMaintenance.TruncateTable <UnitIdentity111>();
            var count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkCopy(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });

            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkUpdate(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });
            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            Db.CodeFirst.InitTables <UnitTable001>();
            Db.Fastest <UnitTable001>().BulkUpdate(new List <UnitTable001> {
                new UnitTable001()
                {
                    Id = 1, table = "a"
                }
            });

            Db.CodeFirst.InitTables <UnitBulk23131>();
            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = false
                }
            });
            var list1 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list1.First().table == true, "unit error");
            Db.Fastest <UnitBulk23131>().BulkUpdate(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = true
                }
            });
            var list2 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list2.First().table == false, "unit error");

            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = true
                }
            });
            var list3 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list3.First().table == false, "unit error");
            Db.Fastest <UnitBulk23131>().BulkUpdate(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = false
                }
            });
            list3 = Db.Queryable <UnitBulk23131>().ToList();
            SqlSugar.Check.Exception(list3.First().table == true, "unit error");

            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = null
                }
            });
            var list4 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list4.First().table == true, "unit error");
        }
Пример #2
0
        public static void Bulk()
        {
            Db.CodeFirst.InitTables <UnitIdentity1>();
            Db.DbMaintenance.TruncateTable <UnitIdentity1>();
            var data = new UnitIdentity1()
            {
                Name = "jack"
            };

            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data
            });
            var list = Db.Queryable <UnitIdentity1>().ToList();

            if (list.Count != 1 || data.Name != list.First().Name)
            {
                throw new Exception("unit Bulk");
            }
            data.Name = "2";
            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data,
                data
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.Count != 3 || !list.Any(it => it.Name == "2"))
            {
                throw new Exception("unit Bulk");
            }
            Db.Fastest <UnitIdentity1>().BulkUpdate(new List <UnitIdentity1>()
            {
                new UnitIdentity1()
                {
                    Id   = 1,
                    Name = "222"
                },
                new UnitIdentity1()
                {
                    Id   = 2,
                    Name = "111"
                }
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.First(it => it.Id == 1).Name != "222")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 2).Name != "111")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 3).Name != "2")
            {
                throw new Exception("unit Bulk");
            }

            Db.CodeFirst.InitTables <UnitIdentity111>();
            Db.DbMaintenance.TruncateTable <UnitIdentity111>();
            var count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkCopy(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });

            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkUpdate(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });
            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            Db.CodeFirst.InitTables <UnitTable001>();
            Db.Fastest <UnitTable001>().BulkUpdate(new List <UnitTable001> {
                new UnitTable001()
                {
                    Id = 1, table = "a"
                }
            });
        }
Пример #3
0
        public static void Bulk()
        {
            Db.CodeFirst.InitTables <UnitIdentity1>();
            Db.DbMaintenance.TruncateTable <UnitIdentity1>();
            var data = new UnitIdentity1()
            {
                Name = "jack"
            };

            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data
            });
            var list = Db.Queryable <UnitIdentity1>().ToList();

            if (list.Count != 1 || data.Name != list.First().Name)
            {
                throw new Exception("unit Bulk");
            }
            data.Name = "2";
            Db.Fastest <UnitIdentity1>().BulkCopy(new List <UnitIdentity1>()
            {
                data,
                data
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.Count != 3 || !list.Any(it => it.Name == "2"))
            {
                throw new Exception("unit Bulk");
            }
            Db.Fastest <UnitIdentity1>().BulkUpdate(new List <UnitIdentity1>()
            {
                new UnitIdentity1()
                {
                    Id   = 1,
                    Name = "222"
                },
                new UnitIdentity1()
                {
                    Id   = 2,
                    Name = "111"
                }
            });
            list = Db.Queryable <UnitIdentity1>().ToList();
            if (list.First(it => it.Id == 1).Name != "222")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 2).Name != "111")
            {
                throw new Exception("unit Bulk");
            }
            if (list.First(it => it.Id == 3).Name != "2")
            {
                throw new Exception("unit Bulk");
            }
            Db.CodeFirst.InitTables <UnitIdentity111>();
            Db.DbMaintenance.TruncateTable <UnitIdentity111>();
            var count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkCopy(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });

            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            count = Db.Fastest <UnitIdentity111111111>().AS("UnitIdentity111").BulkUpdate(new List <UnitIdentity111111111> {
                new UnitIdentity111111111()
                {
                    Id = 1, Name = "jack"
                }
            });
            if (count == 0)
            {
                throw new Exception("unit Bulk");
            }
            Db.CodeFirst.InitTables <UnitTable001>();
            Db.Fastest <UnitTable001>().BulkUpdate(new List <UnitTable001> {
                new UnitTable001()
                {
                    Id = 1, table = "a"
                }
            });

            Db.CodeFirst.InitTables <UnitBulk23131>();
            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = false
                }
            });
            var list1 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list1.First().table == true, "unit error");
            Db.Fastest <UnitBulk23131>().BulkUpdate(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = true
                }
            });
            var list2 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list2.First().table == false, "unit error");

            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = true
                }
            });
            var list3 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list3.First().table == false, "unit error");
            Db.Fastest <UnitBulk23131>().BulkUpdate(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = false
                }
            });
            list3 = Db.Queryable <UnitBulk23131>().ToList();
            SqlSugar.Check.Exception(list3.First().table == true, "unit error");

            Db.DbMaintenance.TruncateTable <UnitBulk23131>();
            Db.Fastest <UnitBulk23131>().BulkCopy(new List <UnitBulk23131> {
                new UnitBulk23131()
                {
                    Id    = 1,
                    table = null
                }
            });
            var list4 = Db.Queryable <UnitBulk23131>().ToList();

            SqlSugar.Check.Exception(list4.First().table == true, "unit error");

            Db.CodeFirst.InitTables <UnitBulkCopy1231>();
            Db.CodeFirst.InitTables <UnitDatum>();
            var rootData  = Db.Utilities.DeserializeObject <Rootobject>(bulkData1);
            var inserData = rootData.data.ToList();
            var num       = Db.Fastest <UnitDatum>().BulkCopy(inserData);

            SqlSugar.Check.Exception(num != 20, "unit error");
        }