Sail2025.DataAccess
2026.5.1
dotnet add package Sail2025.DataAccess --version 2026.5.1
NuGet\Install-Package Sail2025.DataAccess -Version 2026.5.1
<PackageReference Include="Sail2025.DataAccess" Version="2026.5.1" />
<PackageVersion Include="Sail2025.DataAccess" Version="2026.5.1" />
<PackageReference Include="Sail2025.DataAccess" />
paket add Sail2025.DataAccess --version 2026.5.1
#r "nuget: Sail2025.DataAccess, 2026.5.1"
#:package Sail2025.DataAccess@2026.5.1
#addin nuget:?package=Sail2025.DataAccess&version=2026.5.1
#tool nuget:?package=Sail2025.DataAccess&version=2026.5.1
Sail2025.DataAccess
Sail2025 data access layer for .NET 8.0. Provides ORM mapping, query builder, transactions, pagination, and multi-database support.
Features
- ORM mapping and CRUD
- Query builder (Where / OrderBy / Clip)
- Transactions and batch operations
- Multi-database: SQL Server, MySQL, PostgreSQL, SQLite, Oracle, Dameng
- Optional SSH tunnel support for database connections
Install
dotnet add package Sail2025.DataAccess
Quick start
using Sail.Data;
using var db = new DataContext(); // uses connection named "default"
var where = db.Where<User>(x => x.IsActive);
var orderBy = db.OrderBy<User>(x => x.CreateTime.Desc());
var users = db.GetList<User>(where, orderBy);
var page = db.GetPageList<User>(1, 20, where, orderBy);
Configuration
Provide connection strings via Sail configuration and use a named connection (e.g. "default"). See the repo docs/ folder for full setup details.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net8.0
- Microsoft.Extensions.Configuration.Binder (>= 8.0.0)
- MQTTnet (>= 4.3.7.1207)
- Renci.SshNet.Async (>= 1.4.0)
- Sail2025.Core (>= 2026.1.7)
- SSH.NET (>= 2025.0.0)
- System.Net.Http (>= 4.3.4)
- System.Text.RegularExpressions (>= 4.3.1)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on Sail2025.DataAccess:
| Package | Downloads |
|---|---|
|
Sail2025.Blazor
Blazor UI components of Sail2025 framework, providing rich and modern UI components for ASP.NET Core Blazor applications. Includes form components, data grids, charts, navigation, modals, file uploaders and other interactive components built with MudBlazor integration. |
|
|
Sail2025.Web
Web core components of Sail2025 framework, providing infrastructure for ASP.NET Core applications. Includes HTTP context extensions, session management, cookie handling, layout base classes, component text resources and other features to simplify web application development. |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 2026.5.1 | 99 | 5/22/2026 |
| 2026.4.1 | 98 | 4/24/2026 |
| 2026.1.8 | 169 | 1/23/2026 |
| 2026.1.7 | 146 | 1/23/2026 |
| 2026.1.5 | 159 | 1/23/2026 |
| 2026.1.4 | 118 | 1/23/2026 |
| 2026.1.3 | 116 | 1/22/2026 |
| 2026.1.2 | 113 | 1/22/2026 |
| 2026.1.1 | 117 | 1/21/2026 |
| 2025.9.2.1 | 198 | 9/7/2025 |
| 2025.9.1.1 | 260 | 9/1/2025 |
| 2025.7.1.5 | 262 | 7/14/2025 |
| 2025.7.1.4 | 212 | 7/14/2025 |
| 2025.7.1.3 | 208 | 7/14/2025 |
| 2025.7.1.2 | 205 | 7/14/2025 |
| 2025.7.1.1 | 174 | 7/11/2025 |
| 2025.7.1 | 296 | 7/11/2025 |
2026.05.1: normalize Sail query expressions before Clip translation so closure-based dynamic filters, boolean short-circuit expressions, and constant conditional branches are handled consistently while preserving null where compatibility.