public async static void InsertBatch()
{
//var table = new DataTable("Batcher");
//table.Columns.Add("Id", typeof(int));
//table.Columns.Add("Name1", typeof(string));
//table.Columns.Add("Name2", typeof(string));
//table.Columns.Add("Name3", typeof(string));
//table.Columns.Add("Name4", typeof(string));
////构造100000条数据
//for (var i = 0; i < 100000; i++)
//{
// table.Rows.Add(i, i.ToString(), i.ToString(), i.ToString(), i.ToString());
//}
var db = DbMocker.InstanceDataBase();
////db.InsertBatch(table, new BatchOptions() { BatchSize=10000});
//db.InsertBulk(table);
var list = new List <UserInfo>();
for (var i = 0; i < 1000; i++)
{
list.Add(new UserInfo()
{
Id = i, Name = "Jesica-" + i, Age = 88, DTCreate = DateTime.Now, Email = i.ToString(), Role = RoleType.普通用户, HasDelete = false, StatusCode = 1
});
}
//await db.InsertBulkAsync(list);
await db.InsertBatchAsync(list);
}
static void PureDataQueryTest(int takeCount)
{
var db = DbMocker.InstanceDataBase().OpenSharedConnection();
db.Config.EnableOrmLog = false;
db.Config.EnableDebug = false;
db.Config.EnableIntercept = false;
var list = db.QueryBySQL <UserInfo>(string.Format("select top {0} * from TB_USER", takeCount.ToString())).ToList();
}
static void PureDataQueryTest2(int takeCount, int id)
{
//using (var db = DbMocker.NewDataBase())
{
//single
var db = DbMocker.InstanceDataBase();
//single but new connection
//var db = DbMocker.InstanceDataBase().CreateNewConnection();
db.Config.EnableOrmLog = false;
db.Config.EnableDebug = false;
db.Config.EnableIntercept = false;
//db.DatabaseConfig.EnableDebug = true;
//db.DatabaseConfig.Interceptors.Add(new ConnectionTestIntercept());
// var list = db.Query<UserInfo>(p => p.Id > id, (p) => { p.Top(takeCount); }).ToList(); // string.Format("select top {0} * from TB_USER where Id>@Id", takeCount.ToString(), new { Id = id })).ToList();
var predict = Predicates.Field <UserInfo>(f => f.Id, Operator.Gt, id, false);
var list = db.Query <UserInfo>(predict).ToList();
//PrintHelper.WriteLine(list.Count.ToString());
}
}
public static void Test()
{
string title = "CRUDTest";
Console.Title = title;
var db = DbMocker.InstanceDataBase();
//db.Config.EnableOrmLog = false;
//db.Config.EnableDebug = true;
//db.Config.Interceptors.Add(new ConnectionTestIntercept());
PrintHelper.WriteLine("Add ConnectionTestIntercept");
db.LogHelper.Write("Add ConnectionTestIntercept");
CodeTimer.Time(title, 100, () => {
//Insert();
Update(db);
});
Console.Read();
}
public static void Test()
{
string title = "ClassMapTest";
Console.Title = title;
var db = DbMocker.InstanceDataBase();
db.Config.EnableDebug = false;
db.Config.EnableOrmCache = false;
db.Config.EnableOrmLog = false;
db.Config.EnableIntercept = false;
CodeTimer.Time(title, 1, () => {
GetAttributeMap(db);
//LoadAll(db);
});
Console.Read();
}
public static void Test()
{
string title = "FluentExpressionSqlBuilderTest";
Console.Title = title;
var db = DbMocker.InstanceDataBase();
//db.Config.EnableOrmLog = false;
//db.Config.EnableDebug = true;
//db.Config.Interceptors.Add(new ConnectionTestIntercept());
//db.LogHelper.Write("Add ConnectionTestIntercept");
CodeTimer.Time(title, 1, () => {
//CreateSql(db);
//Update(db);
//FetchWhereExpression(db);
Query(db);
});
Console.Read();
}
public static void Migrate2()
{
var db = DbMocker.InstanceDataBase();
}
