FreeSql.Generator 3.2.820

There is a newer version of this package available.
See the version list below for details.
dotnet tool install --global FreeSql.Generator --version 3.2.820                
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.820                
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=FreeSql.Generator&version=3.2.820                
nuke :add-package FreeSql.Generator --version 3.2.820                

<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元、炽焰 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

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.5.100-preview20241113 29 11/13/2024
3.5.100-preview20241112 72 11/12/2024
3.5.100-preview20241108 81 11/8/2024
3.5.100-preview20241101 80 11/1/2024
3.5.100-preview20240825 138 8/24/2024
3.5.100-preview20240815 136 8/14/2024
3.5.100-preview20240810 143 8/9/2024
3.5.100-preview20240808 125 8/8/2024
3.5.100-preview20240725 120 7/24/2024
3.2.833 949 7/15/2024
3.2.832 287 6/27/2024
3.2.830 204 6/19/2024
3.2.825 574 5/20/2024
3.2.822 156 5/12/2024
3.2.821 351 4/10/2024
3.2.820 255 3/26/2024
3.2.815 348 2/27/2024
3.2.812 324 2/1/2024
3.2.811 223 1/29/2024
3.2.810 328 1/14/2024
3.2.808 439 12/20/2023
3.2.807-preview20231219 147 12/19/2023
3.2.805 477 11/15/2023
3.2.802 454 10/27/2023
3.2.801 702 9/21/2023
3.2.700 521 8/13/2023
3.2.698 490 7/6/2023
3.2.697 464 6/6/2023
3.2.696 337 5/30/2023
3.2.695 478 5/5/2023
3.2.693 639 3/29/2023
3.2.690 512 3/2/2023
3.2.687 663 1/24/2023
3.2.685 563 12/20/2022
3.2.684 574 12/2/2022
3.2.683 719 11/20/2022
3.2.682 872 10/17/2022
3.2.681 655 10/12/2022
3.2.680 792 9/25/2022
3.2.669 832 9/7/2022
3.2.666 809 8/30/2022
3.2.665 1,182 7/4/2022
3.2.664 922 6/14/2022
3.2.662 870 6/9/2022
3.2.661 906 6/1/2022
3.2.651 944 5/24/2022
3.2.640 911 5/13/2022
3.2.610 891 5/6/2022
3.2.609 908 5/5/2022
3.2.603 889 4/29/2022
3.2.501 902 4/26/2022
3.2.500 1,020 4/12/2022
3.0.100 1,282 12/17/2021
2.6.100 1,936 8/31/2021
2.5.200 2,516 6/5/2021
2.5.100 2,019 5/7/2021
2.3.200 2,381 3/5/2021
2.3.106 689 3/4/2021
2.3.100 812 2/19/2021
2.0.105 1,456 12/7/2020
2.0.102 853 12/2/2020
2.0.101 835 11/26/2020
2.0.0-preview1120 496 11/19/2020
2.0.0-preview1119 492 11/18/2020
2.0.0-preview1115 503 11/13/2020
2.0.0-preview1109 526 11/6/2020
2.0.0-preview1106 481 11/4/2020
2.0.0-preview1105 528 11/4/2020
2.0.0-preview1026 494 10/26/2020
1.10.3 966 11/6/2020
1.10.1 796 10/22/2020
1.10.0-preview1020 485 10/16/2020
1.10.0-preview1001 491 9/29/2020
1.9.1 805 11/6/2020
1.9.0 883 9/23/2020
1.9.0-preview0920 551 9/20/2020
1.9.0-preview0906 796 9/5/2020
1.8.2 722 11/6/2020
1.8.1 1,041 8/26/2020
1.7.1 885 8/1/2020
1.7.0 815 7/27/2020
1.6.113 859 6/29/2020
1.6.0 806 6/27/2020
1.5.0 859 5/24/2020
1.5.0-preview0525 509 5/23/2020
1.5.0-preview0521 533 5/20/2020
1.5.0-preview0509 507 5/8/2020
1.5.0-preview0502 478 5/2/2020
1.4.0 891 4/26/2020
1.4.0-preview0424 508 4/23/2020
1.4.0-preview0423 507 4/22/2020
1.4.0-preview0422 487 4/21/2020
1.4.0-preview0415 482 4/14/2020
1.4.0-preview0413 521 4/13/2020
1.3.6 836 4/12/2020
1.3.5 831 4/7/2020
1.3.4 827 4/1/2020
1.3.0-preview8 556 3/12/2020
1.2.1 1,406 3/6/2020
1.1.0 877 1/31/2020
1.1.0-preview5-2 675 1/19/2020
1.1.0-preview4-2 630 1/10/2020
1.0.1.2 918 1/5/2020
1.0.1 1,031 1/3/2020
1.0.0 1,048 12/25/2019
0.12.21.4 977 12/20/2019
0.12.21.2 1,029 12/18/2019
0.12.21 845 12/16/2019
0.12.20 844 12/14/2019
0.12.18 794 12/12/2019
0.12.16.1 843 12/11/2019