static void Test7() { var dal = UserX.Meta.Session.Dal; dal.Db.DataCache = 3; var list = UserX.FindAll(); var u = UserX.FindByID(1); var n = UserX.FindCount(); var sql = "select * from user"; var ds = dal.Select(sql); ds = dal.Select(sql, CommandType.Text); ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>()); var dt = dal.Query(sql, new Dictionary <String, Object>()); n = dal.SelectCount(sql, CommandType.Text); var sb = SelectBuilder.Create("select roleid,count(*) from user group by roleid order by count(*) desc"); ds = dal.Select(sb, 3, 5); dt = dal.Query(sb, 4, 6); n = dal.SelectCount(sb); for (var i = 0; i < 10; i++) { Console.WriteLine(i); list = UserX.FindAll(); u = UserX.FindByKey(1); n = UserX.FindCount(); ds = dal.Select(sql); ds = dal.Select(sql, CommandType.Text); ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>()); dt = dal.Query(sql, new Dictionary <String, Object>()); n = dal.SelectCount(sql, CommandType.Text); ds = dal.Select(sb, 3, 5); dt = dal.Query(sb, 4, 6); n = dal.SelectCount(sb); Thread.Sleep(1000); } }
static void Test7() { var set = XCode.Setting.Current; //set.Debug = true; set.ShowSQL = false; //XCode.Cache.CacheBase.Debug = true; var dal = UserX.Meta.Session.Dal; dal.Db.DataCache = 3; var list = UserX.FindAll(null, null, null, 1, 20); var u = UserX.FindByKey(1); var n = UserX.FindCount(); Console.WriteLine("总数据:{0:n0}", n); //using (var tr = UserX.Meta.CreateTrans()) //{ // u = new UserX // { // Name = Rand.NextString(8), // DisplayName = Rand.NextString(16) // }; // u.Insert(); // if (Rand.Next(2) == 1) tr.Commit(); //} Task.Run(() => { var us = new List <UserX>(); for (var i = 0; i < 1_000_000; i++) { var entity = new UserX { Name = Rand.NextString(8), DisplayName = Rand.NextString(16) }; us.Add(entity); } us.Insert(true); }); var sql = "select * from user limit 20"; var ds = dal.Select(sql); ds = dal.Select(sql, CommandType.Text); ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>()); var dt = dal.Query(sql, new Dictionary <String, Object>()); n = dal.SelectCount(sql, CommandType.Text); var sb = SelectBuilder.Create("select roleid,count(*) from user group by roleid order by count(*) desc"); ds = dal.Select(sb, 3, 5); dt = dal.Query(sb, 4, 6); n = dal.SelectCount(sb); for (var i = 0; i < 20; i++) { //Console.WriteLine(i); var sw = Stopwatch.StartNew(); list = UserX.FindAll(null, null, null, 1, 20); u = UserX.FindByKey(1); n = UserX.FindCount(); ds = dal.Select(sql); ds = dal.Select(sql, CommandType.Text); ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>()); dt = dal.Query(sql, new Dictionary <String, Object>()); n = dal.SelectCount(sql, CommandType.Text); ds = dal.Select(sb, 3, 5); dt = dal.Query(sb, 4, 6); n = dal.SelectCount(sb); sw.Stop(); XTrace.WriteLine("{0} {1:n0}us", i, sw.Elapsed.TotalMilliseconds * 1000); Thread.Sleep(1000); } }