CSFramework.EF 数据库框架 - 测试 BulkInsert 方法极速插入对象

        private void button8_Click(object sender, EventArgs e)
        {
            //
            //测试BulkInsert方法，www.csframework.com
            //
            string connString = "Server=127.0.0.1;Database=CSFrameworkV6_Normal;User ID=demo_webapi;Password=test; Max Pool Size=512; Pooling=true;Connect Timeout=30;TrustServerCertificate=true;";
            IDatabase db = DatabaseFactory.GetDatabase(DatabaseType.SqlServer, connString);

            var watch = Stopwatch.StartNew();

            var list = new List<Test_Customer>();
            for (int i = 1; i <= 1000; i++)
            {
                list.Add(NewCustomer());
            }
            int x = db.BulkInsert<Test_Customer>(list);

            watch.Stop();

            int count = db.GetQueryable<Test_Customer>().Count();

            var msg = $"成功:{x},记录数:{count},用时:{watch.ElapsedMilliseconds}(ms)";
            textBox1.Text = msg;
        }