Esempio n. 1
0
        public static void Test1()
        {
            Console.WriteLine("多次insert测试");
            Console.ReadLine();

            var count = 100000;

            var list = new List <Rule>();

            for (int i = 0; i < count; i++)
            {
                list.Add(new Rule()
                {
                    Name     = "test" + i,
                    Created  = DateTime.Now,
                    Enabled  = true,
                    Json     = string.Empty,
                    RuleType = 1,
                    Score    = 100,
                    Updated  = DateTime.Now
                });
            }

            var rr = new RuleRepository();

            var flist = rr.Search().OrderByDescending(b => b.Name).From(1, 2).ToList();

            var ic = rr.FromSql("select count(id) from Rules").ToScalar <string>();

            var max = rr.Search().Select(b => b.Id.Max()).ToFirstDefault().Id;
            var cou = rr.Search().Select(b => b.Id.Count()).ToFirstDefault().Id;
            var sum = rr.Search().Select(b => b.Id.Sum()).ToFirstDefault().Id;
            var avg = rr.Search().Select(b => b.Id.Avg()).ToFirstDefault().Id;

            rr.FromSql("TRUNCATE TABLE Rules").ToScalar();

            var sw = Stopwatch.StartNew();

            rr.DBContext.Insert(list);

            sw.Stop();

            Console.WriteLine("多次insert测试完成,cost:" + sw.ElapsedMilliseconds);
            Console.ReadLine();
            list.Clear();

            for (int i = 1 * count; i < 2 * count; i++)
            {
                list.Add(new Rule()
                {
                    Name     = "test" + i,
                    Created  = DateTime.Now,
                    Enabled  = true,
                    Json     = string.Empty,
                    RuleType = 1,
                    Score    = 100,
                    Updated  = DateTime.Now
                });
            }

            Console.WriteLine("批量insert测试");

            sw = Stopwatch.StartNew();

            //rr.DBContext.BulkInsert(list);


            var batch = rr.DBContext.CreateBatch <Rule>();

            batch.Insert(list);

            batch.Execute();



            sw.Stop();

            Console.WriteLine("批量insert测试完成,cost:" + sw.ElapsedMilliseconds);

            Console.ReadLine();
        }