NReco.Data 1.2.0

.NET Standard 2.0 .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.2.0
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.2.0
<PackageReference Include="NReco.Data" Version="1.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.Data --version 1.2.0
#r "nuget: NReco.Data, 1.2.0"
#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.2.0

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

Fast lightweight data access library for .NET Core (micro-ORM): simple API for CRUD operations, dynamic queries, SQL commands generation (command builder), abstract queries that have simple string representation + 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 netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen 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 81 9/19/2022
1.2.7 1,067 2/15/2022
1.2.6 605 10/7/2021
1.2.5 2,546 3/2/2021
1.2.4 2,873 12/4/2020
1.2.3 4,516 7/25/2020
1.2.2 834 6/25/2020
1.2.1 777 6/12/2020
1.2.0 1,121 5/31/2020
1.1.1 5,112 4/12/2020
1.1.0 531 2/28/2020
1.0.6 6,129 4/16/2019
1.0.5 22,091 5/23/2018
1.0.4 7,898 10/5/2017
1.0.3 2,240 5/30/2017
1.0.2 2,352 3/24/2017
1.0.1 2,148 3/3/2017
1.0.0 1,097 1/31/2017
1.0.0-alpha6 1,879 9/19/2016

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

v.1.2.0 changes:
- added simple aggregate queries with QAggregateField #60
- fixed issue with RelexBuilder and QVar #61

v.1.1.1 changes:
- fixed issue with DbDataAdapter.Update for RecordSet when query contains parameters that are not mapped to Row columns #55

v.1.1.0 changes:
- implemented RecordSetReader.GetSchemaTable for netcore3 compatibility #53
- BREAKING CHANGE: System.ComponentModel.ListSortDirection used in netstandard20 instead of NReco.Data.ListSortDirection

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)