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