FreeSql.Provider.MySql 3.5.213-preview20250815

🦄 FreeSql, The First AOT ORM!

FreeSql is a powerful O/RM component, supports .NET Core 2.1+, .NET Framework 4.0+, Xamarin, And AOT.

English | 中文

🛠 Support CodeFirst data migration.
💻 Support DbFirst import entity class from database, or use Generation Tool.
⛳ Support advanced type mapping, such as PostgreSQL array type, etc.
🌲 Support expression functions, and customizable analysis.
🏁 Support one-to-many and many-to-many navigation properties, include and lazy loading.
📃 Support Read/Write separation, Splitting Table/Database, Global filters, Optimistic and pessimistic locker.
🌳 Support MySql/SqlServer/PostgreSQL/Oracle/Sqlite/Firebird/达梦/人大金仓/南大通用/虚谷/神舟通用/翰高/ClickHouse/DuckDB/TDengine/QuestDB/MsAccess, etc.

QQ Groups：561616019(available)、4336577(full)、8578575(full)、52508226(full)

📚 Documentation


Get started \| Select \| Update \| Insert \| Delete \| FAQ
Expression \| CodeFirst \| DbFirst \| Filters \| AOP
Repository \| UnitOfWork \| Dynamic Operations \| ADO
Read/Write \| Splitting Table \| Hide tech \| Update Notes

Please select a development mode:

Use FreeSql, keep the original usage.
Use FreeSql.DbContext, Repository + UnitOfWork.
Use FreeSql.BaseEntity, Simple mode.

Some open source projects that use FreeSql:

🚀 Quick start

dotnet add package FreeSql.Provider.Sqlite

static IFreeSql fsql = new FreeSql.FreeSqlBuilder()
  .UseConnectionString(FreeSql.DataType.Sqlite, @"Data Source=document.db")
  .UseAutoSyncStructure(true) //automatically synchronize the entity structure to the database
  .Build(); //be sure to define as singleton mode

class Song {
  [Column(IsIdentity = true)]
  public int Id { get; set; }
  public string Title { get; set; }
  public string Url { get; set; }
  public DateTime CreateTime { get; set; }
  
  public ICollection<Tag> Tags { get; set; }
}
class Song_tag {
  public int Song_id { get; set; }
  public Song Song { get; set; }
  
  public int Tag_id { get; set; }
  public Tag Tag { get; set; }
}
class Tag {
  [Column(IsIdentity = true)]
  public int Id { get; set; }
  public string Name { get; set; }
  
  public int? Parent_id { get; set; }
  public Tag Parent { get; set; }
  
  public ICollection<Song> Songs { get; set; }
  public ICollection<Tag> Tags { get; set; }
}

🔎 Query

//OneToOne、ManyToOne
fsql.Select<Tag>().Where(a => a.Parent.Parent.Name == "English").ToList();

//OneToMany
fsql.Select<Tag>().IncludeMany(a => a.Tags, then => then.Where(sub => sub.Name == "foo")).ToList();

//ManyToMany
fsql.Select<Song>()
  .IncludeMany(a => a.Tags, then => then.Where(sub => sub.Name == "foo"))
  .Where(s => s.Tags.Any(t => t.Name == "Chinese"))
  .ToList();

//Other
fsql.Select<YourType>()
  .Where(a => a.IsDelete == 0)
  .WhereIf(keyword != null, a => a.UserName.Contains(keyword))
  .WhereIf(role_id > 0, a => a.RoleId == role_id)
  .Where(a => a.Nodes.Any(t => t.Parent.Id == t.UserId))
  .Count(out var total)
  .Page(page, size)
  .OrderByDescending(a => a.Id)
  .ToList()

More..

fsql.Select<Song>().Where(a => new[] { 1, 2, 3 }.Contains(a.Id)).ToList();

fsql.Select<Song>().Where(a => a.CreateTime.Date == DateTime.Today).ToList();

fsql.Select<Song>().OrderBy(a => Guid.NewGuid()).Limit(10).ToList();

fsql.Select<Song>().ToList(a => new
{
    a.Id,
    Tags = fsql.Select<Tag>().ToList(),
    SongTags = fsql.Select<SongTag>().Where(b => b.TopicId == a.Id).ToList()
});

More..

🚁 Repository

dotnet add package FreeSql.Repository

[Transactional]
public void Add() {
  var repo = ioc.GetService<BaseRepository<Tag>>();
  repo.DbContextOptions.EnableCascadeSave = true;

  var item = new Tag {
    Name = "testaddsublist",
    Tags = new[] {
      new Tag { Name = "sub1" },
      new Tag { Name = "sub2" }
    }
  };
  repo.Insert(item);
}

Reference: Use TransactionalAttribute and UnitOfWorkManager in ASP.NET Core to Achieve the Multiple Transaction Propagation.

💪 Performance

FreeSql Query & Dapper Query

Elapsed: 00:00:00.6733199; Query Entity Counts: 131072; ORM: Dapper

Elapsed: 00:00:00.4554230; Query Tuple Counts: 131072; ORM: Dapper

Elapsed: 00:00:00.6846146; Query Dynamic Counts: 131072; ORM: Dapper

Elapsed: 00:00:00.6818111; Query Entity Counts: 131072; ORM: FreeSql*

Elapsed: 00:00:00.6060042; Query Tuple Counts: 131072; ORM: FreeSql*

Elapsed: 00:00:00.4211323; Query ToList<Tuple> Counts: 131072; ORM: FreeSql*

Elapsed: 00:00:01.0236285; Query Dynamic Counts: 131072; ORM: FreeSql*

FreeSql ToList & Dapper Query

Elapsed: 00:00:00.6707125; ToList Entity Counts: 131072; ORM: FreeSql*

Elapsed: 00:00:00.6495301; Query Entity Counts: 131072; ORM: Dapper

More..

👯 Contributors

And other friends who made important suggestions for this project, they include:

systemhejiyong, LambertW, mypeng1985, stulzq, movingsam, ALer-R, zouql, 深圳|凉茶, densen2014, LiaoLiaoWuJu, hd2y, tky753, feijie999, constantine, JohnZhou2020, mafeng8, VicBilibily, Soar, quzhen91, homejun, d4ilys etc.

💕 Donation

L*y 58元、花花 88元、麦兜很乖 50元、网络来者 2000元、John 99.99元、alex 666元、bacongao 36元、无名 100元、Eternity 188元、无名 10元、⌒.Helper~..oO 66元、习惯与被习惯 100元、无名 100元、蔡易喋 88.88元、中讯科技 1000元、Good Good Work 24元、Nothing 100元、兰州天擎赵 500元、哈利路亚 300元、无名 100元、蛰伏 99.99元、TCYM 66.66元、MOTA 5元、LDZXG 30元、Near 30元、建爽 66元、无名 200元、LambertWu 100元、无名 18.88元、乌龙 50元、无名 100元、陳怼怼 66.66元、陳怼怼 66.66元、丁淮 100元、李伟坚-Excel催化剂 100元、白狐 6.66元、她微笑的脸y 30元、Eternity²º²¹ 588元、夜归柴门 88元、蔡易喋 666.66元、 *礼 10元、litrpa 88元、Alax CHOW 200元、Daily 66元、k*t 66元、蓝 100元、*菜 10元、生命如歌 1000元、山鸡 88元、平凡 100元、大树 1000元、软软的毛毛虫 66.66元、问卷星 2000元、与你无关 5000元

Thank you for your donation

🗄 License

MIT

Showing the top 20 packages that depend on FreeSql.Provider.MySql.

Packages	Downloads
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	24
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	25
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	26
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	27
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	28
HttpReports.MySQL HttpReports is a lightweight APM system developed for Net Core	32
HttpReports.MySQL HttpReports is a lightweight APM system developed for .NET Core	25
HttpReports.MySQL HttpReports is a lightweight APM system developed for .NET Core	29
ZhonTai.Admin 中台Admin接口库	25
ZhonTai.Admin 中台Admin接口库	26

.NET Framework 4.0

FreeSql (>= 3.5.213-preview20250815)
MySql.Data (>= 6.9.12)

.NET Standard 2.1

MySql.Data (>= 9.1.0)
FreeSql (>= 3.5.213-preview20250815)

.NET Standard 2.0

MySql.Data (>= 9.1.0)
FreeSql (>= 3.5.213-preview20250815)

.NET 9.0

FreeSql (>= 3.5.213-preview20250815)
MySql.Data (>= 9.1.0)

.NET 8.0

MySql.Data (>= 9.1.0)
FreeSql (>= 3.5.213-preview20250815)

.NET 7.0

MySql.Data (>= 9.1.0)
FreeSql (>= 3.5.213-preview20250815)

.NET 6.0

FreeSql (>= 3.5.213-preview20250815)
MySql.Data (>= 9.1.0)

.NET Framework 4.5.2

MySql.Data (>= 8.0.30)
FreeSql (>= 3.5.213-preview20250815)

.NET Framework 4.5.1

MySql.Data (>= 6.9.12)
FreeSql (>= 3.5.213-preview20250815)

.NET Framework 4.5

MySql.Data (>= 6.9.12)
FreeSql (>= 3.5.213-preview20250815)

Version	Downloads	Last updated
3.5.215-preview20250917	2	09/19/2025
3.5.213	6	08/28/2025
3.5.213-preview20250825	3	08/24/2025
3.5.213-preview20250815	4	08/16/2025
3.5.212	4	08/03/2025
3.5.211	5	07/27/2025
3.5.211-preview20250716	6	07/21/2025
3.5.210	7	07/12/2025
3.5.210-preview20250626	5	06/29/2025
3.5.209	10	06/22/2025
3.5.208	9	06/22/2025
3.5.207	10	06/06/2025
3.5.206	12	05/17/2025
3.5.205	13	05/10/2025
3.5.204	16	05/03/2025
3.5.204-preview20250428	11	05/01/2025
3.5.204-preview20250425	12	04/27/2025
3.5.203	13	04/20/2025
3.5.202	15	04/10/2025
3.5.201	19	04/03/2025
3.5.200	16	03/28/2025
3.5.109	17	03/25/2025
3.5.108	16	03/13/2025
3.5.107	19	03/13/2025
3.5.106	17	02/25/2025
3.5.105	19	02/11/2025
3.5.105-preview20250116	18	01/22/2025
3.5.104	19	01/20/2025
3.5.103	19	01/16/2025
3.5.103-preview20241226	19	12/28/2024
3.5.103-preview20241224	20	12/28/2024
3.5.103-preview20241205	20	12/28/2024
3.5.102	23	12/28/2024
3.5.101	21	12/09/2024
3.5.100-preview20241128	17	12/16/2024
3.5.100-preview20241127	23	12/09/2024
3.5.100-preview20241123	22	12/08/2024
3.5.100-preview20241113	25	12/02/2024
3.5.100-preview20241112	21	12/06/2024
3.5.100-preview20241108	20	12/02/2024
3.5.100-preview20241101	18	12/11/2024
3.5.100-preview20240825	21	12/03/2024
3.5.100-preview20240815	23	12/06/2024
3.5.100-preview20240810	23	12/04/2024
3.5.100-preview20240808	15	03/16/2025
3.5.100-preview20240725	18	12/13/2024
3.2.833	18	12/02/2024
3.2.832	22	12/02/2024
3.2.830	21	12/12/2024
3.2.825	22	05/30/2024
3.2.822	23	05/30/2024
3.2.821	25	05/30/2024
3.2.820	23	05/30/2024
3.2.816-preview20240322	25	05/30/2024
3.2.816-preview20240314	21	05/30/2024
3.2.815	22	05/30/2024
3.2.812	20	12/04/2024
3.2.811	22	02/04/2024
3.2.811-preview20240126	21	05/30/2024
3.2.811-preview20240120	25	05/30/2024
3.2.810	23	05/30/2024
3.2.808	19	05/30/2024
3.2.805	25	05/30/2024
3.2.802	30	05/30/2024
3.2.801	20	05/30/2024
3.2.700	25	05/30/2024
3.2.698	27	05/30/2024
3.2.697	22	05/30/2024
3.2.696	25	05/30/2024
3.2.695	24	05/30/2024
3.2.693	24	04/14/2023
3.2.690	24	05/30/2024
3.2.687	25	05/30/2024
3.2.685	26	05/30/2024
3.2.684	24	05/30/2024
3.2.683	23	05/30/2024
3.2.682	19	05/30/2024
3.2.681	23	05/30/2024
3.2.680	24	05/30/2024
3.2.669	24	05/30/2024
3.2.666	23	05/30/2024
3.2.665	22	05/30/2024
3.2.664	25	05/30/2024
3.2.662	21	05/30/2024
3.2.661	24	05/30/2024
3.2.651	25	05/30/2024
3.2.640	22	05/30/2024
3.2.610	30	05/30/2024
3.2.609	21	05/30/2024
3.2.603	25	05/30/2024
3.2.500	29	06/14/2023
3.0.100	23	05/30/2024
2.6.100	27	05/30/2024
2.5.200	23	05/30/2024
2.5.100	25	05/30/2024
2.3.200	25	05/30/2024
2.3.106	26	05/30/2024
2.3.100	23	05/30/2024
2.0.105	25	05/30/2024
2.0.102	22	05/30/2024
2.0.101	27	05/30/2024
2.0.0-preview1120	20	05/30/2024
2.0.0-preview1119	21	05/30/2024
2.0.0-preview1115	21	05/30/2024
2.0.0-preview1109	21	05/30/2024
2.0.0-preview1106	20	05/30/2024
2.0.0-preview1105	22	05/30/2024
2.0.0-preview1026	28	05/30/2024
1.10.3	25	05/30/2024
1.10.1	24	05/07/2024
1.10.0-preview1020	20	05/30/2024
1.10.0-preview1001	19	05/30/2024
1.9.1	21	05/30/2024
1.9.0	22	05/30/2024
1.9.0-preview0920	20	05/30/2024
1.9.0-preview0906	22	05/30/2024
1.8.2	20	05/30/2024
1.8.1	25	05/30/2024
1.7.1	26	05/30/2024
1.7.0	23	05/30/2024
1.6.0	23	05/04/2024
1.5.0	26	05/30/2024
1.5.0-preview0525	23	05/30/2024
1.5.0-preview0521	24	05/30/2024
1.5.0-preview0509	26	05/30/2024
1.5.0-preview0502	26	05/30/2024
1.4.0	27	05/03/2024
1.4.0-preview0424	20	05/30/2024
1.4.0-preview0423	23	12/04/2024
1.4.0-preview0422	21	12/05/2024
1.4.0-preview0415	20	12/12/2024
1.4.0-preview0413	21	12/16/2024
1.3.6	21	05/30/2024
1.3.5	24	05/30/2024
1.3.4	25	05/30/2024
1.3.0-preview8	19	12/02/2024
1.2.1	25	05/30/2024
1.1.0	23	05/30/2024
1.0.1	26	05/30/2024
1.0.0	25	05/07/2024
0.12.21	28	05/30/2024
0.12.20	23	05/30/2024
0.12.18	23	05/30/2024
0.12.16	21	05/30/2024
0.12.12	22	05/30/2024
0.12.11	23	05/30/2024
0.12.9	25	05/30/2024
0.12.8	24	05/30/2024
0.12.7	26	05/30/2024
0.12.6	22	05/30/2024
0.12.5	22	05/30/2024
0.12.3	22	05/30/2024
0.11.24	27	05/30/2024
0.11.23	21	05/30/2024
0.11.22	19	12/04/2024
0.11.21	25	05/30/2024
0.11.20	23	05/10/2024
0.11.19	23	05/30/2024
0.11.18	23	05/30/2024
0.11.12	23	05/30/2024
0.11.11	24	05/30/2024
0.11.9	22	05/30/2024
0.11.6	21	05/30/2024
0.11.5	25	05/30/2024
0.11.4	23	05/30/2024
0.11.3	23	05/30/2024
0.11.2	25	05/30/2024
0.11.1	22	05/30/2024
0.10.15	19	05/30/2024
0.10.14	22	05/30/2024
0.10.13	26	05/30/2024
0.10.12	25	05/30/2024
0.10.11	22	05/30/2024
0.10.10	25	05/30/2024
0.10.9	22	05/30/2024
0.10.8	30	05/30/2024
0.10.7	32	05/04/2024
0.10.6	26	05/30/2024
0.10.5	31	05/30/2024
0.10.4	23	05/30/2024
0.10.3	25	05/30/2024
0.10.2	28	05/30/2024
0.10.1	22	05/30/2024
0.9.18	27	05/06/2024
0.9.17	25	05/28/2024
0.9.16	21	05/30/2024
0.9.15	27	05/30/2024
0.9.11	30	05/30/2024
0.9.10	29	05/30/2024
0.9.7	23	05/30/2024

FreeSql.Provider.MySql 3.5.213-preview20250815

Readme

🦄 FreeSql, The First AOT ORM!

📚 Documentation

🚀 Quick start

🔎 Query

🚁 Repository

💪 Performance

👯 Contributors

💕 Donation

🗄 License

Used By

Dependencies

.NET Framework 4.0

.NET Standard 2.1

.NET Standard 2.0

.NET 9.0

.NET 8.0

.NET 7.0

.NET 6.0

.NET Framework 4.5.2

.NET Framework 4.5.1

.NET Framework 4.5

Versions