FreeSql.Generator 3.2.833

dotnet tool install --global FreeSql.Generator --version 3.2.833                
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local FreeSql.Generator --version 3.2.833                
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=FreeSql.Generator&version=3.2.833                
nuke :add-package FreeSql.Generator --version 3.2.833                

<h1 align="center"> 🦄 FreeSql, The first AOT ORM!</h1><div align="center">

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

<p> <span>English</span> |
<a href="README.zh-CN.md">中文</a> </p>

</div>

  • 🛠 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:

<p align="center"> <img src="https://github.com/dotnetcore/FreeSql/raw/master/functions13.png"/> </p>

🚀 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

<a href="https://contributors-img.web.app/image?repo=dotnetcore/FreeSql"> <img src="https://contributors-img.web.app/image?repo=dotnetcore/FreeSql" /> </a>

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

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
3.2.833 63 7/15/2024
3.2.833-preview20260712 38 7/12/2024
3.2.833-preview20260627 81 6/27/2024
3.2.832 243 6/27/2024
3.2.830 157 6/19/2024
3.2.825 524 5/20/2024
3.2.822 108 5/12/2024
3.2.821 314 4/10/2024
3.2.820 212 3/26/2024
3.2.815 290 2/27/2024
3.2.812 272 2/1/2024
3.2.811 186 1/29/2024
3.2.810 289 1/14/2024
3.2.808 398 12/20/2023
3.2.807-preview20231219 111 12/19/2023
3.2.805 426 11/15/2023
3.2.802 396 10/27/2023
3.2.801 664 9/21/2023
3.2.700 486 8/13/2023
3.2.698 447 7/6/2023
3.2.697 422 6/6/2023
3.2.696 297 5/30/2023
3.2.695 431 5/5/2023
3.2.693 599 3/29/2023
3.2.690 477 3/2/2023
3.2.687 628 1/24/2023
3.2.685 524 12/20/2022
3.2.684 536 12/2/2022
3.2.683 652 11/20/2022
3.2.682 823 10/17/2022
3.2.681 601 10/12/2022
3.2.680 734 9/25/2022
3.2.669 768 9/7/2022
3.2.666 749 8/30/2022
3.2.665 1,126 7/4/2022
3.2.664 866 6/14/2022
3.2.662 808 6/9/2022
3.2.661 845 6/1/2022
3.2.651 890 5/24/2022
3.2.640 852 5/13/2022
3.2.610 831 5/6/2022
3.2.609 838 5/5/2022
3.2.603 857 4/29/2022
3.2.501 843 4/26/2022
3.2.500 968 4/12/2022
3.0.100 1,229 12/17/2021
2.6.100 1,883 8/31/2021
2.5.200 2,444 6/5/2021
2.5.100 1,959 5/7/2021
2.3.200 2,325 3/5/2021
2.3.106 644 3/4/2021
2.3.100 765 2/19/2021
2.0.105 1,436 12/7/2020
2.0.102 815 12/2/2020
2.0.101 789 11/26/2020
2.0.0-preview1120 463 11/19/2020
2.0.0-preview1119 455 11/18/2020
2.0.0-preview1115 460 11/13/2020
2.0.0-preview1109 497 11/6/2020
2.0.0-preview1106 444 11/4/2020
2.0.0-preview1105 484 11/4/2020
2.0.0-preview1026 455 10/26/2020
1.10.3 946 11/6/2020
1.10.1 757 10/22/2020
1.10.0-preview1020 445 10/16/2020
1.10.0-preview1001 463 9/29/2020
1.9.1 760 11/6/2020
1.9.0 847 9/23/2020
1.9.0-preview0920 540 9/20/2020
1.9.0-preview0906 757 9/5/2020
1.8.2 682 11/6/2020
1.8.1 999 8/26/2020
1.7.1 849 8/1/2020
1.7.0 773 7/27/2020
1.6.113 826 6/29/2020
1.6.0 773 6/27/2020
1.5.0 821 5/24/2020
1.5.0-preview0525 482 5/23/2020
1.5.0-preview0521 494 5/20/2020
1.5.0-preview0509 475 5/8/2020
1.5.0-preview0502 447 5/2/2020
1.4.0 848 4/26/2020
1.4.0-preview0424 476 4/23/2020
1.4.0-preview0423 478 4/22/2020
1.4.0-preview0422 458 4/21/2020
1.4.0-preview0415 448 4/14/2020
1.4.0-preview0413 492 4/13/2020
1.3.6 800 4/12/2020
1.3.5 799 4/7/2020
1.3.4 765 4/1/2020
1.3.0-preview8 510 3/12/2020
1.2.1 1,367 3/6/2020
1.1.0 845 1/31/2020
1.1.0-preview5-2 642 1/19/2020
1.1.0-preview4-2 584 1/10/2020
1.0.1.2 874 1/5/2020
1.0.1 974 1/3/2020
1.0.0 990 12/25/2019
0.12.21.4 924 12/20/2019
0.12.21.2 976 12/18/2019
0.12.21 811 12/16/2019
0.12.20 811 12/14/2019
0.12.18 781 12/12/2019
0.12.16.1 805 12/11/2019