Standard.SqlAccess
6.0.5473
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Standard.SqlAccess --version 6.0.5473
NuGet\Install-Package Standard.SqlAccess -Version 6.0.5473
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Standard.SqlAccess" Version="6.0.5473" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Standard.SqlAccess --version 6.0.5473
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Standard.SqlAccess, 6.0.5473"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Standard.SqlAccess as a Cake Addin
#addin nuget:?package=Standard.SqlAccess&version=6.0.5473
// Install Standard.SqlAccess as a Cake Tool
#tool nuget:?package=Standard.SqlAccess&version=6.0.5473
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
basic ORM Framework & Designer
basic ORM 于2012 年发布、2023 年正式开源,该组件已在数百个成熟项目中应用。
经过数十个版本的更新迭代发布全新v6.0版本,支持动态条件查询(Lambda)
数据库持久化 ORM 开发框架,支持多种数据库(MSSQL,MYSQL,ORACLE,DB2,PostgreSQL等)。
支持Linq表达式动态查询数据。支持快速分页
简单的事务处理,自动化事务提交,回滚
设计器文件目录
- 设计器文件(*.dpdl)
- 数据持久类代码(xxxAccess.cs)
- 数据持久类代码(xxxAccess.designer.cs)
- 业务逻辑类代码(xxxContext.cs)
- 业务逻辑类代码(xxxContext.designer.cs)
NuGet packages
不使用分布式事务
using(xxxAccess access = new xxxAccess(connectionstring))
{
access.Create(entity); or await access.CreateAsync(entity);
}
//使用 Lambda 表达式查询数据
using(xxxAccess access = new xxxAccess(connectionstring))
{
var queries = access.GetEntities<XXX>(0,0);
queries.Where(m => m.Enabled == true).Where(m => m.Key >= 1);
return queries.ToPaginationAsync();
}
使用分布式事务(xxxContext.cs)
using(xxxAccess access = new xxxAccess(connectionstring, true))
{
access.Create(entity); or await access.CreateAsync(entity);
access.SetComplate();
}
using(xxxAccess access = new xxxAccess(connectionstring, TimeSpan.FromSeconds(60)))
{
access.Create(entity); or await access.CreateAsync(entity);
access.SetComplate();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- Standard.DataAccess (>= 6.0.5473)
- Standard.EntityLayer (>= 6.0.5473)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Configuration.ConfigurationManager (>= 7.0.0)
- System.Data.SqlClient (>= 4.8.5)
- System.Runtime.Caching (>= 7.0.0)
-
net6.0
- Standard.DataAccess (>= 6.0.5473)
- Standard.EntityLayer (>= 6.0.5473)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Configuration.ConfigurationManager (>= 7.0.0)
- System.Data.SqlClient (>= 4.8.5)
- System.Runtime.Caching (>= 7.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated | |
---|---|---|---|
6.0.5482 | 174 | 11/30/2023 | |
6.0.5480 | 97 | 11/27/2023 | |
6.0.5479 | 116 | 11/24/2023 | |
6.0.5476 | 100 | 11/18/2023 | |
6.0.5475 | 93 | 11/13/2023 | |
6.0.5473 | 91 | 11/4/2023 | |
6.0.5469 | 82 | 10/27/2023 | |
6.0.5467 | 94 | 10/25/2023 | |
6.0.5457 | 122 | 9/20/2023 | |
6.0.5455 | 110 | 9/7/2023 | |
6.0.5454 | 111 | 8/31/2023 | |
6.0.5453 | 159 | 7/7/2023 | |
6.0.5452 | 137 | 6/2/2023 | |
6.0.5451 | 165 | 5/16/2023 | |
6.0.5450 | 213 | 4/3/2023 | |
6.0.5448 | 246 | 3/22/2023 | |
6.0.5446 | 259 | 3/14/2023 | |
6.0.5445 | 256 | 3/14/2023 | |
6.0.5444 | 254 | 3/8/2023 | |
6.0.5443 | 267 | 2/26/2023 | |
6.0.5441 | 258 | 2/18/2023 | |
6.0.5440 | 314 | 1/9/2023 | |
6.0.5438 | 342 | 1/4/2023 | |
6.0.5435 | 332 | 1/3/2023 | |
6.0.5433 | 321 | 12/30/2022 | |
6.0.5429 | 329 | 12/30/2022 | |
6.0.5422 | 335 | 12/28/2022 | |
6.0.5421 | 339 | 12/9/2022 | |
6.0.5416 | 417 | 10/29/2022 | |
6.0.5413 | 469 | 10/16/2022 | |
6.0.5409 | 422 | 10/9/2022 | |
4.7.13672 | 446 | 8/4/2022 | |
4.7.13668 | 489 | 6/27/2022 | |
4.7.13664 | 481 | 5/16/2022 | |
4.7.13659 | 491 | 4/25/2022 | |
4.7.13652 | 493 | 3/21/2022 | |
4.7.13651 | 481 | 3/5/2022 | |
4.7.13649 | 507 | 2/24/2022 | |
4.7.13646 | 497 | 2/16/2022 | |
4.7.13642 | 499 | 1/15/2022 | |
4.7.13638 | 332 | 12/23/2021 | |
4.7.13628 | 351 | 11/30/2021 | |
4.7.13624 | 1,462 | 11/26/2021 | |
4.7.13622 | 2,728 | 11/25/2021 | |
4.7.13611 | 401 | 10/22/2021 | |
4.7.13610 | 516 | 10/17/2021 | |
4.7.13605 | 399 | 10/11/2021 |