public static void Backup()
{
var db = DbMocker.NewDataBase();
//List<UserInfo> list = new List<UserInfo>();
//for (int i = 0; i < 10; i++)
//{
// var user1 = new UserInfo
// {
// Name = "NameInsert" + i,
// Age = 20 + 16,
// DTCreate = new DateTime(1985, 1, 1),
// Role = RoleType.经理
// };
// list.Add(user1);
// //db.Insert(user1);
//}
////db.InsertBulk(list);
//db.InsertBatch(list, new BatchOptions() { BatchSize = 30 });
BackupOption option = new BackupOption();
option.BackupExportType = BackupExportType.InsertSQL;
option.EnableSqlFilter = false;
option.SQL = "";// "SELECT * FROM TB_USER WHERE ID >0 AND ID <=10 ORDER BY ID ";
var result = db.Backup <UserInfo>(option);
Console.WriteLine(result.ToString());
}
public static void Batch()
{
var db = DbMocker.NewDataBase();
int total = 0;
var batch = db.NewBatchCommand(new BatchOptions()
{
BatchSize = 3, StatementSeperator = ";"
});
string command = "update tb_user2 set name ='sdfdf' where id = 3";
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
batch.AddOrProcess(batch.CreateCommand(command));
PrintHelper.WriteLine("");
}
public static void InsertBatch()
{
var db = DbMocker.NewDataBase();
// db.Config.EnableOrmLog = false;
// db.Config.EnableDebug = true;
// db.Config.Interceptors.Add(new ConnectionTestIntercept());
//var user1 = new UserInfo
//{
// Name = "NameInsert",
// Age = 20 + 16,
// DTCreate = new DateTime(1985, 1, 1)
//};
//db.Insert(user1);
List <UserInfo> list = new List <UserInfo>();
for (int i = 0; i < 100; i++)
{
var user1 = new UserInfo
{
Name = "NameInsert" + i,
Age = 20 + 16,
DTCreate = new DateTime(1985, 1, 1),
Role = RoleType.经理
};
list.Add(user1);
//db.Insert(user1);
}
db.InsertBulk(list);
// db.InsertBatch(list, 1000);
}
public static void Convert()
{
var db = DbMocker.NewDataBase();
int total = 0;
var pgp = Predicates.Group(GroupOperator.And);
var sortGroup = Predicates.SortGroup();
sortGroup.Add(Predicates.Sort("", false));
var datapage = db.GetPage <UserInfo>(1, 10, pgp, sortGroup, out total).ToList();
var list22 = db.ExecuteReader("SELECT * FROM TB_USER ");
// var list33 = list22.ToModel<object>();
var list = db.ExecuteList <object>("SELECT * FROM TB_USER2 ");
// var list = db.ExecuteReader("SELECT * FROM TB_USER2 ").ToEnumerable<UserInfo>();
//var Model = db.ExecuteModel<UserInfo>("SELECT * FROM TB_USER2 ");
//var o = db.ExecuteDictionary<string, int>("SELECT T.NAME, SUM(T.Id) FROM TB_USER T GROUP BY T.NAME");
PrintHelper.WriteLine(list.Count.ToString());
}
public static void Insert()
{
var db = DbMocker.NewDataBase();
//db.Config.EnableOrmLog = false;
//db.Config.EnableDebug = true;
//db.Config.KeepConnectionAlive = true;
//db.Config.Interceptors.Add(new ConnectionTestIntercept());
var data1 = db.FluentSqlBuilder.Select <UserInfo>().ExecuteList();
data1 = db.FluentSqlBuilder.Select <UserInfo>().ExecuteList();
UserInfo info = new UserInfo();
info.Age = 67;
info.Email = "*****@*****.**";
info.Name = "李威法";
info.DTCreate = DateTime.Now;
var ddd = db.Insert <UserInfo>(info, null);
var user1 = new UserInfo
{
Name = "NameInsert",
Age = 20 + 16,
DTCreate = DateTime.Now
};
db.Insert(user1);
//db.Connection.ExecuteScalarAsync
}
public static void TestOptExt()
{
var db = DbMocker.NewDataBase();
//var one = db.FirstOrDefault<UserInfo>(p => p.Id > 1);
var one2 = db.Get <UserInfo>(500);
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("Name", "dsfsdfdsf");
parameters.Add("Age", 33);
Dictionary <string, object> conditons = new Dictionary <string, object>();
conditons.Add("Name", "dsfsdfdsf");
conditons.Add("Age", 33);
db.InsertByKV <UserInfo>(parameters);
var count = db.CountByKV <UserInfo>(conditons);
var countLong = db.LongCountByKV <UserInfo>(conditons);
// db.UpdateBySQL("update TB_USER2 set name = 'sdfdfs' where id = 400");
var dd2 = db.UpdateByKV <UserInfo>(parameters, conditons);
var dd3 = db.DeleteByKV <UserInfo>(conditons);
var o = db.DeleteById <UserInfo>(500);
db.DeleteByIds <UserInfo>("Id", " 1,2,3");
}
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);
}
//public static void PetapocoNormal(int takeCount)
//{
// using (var petapoco = new PetaPoco.Database(DbHelper.ConnectionString, "System.Data.SqlClient"))
// {
// petapoco.OpenSharedConnection();
// var list = petapoco.Fetch<UserInfo>(string.Format("select top {0} * from TB_USER", takeCount.ToString()));
// }
//}
//public static void PetapocoFast(int takeCount)
//{
// using (var petapoco = new PetaPoco.Database(DbHelper.ConnectionString, "System.Data.SqlClient"))
// {
// petapoco.OpenSharedConnection();
// petapoco.EnableAutoSelect = false;
// petapoco.EnableNamedParams = false;
// petapoco.ForceDateTimesToUtc = false;
// var list = petapoco.Fetch<UserInfo>(string.Format("select top {0} * from TB_USER", takeCount.ToString()));
// }
//}
//public static void OrmLiteNormal(int takeCount)
//{
// OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance; //Using SQL Server
// var c = DbHelper.CreateConnection();
// c.Close();
// IDbCommand ormLiteCmd = c.CreateCommand();
// ormLiteCmd.Select<UserInfo>(string.Format("select top {0} * from TB_USER", takeCount.ToString()));
//}
//public static void SimpleDataFast(int takeCount)
//{
// // Simple.Data
// var sdb = Simple.Data.Database.OpenConnection(DbHelper.ConnectionString);
// IEnumerable<dynamic> d = sdb.UserInfo.All();
// var data = d.Take(takeCount);
//}
public static void Page()
{
var db = DbMocker.NewDataBase();
int total = 0;
var list = db.GetPageByWhere <UserInfo>(1, 5, "Age > 10", "", out total);
PrintHelper.WriteLine(total + "=" + list.Count());
}
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();
}
public static void QueryMutil()
{
var db = DbMocker.NewDataBase();
string sqlDemo1 = @"SELECT * FROM TB_USER AS u WHERE u.Id=@UserId
SELECT * FROM TB_USER AS ui WHERE ui.Id=2";
using (var multi = db.GetMultiple(sqlDemo1, new { UserId = 1 }))
{
var user = multi.Read <UserInfo>().FirstOrDefault();
var userinfo = multi.Read <UserInfo>().FirstOrDefault();
}
}
static void ConstructTest()
{
var db1 = DbMocker.NewDataBase();
db1.EnsureOpenConnection();
//PrintHelper.WriteLine(db1.Connection?.State + "=" + db1.GetHashCode());
for (var b = 0; b < 50; b++)
{
//Task task = new Task( () => {
var db = DbMocker.NewDataBase();
// db.EnsureOpenConnection();
var list3 = db.ExecuteScalar <int>("select id from tb_user where id = 1"); //.ExecuteReader("select * from tb_user").ToList<UserInfo>();// db.Query<UserInfo>().ToList();
var ddd = db.Get <UserInfo>(1);
//}
//PrintHelper.WriteLine(db.Connection?.State + "=" + db.GetHashCode());
//});
//task.Start();
}
//Task.Factory.StartNew(() =>
//{
// using (var db = DbMocker.NewDataBase())
// {
// var list = db.ExecuteScalar("select 1 from tb_user");// db.Query<UserInfo>().ToList();
// var db1 = DbMocker.NewDataBase();
// int total = 0;
// var list2 = db1.GetPageByWhere<UserInfo>(1, 5, "Age > 10", "", out total).ToList();
// var db2 = DbMocker.NewDataBase();
// var list3 = db2.ExecuteScalar("select 1 from tb_user");//.ExecuteReader("select * from tb_user").ToList<UserInfo>();// db.Query<UserInfo>().ToList();
// db2.Close();
// db1.Close();
// db.Close();
// }
//});
//
//System.Threading.Thread.Sleep(500);
//var db = DbMocker.NewDataBase();
// var db = DbMocker.InstanceDataBase().OpenNewConnection();
}
public static void Insert()
{
var db = DbMocker.NewDataBase();
//db.Config.EnableOrmLog = false;
//db.Config.EnableDebug = true;
//db.Config.Interceptors.Add(new ConnectionTestIntercept());
//var user1 = new UserInfo
//{
// Name = "NameInsert",
// Age = 20 + 16,
// DTCreate = DateTime.Now
//};
//db.Insert(user1);
//var user1 = new UserInfo() { Id = 1, Name = "Name1", HasDelete = true };
//var snap = Snapshotter.Track(db, user1);
//Snapshotter.SetGlobalIgnoreUpdatedColumns("Role", "DTCReaTE");
var id = 1;
var user1 = db.Get <UserInfo>(id);
var snap = db.Track <UserInfo>(user1);
var user = new UserInfo();
user.Id = 1;
user.Name = Guid.NewGuid().ToString();
// user.Sex = 1;
//user.HasDelete = 1;
user.DTCreate = new DateTime(2002, 1, 1);
user.Age = 21;
user.Role = RoleType.经理;
user.StatusCode = 0;
//user1.CopyPropertiesFrom(user, "DTCReate");
IDictionary <string, object> condition1 = new Dictionary <string, object>();
condition1.Add("Name", "dfsd");
condition1.Add("Id", 5);
//
var count2 = snap.UpdateWithIgnoreParams(user, null, po => po.Age, po => po.Email);
var count = snap.Update(user, null, "");
Console.WriteLine(snap.Changes().Count);
Console.WriteLine("UpdatedColumns:");
foreach (var item in snap.UpdatedColumns())
{
Console.WriteLine(item);
}
}
public static void Page()
{
var db = DbMocker.NewDataBase();
UserInfo user = new UserInfo();
user.Age = 2;
user.Id = 1;
user.Name = "sdf";
var existss2 = db.Exists <UserInfo>(f => f.Age == RoleType.管理员.GetHashCode());
var existss = db.Exists <UserInfo>(f => f.Age > user.Age && f.Name == user.Name && f.Id != user.Id);
string sql = "select * from TB_USER2 where Age > 10 AND AGE > :P0";
int totalCount = 0;
Dictionary <string, object> ps = new Dictionary <string, object>();
ps.Add("P0", 34);
var reader = db.ExecuteReader(sql, ps);
//var expando = reader.ToExpandoObjects();
var data = db.GetPageBySQL <UserInfo>(1, 10, sql, " Age ASC ", ps, out totalCount);
int total = 0;
var predicateGroup = new PredicateGroup {
Operator = GroupOperator.And, Predicates = new List <IPredicate>()
};
predicateGroup.Predicates.Add(Predicates.Field <UserInfo>(f => f.Age, Operator.Gt, 10));
predicateGroup.Predicates.Add(Predicates.Field <UserInfo>(f => f.Name, Operator.Eq, null, true));
predicateGroup.Predicates.Add(Predicates.Field <UserInfo>(f => f.Name, Operator.Like, "NameInse%"));
predicateGroup.Predicates.Add(Predicates.Field <UserInfo>(f => f.DTCreate, Operator.Ge, new DateTime(1982, 5, 8)));
predicateGroup.Predicates.Add(Predicates.Field <UserInfo>(f => f.DTCreate, Operator.Le, DateTime.Now));
IList <ISort> sortGroup = new List <ISort>();
var Sort = Predicates.Sort <UserInfo>(f => f.DTCreate, false);
sortGroup.Add(Sort);
var listExt = db.GetPage <UserInfo>(0, 5, predicateGroup, sortGroup, out total);
//db = DbMocker.NewDataBase(DatabaseType.SQLite);
//listExt = db.GetPage<UserInfo>(1, 5, predicateGroup, sortGroup, out total);
var list = db.GetPageByWhere <UserInfo>(0, 5, "Age > 10", "", out total);
PrintHelper.WriteLine(total + "=" + list.Count());
}
public static void NestedTransactionThatFailsAbortsWholeUsingBeginAbort()
{
var db = DbMocker.NewDataBase();
db.BeginTransaction();
db.BeginTransaction();
var user1 = new UserInfo
{
Name = "Name" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1985, 1, 1)
};
db.Insert(user1);
var extra1 = new UserInfo
{
Id = user1.Id,
Email = "email" + 16 + "@email.com",
Name = "Name" + 17
};
db.Insert(extra1);
db.RollbackTransaction();
var user3 = new UserInfo
{
Name = "Name" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1970, 1, 1).AddYears(16)
};
db.Insert(user3);
db.CommitTransaction();
var count = db.ExecuteScalar <long>("SELECT COUNT(*) FROM TB_USER");
}
public static void NestedTransactionsBothCompleteUsingBeginAbort()
{
var db = DbMocker.NewDataBase();
db.BeginTransaction();
var user = new UserInfo
{
Name = "Name" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1970, 1, 1).AddYears(16)
};
db.Insert(user);
db.BeginTransaction();
var user1 = new UserInfo
{
Name = "Name" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1970, 1, 1).AddYears(16)
};
db.Insert(user1);
var extra1 = new UserInfo
{
Name = "Name" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1970, 1, 1).AddYears(16)
};
db.Insert(extra1);
db.CommitTransaction();
db.CommitTransaction();
PrintHelper.WriteLine("Finish");
}
public static void InsertExecute()
{
var db = DbMocker.NewDataBase();
IDictionary <string, object> pars = new Dictionary <string, object>();
IDictionary <string, object> RealParameters = new Dictionary <string, object>();
//pars.Add("Id", 2);
pars.Add("Name", "dd3");
pars.Add("Sex", null);
pars.Add("DTCreate", DateTime.Now);
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions.Add("Id", 2);
conditions.Add("Name", "552");
conditions.Add("Sex", true);
int exeCount = db.Insert("TB_USER", pars);
exeCount = db.Update("TB_USER", pars, conditions);
exeCount = db.Delete("TB_USER", conditions);
string[] selectCols = { "Id", "Name as dd" };
var sorts = Predicates.SortGroup();
sorts.Add(Predicates.Sort("DTCreate", true));
sorts.Add(Predicates.Sort("Id", false));
// var data = db.Query("TB_USER", selectCols, conditions, sorts).ToDictionary<string, object>();
exeCount = db.Count("TB_USER", conditions);
Console.WriteLine(exeCount);
foreach (var item in RealParameters)
{
Console.WriteLine(item.Key + "=" + item.Value);
}
}
public static void Insert()
{
var db = DbMocker.NewDataBase();
IDictionary <string, object> pars = new Dictionary <string, object>();
IDictionary <string, object> RealParameters = new Dictionary <string, object>();
pars.Add("Id", 2);
pars.Add("Name", "dd3");
pars.Add("Sex", null);
pars.Add("DTCreate", DateTime.Now);
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions.Add("Id", 2);
conditions.Add("Name", "552");
conditions.Add("Sex", true);
string sql = db.SqlGenerator.SqlCustomGenerator.Insert("TB_USER", pars, out RealParameters);
// sql = db.SqlGenerator.SqlCustomGenerator.Update("TB_USER", pars,conditions, out RealParameters);
// sql = db.SqlGenerator.SqlCustomGenerator.Delete("TB_USER", conditions, out RealParameters);
string[] selectCols = { "Id", "Name as dd" };
var sorts = Predicates.SortGroup();
sorts.Add(Predicates.Sort("DTCreate", true));
sorts.Add(Predicates.Sort("Id", false));
sql = db.SqlGenerator.SqlCustomGenerator.Select("TB_USER", selectCols, conditions, sorts, out RealParameters);
sql = db.SqlGenerator.SqlCustomGenerator.Count("TB_USER", conditions, out RealParameters);
Console.WriteLine(sql);
foreach (var item in RealParameters)
{
Console.WriteLine(item.Key + "=" + item.Value);
}
}
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 Gen()
{
var db = DbMocker.NewDataBase();
db.GenerateCode();
// var option = new CodeGenOption();
// option.Enable = true;
// option.OutputDir = PathHelper.CombineWithBaseDirectory("puredata_gen");
// option.FilterTablePrefixs = "TB_;B_";
// option.Namespace = "Pure.Test.Domain";
//// option.IncludeTableNames = "tb_user;";
// option.ClassNameMode = ClassNameMode.UpperOrigin;
// option.PropertyNameMode = ClassNameMode.UpperOrigin;
// var result = CodeGenHelper.Instance.Gen(db, DbMigrateService.Instance, option);
// Console.WriteLine(result.ToString());
}
static void PureDataQueryTest3(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 = "TransactionTest";
Console.Title = title;
CodeTimer.Time(title, 1, () => {
using (var db = DbMocker.NewDataBase())
{
var count = db.ExecuteScalar <long>("SELECT COUNT(*) FROM TB_USER");
PrintHelper.WriteLine("count=" + count);
}
//NestedTransactionThatFailsAbortsWholeUsingBeginAbort();
//NestedTransactionsBothCompleteUsingBeginAbort();
});
Console.Read();
}
public static void Convert()
{
var db = DbMocker.NewDataBase();
Expression2SqlTest.UserInfoMapper mapper = new Expression2SqlTest.UserInfoMapper();
UserInfo v = new UserInfo();
v.Name = "http://www.sdfd.com";
v.Age = 1;
v.Email = "*****@*****.**";
v.Name = "<script>alert(3242)</script>";
var result = mapper.Validate(db, v, "Age");
var result2 = db.Validate(v, m => m.Name, m => m.Age);
var result3 = mapper.Validate(db, v);
Console.WriteLine(result.ToString());
Console.WriteLine(result2.ToString());
Console.WriteLine(result3.ToString());
}
public static void Update()
{
var db = DbMocker.NewDataBase();
var user1 = new UserInfo
{
Name = "NameTest" + 16,
Age = 20 + 16,
DTCreate = new DateTime(1985, 1, 1)
};
int id = 5;
var dd = db.Get <UserInfo>(id);
dd.Name = "5345435";
var co = db.Update <UserInfo>(dd);
db.Update <UserInfo>(() => new UserInfo {
Age = 88, Name = "李玮峰"
}, p => p.Id == 5);
// db.Update<UserInfo>(() => {return user1;}, p => p.Id == 5);
}
public static void Query()
{
var db = DbMocker.NewDataBase();
int total = 0;
string name = null;
UserInfo predict = new UserInfo();
predict.Id = 2;
predict.Name = "lee";
predict.DTCreate = DateTime.Now;
//string[] names = null;
var names = new List <string>()
{
"23", "44"
};
var one = db.Get <UserInfo>(5);
var o = db.ExecuteDictionary <string, int>("SELECT T.NAME, SUM(T.Id) FROM TB_USER T GROUP BY T.NAME");
db = DbMocker.NewDataBase();
db.Delete <UserInfo>(p => names.Contains(p.Name));
string name1 = "gsfdgdf";
var list2 = db.Query <UserInfo>(p => p.Name == name1 && SqlFuncs.In(p.Name, names));
db = DbMocker.NewDataBase();
var list3 = db.Query <UserInfo>(p => p.Name == name1 && names.Contains(p.Name));
//var list = db.Query<UserInfo>(p => predict.Id < p.Id).ToList();
//var list1 = db.Query<UserInfo>(p =>p.Id > predict.Id && p.Name.Contains(predict.Name) && p.DTCreate > predict.DTCreate || p.Id > 0).ToList();
//var list2 = db.Query<UserInfo>(p => predict.DTCreate<p.DTCreate).ToList();
PrintHelper.WriteLine("");
}
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();
}
public static async Task SqlMapMethodTest()
{
var db = DbMocker.NewDataBase();
try
{
List <UserInfo> dd = new List <UserInfo>();
dd.Add(new UserInfo()
{
Name = "fdd", Id = 32
});
dd.Add(new UserInfo()
{
Name = "范德萨", Id = 22
});
db = DbMocker.NewDataBase();
var user = new UserInfo()
{
Id = 9, Name = "'eo\"莱卡布\""
};
var resultGetListLinqTest = db.QuerySqlMap("TB_USER", "GetListLinqTest", new { Name = "fsdsd", ID = 2, Nam = "23", LikeNames = dd, Ids = new long[] { 1, 2, 3, 4 } });
db.LogHelper.Write(resultGetListLinqTest.RawSql);
var result6 = db.QuerySqlMap("TB_USER", "GetListInclude", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
db.LogHelper.Write(result6.RawSql);
var resultGetListForeachIncludeIfTest = db.QuerySqlMap("TB_USER", "GetListForeachIncludeIfTest", new { Name = "fsdsd", ID = 2, Nam = "23", LikeNames = dd, Ids = new long[] { 1, 2, 3, 4 } });
var dataGetListForeachIncludeIfTest = resultGetListForeachIncludeIfTest.ExecuteList <object>();
var resultGetListChooseTest = db.QuerySqlMap("TB_USER", "GetListChooseTest", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
var dataGetListChooseTest = resultGetListChooseTest.ExecuteList <object>();
var resultupdateUserSetTest = db.QuerySqlMap("TB_USER", "updateUserSetTest", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
var dataupdateUserSetTest = resultupdateUserSetTest.ExecuteList <object>();
var resultGetListTrimTest = db.QuerySqlMap("TB_USER", "GetListTrimTest", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
var dataGetListTrimTest = resultGetListTrimTest.ExecuteList <object>();
var resultGetListBindTest = db.QuerySqlMap("TB_USER", "GetListBindTest", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
var dataGetListBindTest = resultGetListBindTest.ExecuteList <object>();
var result55 = db.QuerySqlMap("TB_USER", "GetListIfTest", new { Name = "fsdsd", ID = 2, Nam = "23", Ids = new long[] { 1, 2, 3, 4 } });
db.LogHelper.Write(result55.Sql);
var data55 = result55.ExecuteList <object>();
//var result88 = await db.UpdateOnlyAsync<UserInfo>(user,null, "Name", "Age");
//var result5 = db.QuerySqlMap("TB_USER", "GetListTest", new { Name="fsdsd", ID = 2, Nam="23", Ids = new long[] { 1, 2, 3, 4 } });
//db.LogHelper.Write(result5.Sql);
//db.LogHelper.Write("------------rawsql: " + result5.RawSql);
//var data5 = result5.ExecuteList<object>();
//List<UserInfo> dd = new List<UserInfo>();
//dd.Add(new UserInfo() { Name = "fdd", Id = 32 });
//dd.Add(new UserInfo() { Name = "范德萨", Id = 22 });
// dd = null;
//var result2 = db.QuerySqlMap("TB_USER", "GetListByFor", new { Id = 9, Name = "eo", OrderBy = 3, Yes = true, No = true, LikeNames = dd });
//db.LogHelper.Write(result2.Sql);
//db.LogHelper.Write("------------rawsql: " + result2.RawSql);
//var data2 = result2.ExecuteList<UserInfo>();
//var TestVari = db.QuerySqlMap("TB_USER", "TestVari", new { tablename = "tablename2", ordertext = "name", orderdesc = "desc", Yes = true, Name = "" });
//db.LogHelper.Write(TestVari.Sql);
//db.LogHelper.Write("------------rawsql: " + TestVari.RawSql);
//int total = 0;
//var result44 = db.QuerySqlMap("TB_USER", "GetList", new { tablename = "刚发的", Id = 9, Name = "'eo\"莱卡布\"", Ids = new long[] { 1, 2, 3, 4 } });
//var data44 = result44.ExecutePageList<UserInfo>(1, 10, out total, "");
////获取列表In
//var result = db.QuerySqlMap("TB_USER", "GetList", new { Ids = new long[] { 1, 2, 3, 4 } });
//db.LogHelper.Write(result.Sql);
//db.LogHelper.Write("------------rawsql: "+result.RawSql);
//var data = result.ExecuteList<UserInfo>();
////组合查询
//var result1 = db.QuerySqlMap("TB_USER", "GetListCombine", new { Id = 9, Name = "'eo\"莱卡布\"" });
//db.LogHelper.Write(result1.Sql);
//db.LogHelper.Write("------------rawsql: " + result1.RawSql);
//var data1 = result1.ExecuteList<UserInfo>();
//db = DbMocker.NewDataBase();
//var result2 = db.QuerySqlMap("TB_USER", "GetListInclude", new { Id = 9, Name = "eo", OrderBy = 3, Yes = true, No = true, LikeNames = new string[] { "2", "55" } });
//db.LogHelper.Write(result2.Sql);
//db.LogHelper.Write("------------rawsql: " + result2.RawSql);
//var data2 = result2.ExecuteList<UserInfo>();
// System.Threading.Thread.Sleep(2 * 1000);
}
catch (Exception ex)
{
db.LogHelper.Error(ex);
throw;
}
finally
{
db.Close();
}
}
public static void Constuct()
{
using (var db = DbMocker.NewDataBase())
{
}
}
public static void CreateDataBase()
{
using (var db = DbMocker.NewDataBase())
{
}
}
