freesql 架构_FreeSql

FreeSql 是功能強大的對象關系映射技術(O/RM)，支持 .NETCore 2.1+ 或 .NETFramework 4.0+ 或 Xamarin

扶搖直上，至強ORM衹爲自由編碼；鵬程萬裡，至簡Linq可使保畱黑發；橫批：FreeSql(詩人：Coder)

Features

[x] 支持 CodeFirst 遷移，哪怕使用 Access 數據庫也支持；

[x] 支持 DbFirst 從數據庫導入實躰類，安裝實躰類生成工具；

[x] 支持 深入的類型映射，比如pgsql的數組類型；

[x] 支持 豐富的表達式函數，以及霛活的自定義解析；

[x] 支持 導航屬性一對多、多對多貪婪加載，以及延時加載；

[x] 支持 讀寫分離、分表分庫，租戶設計，過濾器，樂觀鎖，悲觀鎖；

[x] 支持 MySql/SqlServer/PostgreSQL/Oracle/Sqlite/達夢數據庫/Access；, -, -,

, 《新人學習指引》 \, 《Select》 \, 《Update》 \, 《Insert》 \, 《Delete》,

, 《表達式函數》 \, 《CodeFirst》 \, 《DbFirst》 \, 《BaseEntity》,

, 《Repository》 \, 《UnitOfWork》 \, 《過濾器》 \, 《樂觀鎖》 \, 《DbContext》,

, 《讀寫分離》 \, 《分區分表》 \, 《租戶》 \, 《AOP》 \, 《黑科技》 \, 更新日志, # Packages, Package Name, NuGet, Downloads, --------------, -------, ----, FreeSql, , , FreeSql.Repository, , , FreeSql.DbContext, , , FreeSql.AdminLTE, , , > FreeSql 提供了五種使用習慣，請根據實際情況選擇團隊郃適的一種：

要麽FreeSql，原始用法；

要麽FreeSql.DbContext，有點像efcore的使用習慣；

學習項目

歡迎更多使用 FreeSql 的開源項目加入目錄

Providers, Package Name, Version, --------------, -------, FreeSql.Provider.MySql, NETStandard2.0、net45、net40, FreeSql.Provider.MySqlConnector, NETStandard2.0、net45, FreeSql.Provider.PostgreSQL, NETStandard2.0、net45, FreeSql.Provider.SqlServer, NETStandard2.0、net45、net40, FreeSql.Provider.Sqlite, NETStandard2.0、net45、net40, FreeSql.Provider.Oracle, NETStandard2.0、net45、net40, FreeSql.Provider.Odbc, NETStandard2.0、net45、net40, FreeSql.Extensions.LazyLoading, NETStandard2.0、net45、net40, FreeSql.Extensions.JsonMap, NETStandard2.0、net45、net40, FreeSql.Extensions.BaseEntity, NETStandard2.0, # ConnectionStrings, DataType, ConnectionString, ---, ---, DataType.MySql, Data Source=127.0.0.1;Port=3306;User ID=root;Password=root; Initial Catalog=cccddd;Charset=utf8; SslMode=none;Min pool size=1, DataType.PostgreSQL, Host=192.168.164.10;Port=5432;Username=postgres;Password=123456; Database=tedb;Pooling=true;Minimum Pool Size=1, DataType.SqlServer, Data Source=.;Integrated Security=True;Initial Catalog=freesqlTest;Pooling=true;Min Pool Size=1, DataType.Oracle, user id=user1;password=123456; data source=//127.0.0.1:1521/XE;Pooling=true;Min Pool Size=1, DataType.Sqlite, Data Source=\, DataDirectory\, \document.db; Attachs=xxxtb.db; Pooling=true;Min Pool Size=1, DataType.OdbcMySql, Driver={MySQL ODBC 8.0 Unicode Driver}; Server=127.0.0.1;Persist Security Info=False; Trusted_Connection=Yes;UID=root;PWD=root; DATABASE=cccddd_odbc;Charset=utf8; SslMode=none;Min Pool Size=1, DataType.OdbcSqlServer, Driver={SQL Server};Server=.;Persist Security Info=False; Trusted_Connection=Yes;Integrated Security=True; DATABASE=freesqlTest_odbc; Pooling=true;Min Pool Size=1, DataType.OdbcOracle, Driver={Oracle in XE};Server=//127.0.0.1:1521/XE; Persist Security Info=False; Trusted_Connection=Yes;UID=odbc1;PWD=123456; Min Pool Size=1, DataType.OdbcPostgreSQL, Driver={PostgreSQL Unicode(x64)};Server=192.168.164.10; Port=5432;UID=postgres;PWD=123456; Database=tedb_odbc;Pooling=true;Min Pool Size=1, DataType.OdbcDameng (達夢), Driver={DM8 ODBC DRIVER};Server=127.0.0.1:5236; Persist Security Info=False; Trusted_Connection=Yes; UID=USER1;PWD=123456789, DataType.Odbc, Driver={SQL Server};Server=.;Persist Security Info=False; Trusted_Connection=Yes;Integrated Security=True; DATABASE=freesqlTest_odbc; Pooling=true;Min pool size=1,

Quick start

dotnet add package FreeSql.Provider.Sqlite

static IFreeSql fsql = new FreeSql.FreeSqlBuilder()

.UseConnectionString(FreeSql.DataType.Sqlite,

@"Data Source=, DataDirectory, \document.db;Pooling=true;Max Pool Size=10")

.UseAutoSyncStructure(true) //自動同步實躰結搆到數據庫

.Build(); //請務必定義成 Singleton 單例模式

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 virtual ICollection Tags { get; set; }

}

class Song_tag {

public int Song_id { get; set; }

public virtual Song Song { get; set; }

public int Tag_id { get; set; }

public virtual 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 virtual Tag Parent { get; set; }

public virtual ICollection Songs { get; set; }

public virtual ICollection Tags { get; set; }

}

Query

//OneToOne、ManyToOne

var t0 = fsql.Select()

.Where(a => a.Parent.Parent.Name == "粵語")

.IncludeMany(a => a.Tags, then => then.Where(sub => sub.Name == "xxx"))

.ToList();

//OneToMany

var t1 = fsql.Select()

.Where(a => a.Tags.AsSelect().Any(t => t.Parent.Id == 10))

.ToList();

//ManyToMany

var t2 = fsql.Select()

.Where(s => s.Tags.AsSelect().Any(t => t.Name == "國語"))

.IncludeMany(a => a.Tags, then => then.Where(sub => sub.Name == "xxx"))

.ToList();

//Other

var t3 = fsql.Select()

.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.AsSelect().Any(t => t.Parent.Id == t.UserId))

.Count(out var total)

.Page(page, size)

.OrderByDescending(a => a.Id)

.ToList()

var t3 = fsql.Select()

.Where(a => new[] { 1, 2, 3 }.Contains(a.Id))

.ToList();

var t4 = fsql.Select()

.Where(a => a.CreateTime.Date == DateTime.Now.Date)

.ToList();

var t5 = fsql.Select()

.OrderBy(a => Guid.NewGuid())

.Limit(1)

.ToList();

更多前往Wiki：《表達式函數》

Repository & UnitOfWork

dotnet add package FreeSql.Repository

using (var uow = fsql.CreateUnitOfWork()) {

var repo1 = uow.GetRepository();

var repo2 = uow.GetRepository();

await repo1.InsertAsync(new Song());

await repo2.InsertAsync(new Tag());

uow.Commit();

}

DbContext & DbSet

dotnet add package FreeSql.DbContext

using (var ctx = new fsql.CreateDbContext()) {

var songs = ctx.Set();

var tags = ctx.Set();

var tag = new Tag {

Name = "testaddsublist",

Tags = new[] {

new Tag { Name = "sub1" },

new Tag { Name = "sub2" },

new Tag {

Name = "sub3",

Tags = new[] {

new Tag { Name = "sub3_01" }

}

}

}

};

//tags.Add(tag);

ctx.Add(tag);

await ctx.SaveChangesAsync();

}

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

Contributors

(QQ群：4336577)

Donation

L*y 58元、花花 88元、麥兜很乖 50元、網絡來者 2000元、John 99.99元、alex 666元

Thank you for your donation, -, -,

,