这篇文章受大家邀请，与 SqlSugar 做一次简单的性能测试对比。主要针对插入、批量插入、批量更新、读取性能的测试；
测试环境.net core 2.2
FreeSql 0.3.17
sqlSugarCore 4.9.9.3
sqlserver 14.00.1000 Express、mysql 5.6
测试项目以 console 程序，创建步骤：
1、dotnet new console
2、dotnet add package FreeSql
3、dotnet add package sqlSugarCore
编码的过程这个错误来自 sugar 创建数据库的时候，实体定义如下：
sugar的没有同步上来。
暂时先用 freesql 帮 sugar 创建了表。。。创建完后如下：
运行时又出现如下错误：
需要加一堆 IsIgnore
是的，还在报错，最终原因是我传入的 songs 是 IEnumerable，然后接受的参数类型正常应该是 Song[]，希望作者看到了可以改进。
然后上面提到的批量更新，今天先到这吧。下次有兴致了再测试。
其他库我就不测试了，谢谢观看！请求献上宝贵的一星。
github：https://github.com/2881099/FreeSql
最终的测试代码 using FreeSql.DataAnnotations; using SqlSugar; using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Text; namespace orm_vs { class Program { static IFreeSql fsql = new FreeSql.FreeSqlBuilder() //.UseConnectionString(FreeSql.DataType.SqlServer, "Data Source=.;Integrated Security=True;Initial Catalog=freesqlTest;Pooling=true;Max Pool Size=20") .UseConnectionString(FreeSql.DataType.MySql, "Data Source=127.0.0.1;Port=3306;User ID=root;Password=root;Initial Catalog=cccddd;Charset=utf8;SslMode=none;Max pool size=20") .UseAutoSyncStructure(false) .UseNoneCommandParameter(true) //.UseConfigEntityFromDbFirst(true) .Build(); static SqlSugarClient sugar { get => new SqlSugarClient(new ConnectionConfig() { //不欺负，让连接池100个最小 //ConnectionString = "Data Source=.;Integrated Security=True;Initial Catalog=freesqlTest;Pooling=true;Min Pool Size=100;Max Pool Size=20", //DbType = DbType.SqlServer, ConnectionString = "Data Source=127.0.0.1;Port=3306;User ID=root;Password=root;Initial Catalog=cccddd;Charset=utf8;SslMode=none;Min Pool Size=20;Max Pool Size=20", DbType = DbType.MySql, IsAutoCloseConnection = true, InitKeyType = InitKeyType.Attribute }); } static StringBuilder sb = new StringBuilder(); static void Main(string[] args) { fsql.CodeFirst.SyncStructure(typeof(Song), typeof(Song_tag), typeof(Tag)); sugar.CodeFirst.InitTables(typeof(Song), typeof(Song_tag), typeof(Tag)); //sugar创建表失败：SqlSugar.SqlSugarException: Sequence contains no elements //测试前清空数据 fsql.Delete<Song>().Where(a => a.Id > 0).ExecuteAffrows(); sugar.Deleteable<Song>().Where(a => a.Id > 0).ExecuteCommand(); Console.WriteLine("插入性能："); Insert(1000, 1); Console.Write(sb.ToString()); sb.Clear(); Insert(1000, 10); Console.Write(sb.ToString()); sb.Clear(); Insert(1, 1000); Console.Write(sb.ToString()); sb.Clear(); Insert(1, 10000); Console.Write(sb.ToString()); sb.Clear(); Insert(1, 50000); Console.Write(sb.ToString()); sb.Clear(); Console.WriteLine("查询性能："); Select(1000, 1); Console.Write(sb.ToString()); sb.Clear(); Select(1000, 10); Console.Write(sb.ToString()); sb.Clear(); Select(1, 1000); Console.Write(sb.ToString()); sb.Clear(); Select(1, 10000); Console.Write(sb.ToString()); sb.Clear(); Select(1, 50000); Console.Write(sb.ToString()); sb.Clear(); Select(1, 100000); Console.Write(sb.ToString()); sb.Clear(); Console.Write(sb.ToString()); Console.WriteLine("测试结束，按任意键退出..."); Console.ReadKey(); } static void Select(int forTime, int size) { Stopwatch sw = new Stopwatch(); sw.Restart(); for (var a = 0; a < forTime; a++) fsql.Select<Song>().Limit(size).ToList(); sw.Stop(); sb.AppendLine($"FreeSql Select {size}条数据，循环{forTime}次，耗时{sw.ElapsedMilliseconds}ms"); sw.Restart(); for (var a = 0; a < forTime; a++) sugar.Queryable<Song>().Take(size).ToList(); sw.Stop(); sb.AppendLine($"SqlSugar Select {size}条数据，循环{forTime}次，耗时{sw.ElapsedMilliseconds}ms\r\n"); } static void Insert(int forTime, int size) { var songs = Enumerable.Range(0, size).Select(a => new Song { Create_time = DateTime.Now, Is_deleted = false, Title = $"Insert_{a}", Url = $"Url_{a}" }).ToArray(); //预热 fsql.Insert(songs.First()).ExecuteAffrows(); sugar.Insertable(songs.First()).ExecuteCommand(); Stopwatch sw = new Stopwatch(); sw.Restart(); for (var a = 0; a < forTime; a++) fsql.Insert(songs.AsEnumerable()).ExecuteAffrows(); sw.Stop(); sb.AppendLine($"FreeSql Insert {size}条数据，循环{forTime}次，耗时{sw.ElapsedMilliseconds}ms"); sw.Restart(); for (var a = 0; a < forTime; a++) sugar.Insertable(songs).ExecuteCommand(); sw.Stop(); sb.AppendLine($"SqlSugar Insert {size}条数据，循环{forTime}次，耗时{sw.ElapsedMilliseconds}ms\r\n"); } } [Table(Name = "freesql_song")] [SugarTable("sugar_song")] public class Song { [Column(IsIdentity = true)] [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } public DateTime? Create_time { get; set; } public bool? Is_deleted { get; set; } public string Title { get; set; } public string Url { get; set; } [SugarColumn(IsIgnore = true)] public virtual ICollection<Tag> Tags { get; set; } } [Table(Name = "freesql_song_tag")] [SugarTable("sugar_song_tag")] public class Song_tag { public int Song_id { get; set; } [SugarColumn(IsIgnore = true)] public virtual Song Song { get; set; } public int Tag_id { get; set; } [SugarColumn(IsIgnore = true)] public virtual Tag Tag { get; set; } } [Table(Name = "freesql_tag")] [SugarTable("sugar_tag")] public class Tag { [Column(IsIdentity = true)] [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } public int? Parent_id { get; set; } [SugarColumn(IsIgnore = true)] public virtual Tag Parent { get; set; } public decimal? Ddd { get; set; } public string Name { get; set; } [SugarColumn(IsIgnore = true)] public virtual ICollection<Song> Songs { get; set; } [SugarColumn(IsIgnore = true)] public virtual ICollection<Tag> Tags { get; set; } } }