FreeSql.Provider.Oracle 3.5.210-preview20250626

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

Packages Downloads
ZhonTai.Admin
中台Admin接口库
8
ZhonTai.Admin
中台Admin接口库
12
ZhonTai.Admin
中台Admin接口库
13
ZhonTai.Admin
中台Admin权限管理接口库
12

.NET Framework 4.0

.NET Standard 2.1

.NET 9.0

.NET 8.0

.NET 7.0

.NET 6.0

.NET 5.0

.NET Core 3.1

.NET Framework 4.5

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