NReco.Data 1.0.0-alpha6

.NET Standard 1.5 .NET Framework 4.5
This is a prerelease version of NReco.Data.
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-alpha6
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-alpha6
<PackageReference Include="NReco.Data" Version="1.0.0-alpha6" />
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-alpha6
#r "nuget: NReco.Data, 1.0.0-alpha6"
#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-alpha6&prerelease

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

Lightweight db-independent data access library: generates SQL commands by abstract queries (command builder), schema-less CRUD operations (data adapter), annotated POCO mapping, RecordSet (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 57 9/19/2022
1.2.7 1,060 2/15/2022
1.2.6 589 10/7/2021
1.2.5 2,542 3/2/2021
1.2.4 2,873 12/4/2020
1.2.3 4,516 7/25/2020
1.2.2 833 6/25/2020
1.2.1 777 6/12/2020
1.2.0 1,121 5/31/2020
1.1.1 5,111 4/12/2020
1.1.0 531 2/28/2020
1.0.6 6,127 4/16/2019
1.0.5 22,091 5/23/2018
1.0.4 7,883 10/5/2017
1.0.3 2,240 5/30/2017
1.0.2 2,351 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-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

1.0-alpha4 version changes:
- DbDataAdapter Insert/Update signature changed to accept IDictionary<string,object>
- a lot of internal changes required for RecordSet support
- introduced RecordSet structure (lightweight alternative to DataTable for .NET Core)
- implemented efficient DbDataAdapter.Select().ToRecordSet() and DbDataAdapter.Update(RecordSet)

1.0-alpha3 version changes:
- added DbDataView (DbCommandBuilder.Views) for application-level data views that accessed like read-only tables. Useful for encapsulating complex SQL queries, stored procedures.
- added DbBatchCommandBuilder for generating several SQL statements into one DbCommand
- added DbDataAdapter.ApplyOffset property (allows to disable offset logic on datareader level if offset is applied on DB level)
- bugfixes

1.0-alpha2 version changes:
- added DbDataAdapter for CRUD operations, supports mapping to POCO
- a lot of small changes and fixes

1.0-alpha1 version includes:
- abstract query structure
- DbCommandBuilder for generating SELECT, INSERT, UPDATE and DELETE queries
- generic DbFactory for popular ADO.NET providers (SqlClient, Sqlite, Npgsql, MySQL)
- parser for query string representation (relex)
- supports both .NET 4.x and .NET Core