Skip to content

Home

Jump to bottom
Vitaliy Fedorchenko edited this page Aug 18, 2016 · 6 revisions

NReco Data Access Components

NReco.Data is a lightweight, provider-independent library for fast and efficient data access from .NET Core and .NET 4.x applications. It is based on low-level ADO.NET interfaces and provides simple API for SQL statements generation, schema-less CRUD operations.

NReco.Data can be used either as main application DAL or in addition to another popular data access technologies like EF6, EF Core or Dapper (it can use existing DB connection / transaction instances).

Why use NReco.Data

Despite of the fact that NReco.Data can handle POCO models, it doesn't pretend to be an ORM. On the contrary, the power of NReco.Data is in the schema-less, dynamic data access and performance-critical operations:

  • Query structure provides abstract way to compose DB queries and conditions
  • DbBatchCommandBuilder can produce multiple SELECT/INSERT/UPDATE/DELETE statements into one DbCommand.
  • RecordSet is an efficient replacement for DataTable/DataRow. Multiple record sets may be loaded into several RecordSets.
  • RecordSetReader may be used with SqlBulkCopy.WriteToServer to copy many in-memory records to SQL Server
Clone this wiki locally