NReco.Data 1.0.0

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

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

High-performance, schema-less data access library (micro-ORM): dynamic queries, SQL commands generation (command builder), relational expressions parser, annotated POCO mapping, app-level data views, RecordSet structure (replacement for DataTable).

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

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


Package Description

GitHub repositories (1)

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

Repository Stars
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

1.0.0 (final) version changes:
- fixed issue with Select().ToRecordSet when no records returned: now returns empty recordset instead of null
- DbDataView: do not wrap select expressions with brackets (some databases like sqlite don't support this syntax)
- DbDataAdapter throws ExecuteDbCommandException that keeps reference to IDbCommand that causes an exception
- added DbFactory.IdentifierFormat for specifying db-dependent delimited identifiers (table and column names)
- now relex supports table name in quotes (with special :table type) and "field" constant type (used for field names with spaces)
- fixed bug in mapping null values to POCO (null cannot be converted exception) + POCO mapping performance improvements (create instance, default values, set value)

1.0-alpha6 version changes:
- added support for annotated models (attributes from System.ComponentModel.DataAnnotations)
- added DbDataAdapter.Select overload that accepts raw sql (works like EF Core FromSql, supports parameters)
- added RecordSet.FromModel method: creates recordset with schema and data from POCO model(s)
- added missed async methods for all DbDataAdapter Insert/Update methods
- DbDataAdapter disposes all DbCommand instances
- introduced IRecordSetAdapter interface
- Fixed DbDataAdapter.Select().ToDictionaryAsync signature

1.0-alpha5 version changes:
- RecordSet enhancements: added Column.ReadOnly property, strongly-typed row value accessor (Row.Field<>), Add(IDicitonary<string,object>), introduced ColumnCollection
- fixed bug with DbAdapter.Update(RecordSet) if connection is closed
- implemented RecordSetReader (DbDataReader for RecordSet)
- added ability to load RecordSet from any IDataReader
- full async support for DbAdapter.Select + DbAdapter.DeleteAsync, DbAdapter.UpdateAsync(RecordSet)
- added RecordSet.FromReaderAsync