NReco.Data 1.0.0-alpha6

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

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

Release Notes

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

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,052 7/25/2020
1.2.2 295 6/25/2020
1.2.1 309 6/12/2020
1.2.0 428 5/31/2020
1.1.1 2,923 4/12/2020
1.1.0 317 2/28/2020
1.0.6 3,621 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 709 1/31/2017
1.0.0-alpha6 1,133 9/19/2016
Show less