FreeSql.Provider.SqlServer 3.5.103

🦄 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/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:

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.SqlServer.

Packages Downloads
ZhonTai.Admin
中台Admin接口库
53
ZhonTai.Admin
中台Admin接口库
56
ZhonTai.Admin
中台Admin接口库
58
ZhonTai.Admin
中台Admin接口库
66
ZhonTai.Admin
中台Admin接口库
74
ZhonTai.Admin
中台Admin接口库
77
ZhonTai.Admin
中台Admin接口库
94
ZhonTai.Admin
中台Admin接口库
95
ZhonTai.Admin
中台Admin接口库
97
ZhonTai.Admin
中台Admin接口库
114
ZhonTai.Admin
中台Admin权限管理接口库
103

.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.1

.NET Framework 4.5

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