NReco.Data 1.0.0-alpha6

Prefix Reserved
.NET Standard 1.5 This package targets .NET Standard 1.5. The package is compatible with this framework or higher. .NET Framework 4.5 This package targets .NET Framework 4.5. The package is compatible with this framework or higher.
This is a prerelease version of NReco.Data.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package NReco.Data --version 1.0.0-alpha6                

                    
                

            
NuGet\Install-Package NReco.Data -Version 1.0.0-alpha6
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<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                

                    
                

            
#r "nuget: NReco.Data, 1.0.0-alpha6"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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.0.0-alpha6&prerelease

// Install NReco.Data as a Cake Tool
#tool nuget:?package=NReco.Data&version=1.0.0-alpha6&prerelease

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

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp1.0 was computed.  netcoreapp1.1 was computed.  netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard1.5 is compatible.  netstandard1.6 was computed.  netstandard2.0 was computed.  netstandard2.1 was computed. 
.NET Framework net45 is compatible.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen30 was computed.  tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

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

Package Downloads
NReco.GraphQL

Translates GraphQL queries to SQL according to the mapping configuration (JSON). Can be used with any ADO.NET provider. Based on Graphql.NET library. Online demo, usage examples: https://www.nrecosite.com/graphql_to_sql_database.aspx
Sentrid.Configuration

Package Description

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on NReco.Data:

Repository Stars
nreco/data
Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM).
Version Downloads Last updated
1.2.10 5,810 3/16/2023
1.2.9 3,919 10/25/2022
1.2.8 2,951 9/19/2022
1.2.7 2,506 2/15/2022
1.2.6 2,145 10/7/2021
1.2.5 5,367 3/2/2021
1.2.4 3,923 12/4/2020
1.2.3 6,036 7/25/2020
1.2.2 2,919 6/25/2020
1.2.1 1,896 6/12/2020
1.2.0 2,226 5/31/2020
1.1.1 7,182 4/12/2020
1.1.0 1,431 2/28/2020
1.0.6 9,140 4/16/2019
1.0.5 23,249 5/23/2018
1.0.4 11,717 10/5/2017
1.0.3 3,166 5/30/2017
1.0.2 3,350 3/24/2017
1.0.1 3,102 3/3/2017
1.0.0 2,086 1/31/2017
1.0.0-alpha6 2,785 9/19/2016

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