c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

  • c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试已关闭评论
  • 187 次浏览
  • A+
所属分类:.NET技术
摘要

在2022年1月份本人做过一次sqlsugar,hisql,freesql三个框架的性能测试,上次主要是测的sqlserver下的常规插入(非bulkcopy的方式数据插入),hisql与目前比较流行的ORM框架性能测试对比 时间已经过半年,这次我就测的更完整点测试方案如下

在2022年1月份本人做过一次sqlsugar,hisql,freesql三个框架的性能测试,上次主要是测的sqlserver下的常规插入(非bulkcopy的方式数据插入),hisql与目前比较流行的ORM框架性能测试对比 时间已经过半年,这次我就测的更完整点测试方案如下

测试方案

  1. 测试四种数据库(sqlserver,mysql,oralce,postgresql) 每种数据库写一遍测试文章
  2. 常规插入和批量插入
  3. 数据量从5条到100W间的数据插入
  4. 数据列从5列和50列的各种数据类型场景
  5. 开源测试代码供各位网友查看审核是否测试公平公正

测试源码https://github.com/tansar/HiSqlTestDemo

测试环境

操作系统环境

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

sqlserver 环境

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

mysql 环境

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

oracle 环境

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

postgresql 环境

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

sqlserver 常规数据插入测试

10列以下字段测试代码如下

  public static void TestSqlServerInsert(int _count)         {        //hisql连接 请先配置好数据库连接       HiSqlClient sqlClient = Demo_Init.GetSqlClient();       //hisql需要初始货安装 只需要执行一次       sqlClient.CodeFirst.InstallHisql();         //freesql连接       IFreeSql freeClient = Demo_Init.GetFreeSqlClient();        //sqlsugar连接       SqlSugarClient sugarClient = Demo_Init.GetSugarClient();                sqlClient.CodeFirst.CreateTable(typeof(Table.HTest01));        Console.WriteLine("初始化hisql专用表成功!");        sqlClient.CodeFirst.CreateTable(typeof(Table.HTest02));         Console.WriteLine("初始化sqlsugar专用表成功!");         sqlClient.CodeFirst.CreateTable(typeof(Table.HTest03));       Console.WriteLine("初始化freesql专用表成功!");         Console.WriteLine($"测试场景 Sqlserver  向表中插入{_count}条数据 常规数据插入)");       Console.WriteLine($"用常规数据插入最适应日常应用场景");           List<object> lstobj = new List<object>();       List<Table.HTest02> lstobj2 = new List<Table.HTest02>();       List<Table.HTest03> lstobj3 = new List<Table.HTest03>();       Random random = new Random();        //插入的参数值都随机产生 以免数据库执行相同SQL时会有缓存影响测试结果       for (int i = 0; i < _count; i++)       {           //hisql可以用实体类也可以用匿名类           lstobj.Add(new Table.HTest01 { SID = (i + 1), UName = $"hisql{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"hisql初始创建" });            //sqlsugar用匿句类报错用实体类           lstobj2.Add(new Table.HTest02 { SID = (i + 1), UName = $"sqlsugar{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"sqlsugar初始创建" });           lstobj3.Add(new Table.HTest03 { SID = (i + 1), UName = $"freesql{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"freesql初始创建" });       }        //删除测试表中的数据       sqlClient.TrunCate("HTest01").ExecCommand();       sqlClient.TrunCate("HTest02").ExecCommand();       sqlClient.TrunCate("HTest03").ExecCommand();        Stopwatch sw = new Stopwatch();          #region freesql       sw.Reset();       Console.WriteLine("------------------------------");       Console.WriteLine("----------FreeSql 测试----------");       Console.WriteLine($"FreeSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");       var temp3 = freeClient.Queryable<Table.HTest03>().Where(w => w.Age < 0).ToList();       Console.WriteLine($"FreeSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");       sw.Start();       freeClient.Insert<Table.HTest03>(lstobj3).ExecuteAffrows();              sw.Stop();       Console.WriteLine($"FreeSql 数据插入{_count}条 耗时{sw.Elapsed}秒");       sw.Reset();       #endregion         #region hisql       sw.Reset();       Console.WriteLine("------------------------------");       Console.WriteLine("----------HiSql 测试----------");       Console.WriteLine($"HiSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");       var temp1 = sqlClient.Query("HTest01").Field("*").Take(1).Skip(1).ToDynamic();       Console.WriteLine($"HiSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");       sw.Start();       sqlClient.Insert("HTest01", lstobj).ExecCommand();       sw.Stop();       Console.WriteLine($"hisql 数据插入{_count}条 耗时{sw.Elapsed}秒");       sw.Reset();       #endregion 

50列字段测试代码如下

  public static void TestSqlServer50ColInsert(int _count)         {              //hisql连接 请先配置好数据库连接           HiSqlClient sqlClient = Demo_Init.GetSqlClient();           //hisql需要初始货安装 只需要执行一次           sqlClient.CodeFirst.InstallHisql();             //freesql连接           IFreeSql freeClient = Demo_Init.GetFreeSqlClient();            //sqlsugar连接           SqlSugarClient sugarClient = Demo_Init.GetSugarClient();              sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C01));            Console.WriteLine("初始化hisql专用表成功!");            sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C02));             Console.WriteLine("初始化sqlsugar专用表成功!");             sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C03));           Console.WriteLine("初始化freesql专用表成功!");             Console.WriteLine($"测试场景 Sqlserver  向表中插入{_count}条数据 50列 常规数据插入)");           Console.WriteLine($"用常规数据插入最适应日常应用场景");               List<object> lstobj = new List<object>();           List<Table.H_Test50C02> lstobj2 = new List<Table.H_Test50C02>();           List<Table.H_Test50C03> lstobj3 = new List<Table.H_Test50C03>();           Random random = new Random();            //插入的参数值都随机产生 以免数据库执行相同SQL时会有缓存影响测试结果           for (int i = 0; i < _count; i++)           {               //hisql可以用实体类也可以用匿名类               lstobj.Add(new Table.H_Test50C01 {                    Material=(900000+i).ToString(),                   Batch=(30000000+i).ToString(),                   TestNum1= random.Next(10,100),                   TestNum2 = random.Next(10, 100),                   TestNum3 = random.Next(10, 100),                   TestNum4 = random.Next(10, 100),                   TestNum5 = random.Next(10, 100),                   TestNum6 = random.Next(10, 100),                   TestNum7 = random.Next(10, 100),                   TestNum8 = random.Next(10, 100),                   TestNum9 = random.Next(10, 100),                   TestNum10 = random.Next(10, 100),                   TestNum11 = random.Next(10, 100),                   TestNum12 = random.Next(10, 100),                   TestNum13= random.Next(10, 100),                   TestNum14= random.Next(10, 100),                   TestNum15= random.Next(10, 100),                   TestStr1 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr2 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr3 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr4 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr5 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr6 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr7 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr8 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr9 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr10 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr11 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr12 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr13 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr14 = $"hisql{random.Next(1, 100).ToString()}",                   TestStr15 = $"hisql{random.Next(1, 100).ToString()}",                   TestDec1 = i+ random.Next(1, 10000)/3,                   TestDec2 = i + random.Next(1, 10000) / 3,                   TestDec3 = i + random.Next(1, 10000) / 3,                   TestDec4 = i + random.Next(1, 10000) / 3,                   TestDec5 = i + random.Next(1, 10000) / 3,                   TestDec6 = i + random.Next(1, 10000) / 3,                   TestDec7 = i + random.Next(1, 10000) / 3,                   TestDec8 = i + random.Next(1, 10000) / 3,                   TestDec9 = i + random.Next(1, 10000) / 3,                   TestDec10 = i + random.Next(1, 10000) / 3,                   TestDec11 = i + random.Next(1, 10000) / 3,                   TestDec12 = i + random.Next(1, 10000) / 3,                   TestDec13 = i + random.Next(1, 10000) / 3,                   TestDec14 = i + random.Next(1, 10000) / 3,                   TestDec15 = i + random.Next(1, 10000) / 3,                   Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"hisql初始创建" });                //sqlsugar用匿句类报错用实体类               lstobj2.Add(new Table.H_Test50C02               {                   Material = (900000 + i).ToString(),                   Batch = (30000000 + i).ToString(),                   TestNum1 = random.Next(10, 100),                   TestNum2 = random.Next(10, 100),                   TestNum3 = random.Next(10, 100),                   TestNum4 = random.Next(10, 100),                   TestNum5 = random.Next(10, 100),                   TestNum6 = random.Next(10, 100),                   TestNum7 = random.Next(10, 100),                   TestNum8 = random.Next(10, 100),                   TestNum9 = random.Next(10, 100),                   TestNum10 = random.Next(10, 100),                   TestNum11 = random.Next(10, 100),                   TestNum12 = random.Next(10, 100),                   TestNum13 = random.Next(10, 100),                   TestNum14 = random.Next(10, 100),                   TestNum15 = random.Next(10, 100),                   TestStr1 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr2 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr3 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr4 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr5 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr6 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr7 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr8 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr9 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr10 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr11 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr12 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr13 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr14 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestStr15 = $"sqlsugar{random.Next(1, 100).ToString()}",                   TestDec1 = i + random.Next(1, 10000) / 3,                   TestDec2 = i + random.Next(1, 10000) / 3,                   TestDec3 = i + random.Next(1, 10000) / 3,                   TestDec4 = i + random.Next(1, 10000) / 3,                   TestDec5 = i + random.Next(1, 10000) / 3,                   TestDec6 = i + random.Next(1, 10000) / 3,                   TestDec7 = i + random.Next(1, 10000) / 3,                   TestDec8 = i + random.Next(1, 10000) / 3,                   TestDec9 = i + random.Next(1, 10000) / 3,                   TestDec10 = i + random.Next(1, 10000) / 3,                   TestDec11 = i + random.Next(1, 10000) / 3,                   TestDec12 = i + random.Next(1, 10000) / 3,                   TestDec13 = i + random.Next(1, 10000) / 3,                   TestDec14 = i + random.Next(1, 10000) / 3,                   TestDec15 = i + random.Next(1, 10000) / 3,                   Salary = 5000 + (i % 2000) + random.Next(10),                   Descript = $"sqlsugar初始创建"               });               lstobj3.Add(new Table.H_Test50C03               {                   Material = (900000 + i).ToString(),                   Batch = (30000000 + i).ToString(),                   TestNum1 = random.Next(10, 100),                   TestNum2 = random.Next(10, 100),                   TestNum3 = random.Next(10, 100),                   TestNum4 = random.Next(10, 100),                   TestNum5 = random.Next(10, 100),                   TestNum6 = random.Next(10, 100),                   TestNum7 = random.Next(10, 100),                   TestNum8 = random.Next(10, 100),                   TestNum9 = random.Next(10, 100),                   TestNum10 = random.Next(10, 100),                   TestNum11 = random.Next(10, 100),                   TestNum12 = random.Next(10, 100),                   TestNum13 = random.Next(10, 100),                   TestNum14 = random.Next(10, 100),                   TestNum15 = random.Next(10, 100),                   TestStr1 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr2 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr3 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr4 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr5 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr6 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr7 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr8 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr9 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr10 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr11 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr12 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr13 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr14 = $"freesql{random.Next(1, 100).ToString()}",                   TestStr15 = $"freesql{random.Next(1, 100).ToString()}",                   TestDec1 = i + random.Next(1, 10000) / 3,                   TestDec2 = i + random.Next(1, 10000) / 3,                   TestDec3 = i + random.Next(1, 10000) / 3,                   TestDec4 = i + random.Next(1, 10000) / 3,                   TestDec5 = i + random.Next(1, 10000) / 3,                   TestDec6 = i + random.Next(1, 10000) / 3,                   TestDec7 = i + random.Next(1, 10000) / 3,                   TestDec8 = i + random.Next(1, 10000) / 3,                   TestDec9 = i + random.Next(1, 10000) / 3,                   TestDec10 = i + random.Next(1, 10000) / 3,                   TestDec11 = i + random.Next(1, 10000) / 3,                   TestDec12 = i + random.Next(1, 10000) / 3,                   TestDec13 = i + random.Next(1, 10000) / 3,                   TestDec14 = i + random.Next(1, 10000) / 3,                   TestDec15 = i + random.Next(1, 10000) / 3,                   Salary = 5000 + (i % 2000) + random.Next(10),                   Descript = $"freesql初始创建"               });           }            //删除测试表中的数据           sqlClient.TrunCate("H_Test50C01").ExecCommand();           sqlClient.TrunCate("H_Test50C02").ExecCommand();           sqlClient.TrunCate("H_Test50C03").ExecCommand();            Stopwatch sw = new Stopwatch();              #region freesql           sw.Reset();           Console.WriteLine("------------------------------");           Console.WriteLine("----------FreeSql 测试----------");           Console.WriteLine($"FreeSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           var temp3 = freeClient.Queryable<Table.H_Test50C03>().Where(w => w.TestDec1 < 0).ToList();           Console.WriteLine($"FreeSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           sw.Start();           freeClient.Insert<Table.H_Test50C03>(lstobj3).ExecuteAffrows();            sw.Stop();           Console.WriteLine($"FreeSql 数据插入{_count}条 耗时{sw.Elapsed}秒");           sw.Reset();           #endregion             #region hisql           sw.Reset();           Console.WriteLine("------------------------------");           Console.WriteLine("----------HiSql 测试----------");           Console.WriteLine($"HiSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           var temp1 = sqlClient.Query("H_Test50C01").Field("*").Take(1).Skip(1).ToDynamic();           Console.WriteLine($"HiSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           sw.Start();           sqlClient.Insert("H_Test50C01", lstobj).ExecCommand();           sw.Stop();           Console.WriteLine($"hisql 数据插入{_count}条 耗时{sw.Elapsed}秒");           sw.Reset();           #endregion                 #region sqlsugar           sw.Reset();           Console.WriteLine("------------------------------");           Console.WriteLine("----------SqlSugar 测试----------");           Console.WriteLine($"SqlSugar 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           var temp2 = sugarClient.Queryable<Table.H_Test50C03>("H_Test50C03").Where(w => w.TestDec1 < 1).ToList();           Console.WriteLine($"sqlsugar  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");           sw.Start();           sugarClient.Insertable(lstobj2).AS("H_Test50C03").ExecuteCommand();           sw.Stop();           Console.WriteLine($"sqlsugar 数据插入{_count}条 耗时{sw.Elapsed}秒");           sw.Reset();           #endregion       } 

测试结果

5条记录10列以下测试结果截图

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

5条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

500条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

500条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

1000条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

1000条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

5000条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

5000条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

10000条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

10000条记录50列测就结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50000条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50000条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100000条记录10列以下测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100000条记录50列测试结果截图
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

sqlsugar 在执行此操作时抛出异常
错误提示:System.Data.SqlClient.SqlException:“资源池“default”没有足够的系统内存来运行此查询
在单独只执行sqlsugar的测试样例依然报此错误 通过分析sqlsugar的底层执行逻辑是因为它把所有的插入都拼成了一个插入sql文档造成的

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

测试结果

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

sqlserver 批量(bulkcopy)数据插入测试

可能会有很多人认为如果大批量数据插入肯定不会用常规的方式插入应该用BulkCopy的方式插入,好,那么我们再来测测基于数据库厂商提供的SDK驱动自带的BulkCopy再来对比一下三个框架的性能

10列以下批量插入的bulkcopy测试代码

public static void TestSqlServerBulkCopy(int _count)         {              //hisql连接 请先配置好数据库连接             HiSqlClient sqlClient = Demo_Init.GetSqlClient();             //hisql需要初始货安装 只需要执行一次             sqlClient.CodeFirst.InstallHisql();               //freesql连接             IFreeSql freeClient = Demo_Init.GetFreeSqlClient();              //sqlsugar连接             SqlSugarClient sugarClient = Demo_Init.GetSugarClient();                sqlClient.CodeFirst.CreateTable(typeof(Table.HTest01));              Console.WriteLine("初始化hisql专用表成功!");              sqlClient.CodeFirst.CreateTable(typeof(Table.HTest02));               Console.WriteLine("初始化sqlsugar专用表成功!");               sqlClient.CodeFirst.CreateTable(typeof(Table.HTest03));             Console.WriteLine("初始化freesql专用表成功!");               Console.WriteLine($"测试场景 Sqlserver  向表中插入{_count}条数据 BulkCopy方式插入");             Console.WriteLine($"适用于大量数据导入场景");                 List<object> lstobj = new List<object>();             List<Table.HTest02> lstobj2 = new List<Table.HTest02>();             List<Table.HTest03> lstobj3 = new List<Table.HTest03>();             Random random = new Random();              //插入的参数值都随机产生 以免数据库执行相同SQL时会有缓存影响测试结果             for (int i = 0; i < _count; i++)             {                 //hisql可以用实体类也可以用匿名类                 lstobj.Add(new Table.HTest01 { SID = (i + 1), UName = $"hisql{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"hisql初始创建" });                  //sqlsugar用匿句类报错用实体类                 lstobj2.Add(new Table.HTest02 { SID = (i + 1), UName = $"sqlsugar{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"sqlsugar初始创建" });                 lstobj3.Add(new Table.HTest03 { SID = (i + 1), UName = $"freesql{i}", Age = 20 + (i % 50), Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"freesql初始创建" });             }              //删除测试表中的数据             sqlClient.TrunCate("HTest01").ExecCommand();             sqlClient.TrunCate("HTest02").ExecCommand();             sqlClient.TrunCate("HTest03").ExecCommand();              Stopwatch sw = new Stopwatch();                #region freesql             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------FreeSql 测试----------");             Console.WriteLine($"FreeSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp3 = freeClient.Queryable<Table.HTest03>().Where(w => w.Age < 0).ToList();             Console.WriteLine($"FreeSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             //freeClient.Insert<Table.HTest03>(lstobj3).ExecuteAffrows();             freeClient.Insert<Table.HTest03>(lstobj3).ExecuteSqlBulkCopy();             sw.Stop();             Console.WriteLine($"FreeSql 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion               #region hisql             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------HiSql 测试----------");             Console.WriteLine($"HiSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp1 = sqlClient.Query("HTest01").Field("*").Take(1).Skip(1).ToDynamic();             Console.WriteLine($"HiSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             //sqlClient.Insert("HTest01", lstobj).ExecCommand();              sqlClient.BulkCopyExecCommand("HTest01", lstobj);             sw.Stop();             Console.WriteLine($"hisql 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion                   #region sqlsugar             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------SqlSugar 测试----------");             Console.WriteLine($"SqlSugar 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp2 = sugarClient.Queryable<Table.HTest02>("HTest02").Where(w => w.Age < 1).ToList();             Console.WriteLine($"sqlsugar  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             //sugarClient.Insertable(lstobj2).AS("HTest02").ExecuteCommand();             sugarClient.Fastest<Table.HTest02>().BulkCopy(lstobj2);             sw.Stop();             Console.WriteLine($"sqlsugar 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion         } 

50列批量插入的bulkcopy测试代码

public static void TestSqlServer50ColInsert(int _count)         {              //hisql连接 请先配置好数据库连接             HiSqlClient sqlClient = Demo_Init.GetSqlClient();             //hisql需要初始货安装 只需要执行一次             sqlClient.CodeFirst.InstallHisql();               //freesql连接             IFreeSql freeClient = Demo_Init.GetFreeSqlClient();              //sqlsugar连接             SqlSugarClient sugarClient = Demo_Init.GetSugarClient();                sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C01));              Console.WriteLine("初始化hisql专用表成功!");              sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C02));               Console.WriteLine("初始化sqlsugar专用表成功!");               sqlClient.CodeFirst.CreateTable(typeof(Table.H_Test50C03));             Console.WriteLine("初始化freesql专用表成功!");               Console.WriteLine($"测试场景 Sqlserver  向表中插入{_count}条数据 50列 常规数据插入)");             Console.WriteLine($"适用于大量数据导入场景");                 List<object> lstobj = new List<object>();             List<Table.H_Test50C02> lstobj2 = new List<Table.H_Test50C02>();             List<Table.H_Test50C03> lstobj3 = new List<Table.H_Test50C03>();             Random random = new Random();              //插入的参数值都随机产生 以免数据库执行相同SQL时会有缓存影响测试结果             for (int i = 0; i < _count; i++)             {                 //hisql可以用实体类也可以用匿名类                 lstobj.Add(new Table.H_Test50C01 {                      Material=(900000+i).ToString(),                     Batch=(30000000+i).ToString(),                     TestNum1= random.Next(10,100),                     TestNum2 = random.Next(10, 100),                     TestNum3 = random.Next(10, 100),                     TestNum4 = random.Next(10, 100),                     TestNum5 = random.Next(10, 100),                     TestNum6 = random.Next(10, 100),                     TestNum7 = random.Next(10, 100),                     TestNum8 = random.Next(10, 100),                     TestNum9 = random.Next(10, 100),                     TestNum10 = random.Next(10, 100),                     TestNum11 = random.Next(10, 100),                     TestNum12 = random.Next(10, 100),                     TestNum13= random.Next(10, 100),                     TestNum14= random.Next(10, 100),                     TestNum15= random.Next(10, 100),                     TestStr1 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr2 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr3 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr4 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr5 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr6 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr7 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr8 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr9 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr10 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr11 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr12 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr13 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr14 = $"hisql{random.Next(1, 100).ToString()}",                     TestStr15 = $"hisql{random.Next(1, 100).ToString()}",                     TestDec1 = i+ random.Next(1, 10000)/3,                     TestDec2 = i + random.Next(1, 10000) / 3,                     TestDec3 = i + random.Next(1, 10000) / 3,                     TestDec4 = i + random.Next(1, 10000) / 3,                     TestDec5 = i + random.Next(1, 10000) / 3,                     TestDec6 = i + random.Next(1, 10000) / 3,                     TestDec7 = i + random.Next(1, 10000) / 3,                     TestDec8 = i + random.Next(1, 10000) / 3,                     TestDec9 = i + random.Next(1, 10000) / 3,                     TestDec10 = i + random.Next(1, 10000) / 3,                     TestDec11 = i + random.Next(1, 10000) / 3,                     TestDec12 = i + random.Next(1, 10000) / 3,                     TestDec13 = i + random.Next(1, 10000) / 3,                     TestDec14 = i + random.Next(1, 10000) / 3,                     TestDec15 = i + random.Next(1, 10000) / 3,                     Salary = 5000 + (i % 2000) + random.Next(10), Descript = $"hisql初始创建" });                  //sqlsugar用匿句类报错用实体类                 lstobj2.Add(new Table.H_Test50C02                 {                     Material = (900000 + i).ToString(),                     Batch = (30000000 + i).ToString(),                     TestNum1 = random.Next(10, 100),                     TestNum2 = random.Next(10, 100),                     TestNum3 = random.Next(10, 100),                     TestNum4 = random.Next(10, 100),                     TestNum5 = random.Next(10, 100),                     TestNum6 = random.Next(10, 100),                     TestNum7 = random.Next(10, 100),                     TestNum8 = random.Next(10, 100),                     TestNum9 = random.Next(10, 100),                     TestNum10 = random.Next(10, 100),                     TestNum11 = random.Next(10, 100),                     TestNum12 = random.Next(10, 100),                     TestNum13 = random.Next(10, 100),                     TestNum14 = random.Next(10, 100),                     TestNum15 = random.Next(10, 100),                     TestStr1 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr2 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr3 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr4 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr5 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr6 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr7 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr8 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr9 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr10 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr11 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr12 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr13 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr14 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestStr15 = $"sqlsugar{random.Next(1, 100).ToString()}",                     TestDec1 = i + random.Next(1, 10000) / 3,                     TestDec2 = i + random.Next(1, 10000) / 3,                     TestDec3 = i + random.Next(1, 10000) / 3,                     TestDec4 = i + random.Next(1, 10000) / 3,                     TestDec5 = i + random.Next(1, 10000) / 3,                     TestDec6 = i + random.Next(1, 10000) / 3,                     TestDec7 = i + random.Next(1, 10000) / 3,                     TestDec8 = i + random.Next(1, 10000) / 3,                     TestDec9 = i + random.Next(1, 10000) / 3,                     TestDec10 = i + random.Next(1, 10000) / 3,                     TestDec11 = i + random.Next(1, 10000) / 3,                     TestDec12 = i + random.Next(1, 10000) / 3,                     TestDec13 = i + random.Next(1, 10000) / 3,                     TestDec14 = i + random.Next(1, 10000) / 3,                     TestDec15 = i + random.Next(1, 10000) / 3,                     Salary = 5000 + (i % 2000) + random.Next(10),                     Descript = $"sqlsugar初始创建"                 });                 lstobj3.Add(new Table.H_Test50C03                 {                     Material = (900000 + i).ToString(),                     Batch = (30000000 + i).ToString(),                     TestNum1 = random.Next(10, 100),                     TestNum2 = random.Next(10, 100),                     TestNum3 = random.Next(10, 100),                     TestNum4 = random.Next(10, 100),                     TestNum5 = random.Next(10, 100),                     TestNum6 = random.Next(10, 100),                     TestNum7 = random.Next(10, 100),                     TestNum8 = random.Next(10, 100),                     TestNum9 = random.Next(10, 100),                     TestNum10 = random.Next(10, 100),                     TestNum11 = random.Next(10, 100),                     TestNum12 = random.Next(10, 100),                     TestNum13 = random.Next(10, 100),                     TestNum14 = random.Next(10, 100),                     TestNum15 = random.Next(10, 100),                     TestStr1 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr2 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr3 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr4 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr5 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr6 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr7 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr8 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr9 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr10 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr11 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr12 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr13 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr14 = $"freesql{random.Next(1, 100).ToString()}",                     TestStr15 = $"freesql{random.Next(1, 100).ToString()}",                     TestDec1 = i + random.Next(1, 10000) / 3,                     TestDec2 = i + random.Next(1, 10000) / 3,                     TestDec3 = i + random.Next(1, 10000) / 3,                     TestDec4 = i + random.Next(1, 10000) / 3,                     TestDec5 = i + random.Next(1, 10000) / 3,                     TestDec6 = i + random.Next(1, 10000) / 3,                     TestDec7 = i + random.Next(1, 10000) / 3,                     TestDec8 = i + random.Next(1, 10000) / 3,                     TestDec9 = i + random.Next(1, 10000) / 3,                     TestDec10 = i + random.Next(1, 10000) / 3,                     TestDec11 = i + random.Next(1, 10000) / 3,                     TestDec12 = i + random.Next(1, 10000) / 3,                     TestDec13 = i + random.Next(1, 10000) / 3,                     TestDec14 = i + random.Next(1, 10000) / 3,                     TestDec15 = i + random.Next(1, 10000) / 3,                     Salary = 5000 + (i % 2000) + random.Next(10),                     Descript = $"freesql初始创建"                 });             }              //删除测试表中的数据             sqlClient.TrunCate("H_Test50C01").ExecCommand();             sqlClient.TrunCate("H_Test50C02").ExecCommand();             sqlClient.TrunCate("H_Test50C03").ExecCommand();              Stopwatch sw = new Stopwatch();                #region freesql             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------FreeSql 测试----------");             Console.WriteLine($"FreeSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp3 = freeClient.Queryable<Table.H_Test50C03>().Where(w => w.TestDec1 < 0).ToList();             Console.WriteLine($"FreeSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             freeClient.Insert<Table.H_Test50C03>(lstobj3).ExecuteAffrows();              sw.Stop();             Console.WriteLine($"FreeSql 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion               #region hisql             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------HiSql 测试----------");             Console.WriteLine($"HiSql 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp1 = sqlClient.Query("H_Test50C01").Field("*").Take(1).Skip(1).ToDynamic();             Console.WriteLine($"HiSql  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             sqlClient.Insert("H_Test50C01", lstobj).ExecCommand();             sw.Stop();             Console.WriteLine($"hisql 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion                   #region sqlsugar             sw.Reset();             Console.WriteLine("------------------------------");             Console.WriteLine("----------SqlSugar 测试----------");             Console.WriteLine($"SqlSugar 预热...{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             var temp2 = sugarClient.Queryable<Table.H_Test50C03>("H_Test50C03").Where(w => w.TestDec1 < 1).ToList();             Console.WriteLine($"sqlsugar  正在插入数据t{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}");             sw.Start();             sugarClient.Insertable(lstobj2).AS("H_Test50C03").ExecuteCommand();             sw.Stop();             Console.WriteLine($"sqlsugar 数据插入{_count}条 耗时{sw.Elapsed}秒");             sw.Reset();             #endregion         } 

测试结果

1W条数据10列以下字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

1W条数据50列字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

5W条数据10列以下字段bulkcpy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

5W条数据50列字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

10W条数据10列以下字段Bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

10W条数据50列字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

20w条数据10列以下字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

20w条数据50列字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50w条数据10列字段Bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

50w条数据50列字段BulkCopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100W条10列以下字段bulkCopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

100W条数据50列字段bulkcopy插入测试
c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

测试结果

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试

总结

我想不用总结了 三个ORM不管是按常规插入和bulkcopy插入谁快认慢一目了然,不过我还是想贴上以下图

c# sqlsugar,hisql,freesql orm框架全方位性能测试对比 sqlserver 性能测试