FreeSql.Provider.PostgreSQL 3.5.100-preview20241127

🦄 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.PostgreSQL.

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

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

.NET Framework 4.6.1

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