FreeSql.Provider.PostgreSQL 3.2.811-preview20240126

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

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

Showing the top 20 packages that depend on FreeSql.Provider.PostgreSQL.

Packages Downloads
ZhonTai.Admin
中台Admin接口库
17
ZhonTai.Admin
中台Admin接口库
18
ZhonTai.Admin
中台Admin接口库
19
ZhonTai.Admin
中台Admin接口库
20
ZhonTai.Admin
中台Admin接口库
21
ZhonTai.Admin
中台Admin接口库
24
ZhonTai.Admin
中台Admin权限管理接口库
22

.NET Framework 4.5

.NET Standard 2.0

.NET Framework 4.6.1

.NET Framework 4.5.2

.NET Framework 4.5.1

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