NReco.Data 1.2.5

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.

Install-Package NReco.Data -Version 1.2.5
dotnet add package NReco.Data --version 1.2.5
<PackageReference Include="NReco.Data" Version="1.2.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.Data --version 1.2.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: NReco.Data, 1.2.5"
#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.5

// Install NReco.Data as a Cake Tool
#tool nuget:?package=NReco.Data&version=1.2.5
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.2.5 changes:
- RecordSet.Column.DataType is null when loaded from the DbDataReader with default "GetColumnSchema" implementation #65

v.1.2.4 changes:
- handle DbGenerated attribute with option "None" correctly #64

v.1.2.3 changes:
- now DbFactory.AddCommandParameter is virtual
- added DbFactory.GetCmdParameterName (to allow very custom param names - like for Snowflake ADO.NET provider)

v.1.2.2 changes:
- fixed DbDataAdapter.Select().ExecuteReader offset/count handling when ApplyOffset=true #63

v.1.2.1 changes:
- QAggregateField: ability to specify custom SQL template #62

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

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.5 169 3/2/2021
1.2.4 1,090 12/4/2020
1.2.3 3,535 7/25/2020
1.2.2 457 6/25/2020
1.2.1 401 6/12/2020
1.2.0 641 5/31/2020
1.1.1 3,924 4/12/2020
1.1.0 389 2/28/2020
1.0.6 4,703 4/16/2019
1.0.5 21,612 5/23/2018
1.0.4 6,196 10/5/2017
1.0.3 2,009 5/30/2017
1.0.2 2,001 3/24/2017
1.0.1 1,907 3/3/2017
1.0.0 855 1/31/2017
1.0.0-alpha6 1,262 9/19/2016