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.

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" />

paket add NReco.Data --version 1.0.6

Release Notes

Source code and examples: https://github.com/nreco/data
API reference: https://www.nrecosite.com/doc/NReco.Data/

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

Dependencies

• .NETFramework 4.5

  • No dependencies.

• .NETStandard 1.5

  • NETStandard.Library (>= 1.6.0)
  • System.ComponentModel.Annotations (>= 4.1.0)
  • System.Data.Common (>= 4.1.0)
  • System.Reflection (>= 4.1.0)
  • System.Reflection.Primitives (>= 4.0.1)
  • System.Threading (>= 4.0.11)
  • System.Threading.Tasks (>= 4.0.11)

• .NETStandard 2.0

  • System.ComponentModel.Annotations (>= 4.4.0)

GitHub Usage

Version History