Install
中文 | English
FreeSql is a .NET Standard 2.0 library, which only supports applications of .NET Framework 4.0, .NET Core or higher.
dotnet add package FreeSql
dotnet add package FreeSql.DbContext
dotnet add package FreeSql.Provider.MySqlConnector
| Package Name | Version | Description | NuGet |
|---|---|---|---|
| FreeSql.Repository | NETStandard2.0、net45、net40 | Common Repository + UoW | |
| FreeSql.Provider.MySql | NETStandard2.0、net45、net40 | Based on MySql.Data (Oracle official) | |
| FreeSql.Provider.MySqlConnector | NETStandard2.0、net45 | Based on MySqlConnector | |
| FreeSql.Provider.PostgreSQL | NETStandard2.0、net45 | Based on PostgreSQL 9.5+ | |
| FreeSql.Provider.SqlServer | NETStandard2.0、net45、net40 | Support SqlServer 2005+, based on Microsoft.Data.SqlClient | |
| FreeSql.Provider.SqlServerForSystem | NETStandard2.0、net45、net40 | Support SqlServer 2005+, based on Microsoft.Data.SqlClient | |
| FreeSql.Provider.Sqlite | NETStandard2.0、net45、net40 | ||
| FreeSql.Provider.Duckdb | NETStandard2.0 | Based on DuckDB.NET.Data.Full | |
| FreeSql.Provider.ClickHouse | NETStandard2.1 | Based on ClickHouse.Client | |
| FreeSql.Provider.QuestDb | NETStandard2.0 | Based on Npgsql 和 RestApi | |
| FreeSql.Provider.Oracle | NETStandard2.0、net45、net40 | Oracle.ManagedDataAccess.Core | |
| FreeSql.Provider.OracleOledb | NETStandard2.0、net45、net40 | Based on OLEDB. US7ASCII Chinese garbled code problem | |
| FreeSql.Provider.Firebird | NETStandard2.0、net452 | FirebirdSql.Data.FirebirdClient | |
| FreeSql.Provider.MsAccess | NETStandard2.0、net45、net40 | ||
| FreeSql.Provider.Dameng | NETStandard2.0、net45、net40 | Based on Dameng Database | |
| FreeSql.Provider.ShenTong | NETStandard2.0、net45、net40 | Based on ShenTong Database | |
| FreeSql.Provider.KingbaseES | NETStandard2.0、net461 | Based on KingbaseEs V008R003 | |
| FreeSql.Provider.GBase | NETStandard2.0、net461 | Based on GBase | |
| FreeSql.Provider.Xugu | NETStandard2.0、net461 | Based on Xugu | |
| FreeSql.Provider.Odbc | NETStandard2.0、net45、net40 | Based on ODBC | |
| FreeSql.Provider.Custom | NETStandard2.0、net45、net40 | Custom database provider | |
| FreeSql.Extensions.LazyLoading | NETStandard2.0、net45、net40 | Lazy loading extensions | |
| FreeSql.Extensions.JsonMap | NETStandard2.0、net45、net40 | Json serialization extensions | |
| FreeSql.Extensions.Linq | NETStandard2.0、net45、net40 | LinqToSql IQueryable extensions | |
| FreeSql.Extensions.BaseEntity | NETStandard2.0 | ||
| FreeSql.Generator | NETCoreapp3.1 | Generate entity classes from the database. How does it work? |
FreeSql supports basic CURD. In addition, it also supports creating models based on existing databases (DbFirst), and supports creating databases based on models (CodeFirst).
- 《FreeSql 101, Part 1: Insert Data》
- 《FreeSql 101, Part 2: Delete Data》
- 《FreeSql 101, Part 3: Update Data》
- 《FreeSql 101, Part 4: Query Data》
- 《Repository Layer》