NReco.Data 1.0.6

.NET Standard 1.5 .NET Framework 4.5
There is a newer version of this package available.
See the version list below for details.
NuGet\Install-Package NReco.Data -Version 1.0.6
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.
dotnet add package NReco.Data --version 1.0.6
<PackageReference Include="NReco.Data" Version="1.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.Data --version 1.0.6
#r "nuget: NReco.Data, 1.0.6"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install NReco.Data as a Cake Addin
#addin nuget:?package=NReco.Data&version=1.0.6

// Install NReco.Data as a Cake Tool
#tool nuget:?package=NReco.Data&version=1.0.6

Fast data access library for .NET Core (micro-ORM): simple API for CRUD, dynamic queries, SQL commands generation (command builder), relational expressions parser, schema-less data access, flexible query results mapping to annotated POCO models, app-level data views, RecordSet structure (replacement for DataTable). Try out NReco.Data if you're looking for Dapper alternative with abstract queries and automated SQL generation.

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp1.0 netcoreapp1.1 netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard1.5 netstandard1.6 netstandard2.0 netstandard2.1
.NET Framework net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen30 tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on NReco.Data:

Package Downloads
NReco.GraphQL The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

Translates GraphQL queries to SQL by mapping configuration (JSON). Compatible with any ADO.NET provider.

Sentrid.Configuration

Package Description

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on NReco.Data:

Repository Stars
nreco/data
Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM).
Version Downloads Last updated
1.2.8 50 9/19/2022
1.2.7 1,057 2/15/2022
1.2.6 588 10/7/2021
1.2.5 2,532 3/2/2021
1.2.4 2,869 12/4/2020
1.2.3 4,515 7/25/2020
1.2.2 828 6/25/2020
1.2.1 776 6/12/2020
1.2.0 1,119 5/31/2020
1.1.1 5,106 4/12/2020
1.1.0 530 2/28/2020
1.0.6 6,116 4/16/2019
1.0.5 22,090 5/23/2018
1.0.4 7,853 10/5/2017
1.0.3 2,240 5/30/2017
1.0.2 2,350 3/24/2017
1.0.1 2,147 3/3/2017
1.0.0 1,096 1/31/2017
1.0.0-alpha6 1,878 9/19/2016

Source code and examples: https://github.com/nreco/data
API reference: https://www.nrecosite.com/doc/NReco.Data/

v.1.0.6 changes:
- insert operation fails in case of autoincrement and transaction (issue #48) - breaking change in IDbFactory interface
- added == and != operator overloads for DBNull (issue #49)

v.1.0.5 changes:
- now 'recordoffset' is not-defined when 0 (issue #44)
- ability to specify ApplyOffset only for concrete select (issue #46)
- add support of nullable types and handling of nulls for non-nullable in DataReaderResult.Single<T> (issue #47)

v.1.0.4 changes:
- added DbDataAdapter.Select overload that accepts FormattableString (like in EF Core)
- netstandard2.0 build
- added DataReaderResult.ToDataTable and DbDataAdapter.SelectQuery.ToDataTable methods (net45/netstandard2.0)

v.1.0.3 changes:
- Changed DbParameter to IDbDataParameter in CommandParameter constructor
- Added RecordSet.FromReader overload that accepts limit parameter