FreeSql.Extensions.JsonMap 3.5.100-preview20241101

🦄 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.Extensions.JsonMap.

Packages Downloads
ZhonTai.Admin
中台Admin权限管理接口库
19
ZhonTai.Admin
中台Admin权限管理接口库
26
ZhonTai.Admin
中台Admin权限管理接口库
34
ZhonTai.Admin.Core
中台Admin权限管理核心库
4
ZhonTai.Admin.Core
中台Admin权限管理核心库
6
ZhonTai.Admin.Core
中台Admin权限管理核心库
9
ZhonTai.Admin.Core
中台Admin权限管理核心库
10
ZhonTai.Admin.Core
中台Admin权限管理核心库
11
ZhonTai.Admin.Core
中台Admin权限管理核心库
12
ZhonTai.Admin.Core
中台Admin权限管理核心库
13
ZhonTai.Admin.Core
中台Admin权限管理核心库
14
ZhonTai.Admin.Core
中台Admin权限管理核心库
15
ZhonTai.Admin.Core
中台Admin权限管理核心库
16

.NET Framework 4.0

.NET Framework 4.5

.NET Standard 2.0

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