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

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

Release Notes

Source code and examples:
API reference:

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

NuGet packages (2)

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

Package Downloads
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 History

Version Downloads Last updated
1.2.3 1,018 7/25/2020
1.2.2 295 6/25/2020
1.2.1 307 6/12/2020
1.2.0 426 5/31/2020
1.1.1 2,918 4/12/2020
1.1.0 317 2/28/2020
1.0.6 3,617 4/16/2019
1.0.5 21,403 5/23/2018
1.0.4 5,763 10/5/2017
1.0.3 1,875 5/30/2017
1.0.2 1,849 3/24/2017
1.0.1 1,776 3/3/2017
1.0.0 708 1/31/2017
1.0.0-alpha6 1,133 9/19/2016
Show less