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