SimpleAccess.SqlServer
6.0.0-beta-6.0.0.1
See the version list below for details.
dotnet add package SimpleAccess.SqlServer --version 6.0.0-beta-6.0.0.1
NuGet\Install-Package SimpleAccess.SqlServer -Version 6.0.0-beta-6.0.0.1
<PackageReference Include="SimpleAccess.SqlServer" Version="6.0.0-beta-6.0.0.1" />
paket add SimpleAccess.SqlServer --version 6.0.0-beta-6.0.0.1
#r "nuget: SimpleAccess.SqlServer, 6.0.0-beta-6.0.0.1"
// Install SimpleAccess.SqlServer as a Cake Addin #addin nuget:?package=SimpleAccess.SqlServer&version=6.0.0-beta-6.0.0.1&prerelease // Install SimpleAccess.SqlServer as a Cake Tool #tool nuget:?package=SimpleAccess.SqlServer&version=6.0.0-beta-6.0.0.1&prerelease
Simple Access ORM provides database access in Ado.net methods naming pattern.
Documentation of using SimpleAccess is available at https://simpleaccessorm.com/
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 is compatible. |
.NET Framework | net452 is compatible. net46 was computed. 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. |
-
.NETFramework 4.5.2
- SimpleAccess.Core (>= 6.0.0-beta-6.0.0.1)
-
.NETStandard 2.0
- SimpleAccess.Core (>= 6.0.0-beta-6.0.0.1)
- System.Data.SqlClient (>= 4.4.0)
-
.NETStandard 2.1
- Microsoft.Data.SqlClient (>= 1.1.0)
- SimpleAccess.Core (>= 6.0.0-beta-6.0.0.1)
-
net6.0
- Microsoft.Data.SqlClient (>= 4.1.0)
- SimpleAccess.Core (>= 6.0.0-beta-6.0.0.1)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on SimpleAccess.SqlServer:
Package | Downloads |
---|---|
SimpleAccess.SqlServer.Repository
Simple Access ORM provides database access in Ado.net methods naming pattern. Documentation of using SimpleAccess is available at https://simpleaccessorm.com |
|
SimpleApp.Web.Localization.Abstract
Aspnet Core 6 Localization Component Abstraction classes |
|
SimpleApp.Web.Localization
Aspnet Core 6 Localization component |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
6.0.0-beta-6.0.0.4 | 357 | 9/11/2022 |
6.0.0-beta-6.0.0.3 | 124 | 8/15/2022 |
6.0.0-beta-6.0.0.2 | 203 | 8/13/2022 |
6.0.0-beta-6.0.0.1 | 132 | 8/2/2022 |
5.0.0-beta-5.0.0.1 | 193 | 10/19/2021 |
3.1.1 | 1,148 | 7/31/2022 |
3.1.0 | 1,069 | 10/12/2021 |
3.1.0-rc-9 | 760 | 7/23/2021 |
3.1.0-rc-8.8 | 176 | 4/24/2021 |
3.1.0-rc-8.7 | 193 | 3/28/2021 |
3.1.0-rc-8.6 | 302 | 2/10/2021 |
3.1.0-rc-8.5 | 206 | 1/13/2021 |
3.1.0-rc-8.4 | 335 | 12/19/2020 |
3.1.0-rc-8.2 | 308 | 11/9/2020 |
3.1.0-rc-8.1 | 304 | 11/8/2020 |
3.1.0-rc-8 | 978 | 11/7/2020 |
3.1.0-rc-7.9 | 361 | 7/8/2020 |
3.1.0-rc-7.8 | 272 | 7/8/2020 |
3.1.0-rc-7.7 | 345 | 7/5/2020 |
3.1.0-rc-7.6 | 342 | 7/5/2020 |
3.1.0-rc-7.5 | 273 | 7/3/2020 |
3.1.0-rc-7.4 | 292 | 7/2/2020 |
3.1.0-rc-7.3 | 310 | 7/1/2020 |
3.1.0-rc-7.2 | 249 | 6/7/2020 |
3.1.0-rc-7.1 | 291 | 5/19/2020 |
3.1.0-rc-5 | 948 | 5/8/2020 |
3.1.0-rc-3.1.0.15 | 190 | 8/22/2021 |
3.1.0-rc-3.1.0.13 | 154 | 8/15/2021 |
3.1.0-rc-3 | 968 | 5/6/2020 |
3.1.0-rc-2 | 1,009 | 4/4/2020 |
3.1.0-rc-12 | 827 | 7/31/2021 |
3.1.0-rc-11 | 782 | 7/30/2021 |
3.1.0-rc-10 | 782 | 7/30/2021 |
3.1.0-beta-5 | 1,056 | 3/28/2020 |
3.1.0-beta-4 | 997 | 3/1/2020 |
3.1.0-beta-3 | 953 | 1/26/2020 |
3.1.0-beta-2 | 1,080 | 1/22/2020 |
3.1.0-beta | 1,073 | 1/4/2020 |
3.0.2 | 1,530 | 11/22/2019 |
3.0.1 | 1,176 | 11/22/2019 |
3.0.0 | 1,308 | 5/22/2019 |
2.1.1 | 2,219 | 12/4/2017 |
2.1.0 | 1,559 | 8/5/2017 |
2.0.6 | 1,757 | 7/7/2017 |
2.0.5.8 | 1,550 | 6/8/2017 |
2.0.5.7 | 1,553 | 6/8/2017 |
2.0.5.6 | 1,549 | 6/8/2017 |
2.0.5.5 | 1,555 | 6/8/2017 |
2.0.5.4 | 1,567 | 6/8/2017 |
2.0.5.3 | 1,529 | 6/6/2017 |
2.0.5.2 | 1,544 | 6/6/2017 |
2.0.5.1 | 1,567 | 6/4/2017 |
2.0.5 | 1,573 | 6/4/2017 |
2.0.4 | 1,716 | 3/17/2017 |
2.0.3 | 1,692 | 2/16/2017 |
2.0.2.2 | 1,683 | 2/12/2017 |
2.0.2 | 1,815 | 1/9/2017 |
2.0.1 | 2,533 | 11/4/2016 |
2.0.0 | 1,741 | 10/19/2016 |
2.0.0-beta-74 | 1,638 | 8/31/2016 |
2.0.0-beta-73 | 1,638 | 8/31/2016 |
2.0.0-beta-72 | 1,688 | 8/24/2016 |
2.0.0-beta-70 | 1,650 | 8/24/2016 |
2.0.0-beta-63 | 1,880 | 7/11/2016 |
2.0.0-beta-62 | 1,857 | 7/11/2016 |
2.0.0-beta-60 | 1,722 | 7/10/2016 |
2.0.0-beta-55 | 1,962 | 1/18/2016 |
2.0.0-beta-53 | 1,803 | 12/13/2015 |
2.0.0-beta-100 | 1,614 | 8/24/2016 |
Changes:
- SqlEntityRepository Implemented
- PrimaryKey attribute added to support Sequence object
- .Net Standard 2.0 and .Net Standard 2.1 with Microsoft.Data.SqlClient support added
- Aysnc support for Dotnet full framework 4.5 and .Net Standard 2.0 and later
- Repository Performance improvement
- GetPagedList extensions methods added
- Async GetPagedList extensions methods added
- RowNumber column added in Paging extensions using addRowNumber bool parameter
- Distinct and select support added to GetPagedList extensions
- SqlRepository is renamed to SqlSpRepository and SqlRepository is marked as Obsolete
- Data mapping performance improved
- IgnoreSelect, IgnoreInsert, IgnoreUpdate and NotMapped property attributes support implemente for Repositories
- Aggregate functions (Count, Sum, Min, Max and Avg) extensions added to SqlRepository extension methods
- GetAggregate and GetAggregateWithGroupBy functions extensions added to SqlRepository extension methods
- IsExist function extension added
- 20 more overloads added for GetCount extensions method
- IN Clause support added using Contains SqlSyntax extentions
- In Clause (Sub Query) support added to Where Expression SQLEntityRepository
- Transaction support added to IsExist extensions methods
- nuget package versioning changed
Bug fixes
- SqlEntityRepository Get, Find, FindAll methods fixed
- Insert is not working with Indentity column
- Sql Server Keywords cannot be used as table column
- ExecuteScalar do not support nullable types
- Where expression throw null exception when using != operator
- ConnectionString lost user credential bug fixed
- Error in executing in Where lambda expression
- Enum is not working with Where lambda expression
- RowNumber is not loading when using the s => new Entity { id } expression with GetEntityPagedList
- Issue #9: SqlRepository.FindAll is throwing NullReference exception if the lambda parameter is nullable property
- GetDynamicPagedList and GetDynamicPagedListAsync returning all properties name in lower case
- BuildWhereClause is returning coma in value of decimal instead of dot with different culture