NReco.Data 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).

There is a newer version of this package available.
See the version list below for details.
Install-Package NReco.Data -Version 1.0.0
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
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

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

NuGet packages (2)

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

Package Downloads
NReco.GraphQL
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 History

Version Downloads Last updated
1.2.3 1,144 7/25/2020
1.2.2 306 6/25/2020
1.2.1 317 6/12/2020
1.2.0 442 5/31/2020
1.1.1 2,960 4/12/2020
1.1.0 323 2/28/2020
1.0.6 3,633 4/16/2019
1.0.5 21,412 5/23/2018
1.0.4 5,776 10/5/2017
1.0.3 1,881 5/30/2017
1.0.2 1,857 3/24/2017
1.0.1 1,782 3/3/2017
1.0.0 716 1/31/2017
1.0.0-alpha6 1,139 9/19/2016
Show less