FreeSql 3.2.811-preview20240120

🦄 FreeSql, The first AOT ORM!

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

Member project of .NET Core Community nuget stats GitHub license

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/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  |  DbContext  |  ADO  
Read/Write  |  Splitting Table  |  Hide tech  |  Update Notes  

Please select a development 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元、炽焰 6.6元、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.

Packages Downloads
FreeScheduler
轻量化定时任务调度,支持临时的延时任务和重复循环任务,可按秒,每天/每周/每月固定时间,自定义间隔执行,支持 .NET Core 2.1+、.NET Framework 4.0+ 运行环境。
27
FreeSql.DbContext
FreeSql is the ORM in .NetCore, .NetFramework, And Xamarin. It supports Mysql, Postgresql, SqlServer, Oracle, Sqlite, Firebird, Odbc, 达梦, 人大金仓, 神舟通用, 翰高, And Access
25
FreeSql.DbContext
FreeSql is the ORM in .NetCore, .NetFramework, And Xamarin. It supports Mysql, Postgresql, SqlServer, Oracle, Sqlite, Odbc, 达梦, And Access
25
FreeSql.Extensions.JsonMap
FreeSql 扩展包,可实现实体类属性为对象时,以JSON形式映射存储.
25
FreeSql.Extensions.JsonMap
FreeSql 扩展包,可实现实体类属性为对象时,以JSON形式映射存储.
30
FreeSql.Provider.MySql
FreeSql 数据库实现,基于 MySql 5.6
25
FreeSql.Provider.MySql
FreeSql 数据库实现,基于 MySql 5.6
26
FreeSql.Provider.MySql
FreeSql 数据库实现,基于 MySql 5.6
27
FreeSql.Provider.MySql
FreeSql 数据库实现,基于 MySql 5.6
28
FreeSql.Provider.MySql
FreeSql 数据库实现,基于 MySql 5.6,Ado.Net 驱动是 MySql.Data(Oracle官方)
26
FreeSql.Provider.Oracle
FreeSql 数据库实现,基于 Oracle 11
25
FreeSql.Provider.PostgreSQL
FreeSql 数据库实现,基于 PostgreSQL 9.5
25
FreeSql.Provider.Sqlite
FreeSql 数据库实现,基于 Sqlite 3.0,支持 .NetCore、.NetFramework、Xamarin
29
FreeSql.Provider.SqlServer
FreeSql 数据库实现,基于 SqlServer 2005+,并根据版本适配分页方法:row_number 或 offset fetch next
26
FreeSql.Provider.SqlServer
FreeSql 数据库实现,基于 SqlServer 2005+,并根据版本适配分页方法:row_number 或 offset fetch next
28
HttpReports.MySQL
HttpReports is a lightweight APM system developed for Net Core
27
HttpReports.Storage.Abstractions
HttpReports is a lightweight APM system developed for Net Core , it is also suitable for use in a micro-service architecture.
26

.NET Framework 4.0

  • No dependencies.

.NET Framework 4.5

  • No dependencies.

.NET Framework 4.5.1

  • No dependencies.

.NET Standard 2.0

  • No dependencies.

.NET Standard 2.1

  • No dependencies.

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