Roadmap - nreco/data GitHub Wiki

NReco.Data Roadmap

Possible-to-implement features

See issues list for features/enhancements that may be implemented in the future.

If you interested in a new feature please add an issue to discuss it.

1.0.0-alpha6 new features (2016-Sept-19)

  • 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.0-alpha5 new features (2016-Aug-24)

  • 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.0-alpha4 new features (2016-Aug-15)

  • 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.0-alpha3 new features (2016-Jul-20)

  • DbBatchCommandGenerator: generate SQL statements in a batch (one DbCommand for several statements)
  • ability to use DB specific SQL SELECT syntax for optimized data paging (TOP for MS SQL, PostgreSql OFFSET/LIMIT etc)
  • DbDataView: ability to define application-level views (complex SQL queries that accessed like a read-only table)
  • example for DbBatchCommandBuilder for 10,000 inserts

1.0.0-alpha2 new features (2016-Jul-17)

  • simplify DbCommand multiple use for different values with named parameters (QVar)
  • DbDataAdapter as simple API for CRUD operations, Insert/Update for POCO models
  • mapping query results to typed lists (POCO models) for DbDataAdapter.Select
  • .NET Core console app examples for DbCommandBuilder/DbDataAdapter usage

1.0.0-alpha1 features (2016-Jul-16)

  • DbCommandBuilder that generates basic SELECT/INSERT/UPDATE/DELETE parametrized sql statements
  • ability to customize SQL statement templates (SelectTemplate/InsertTemplate/UpdateTemplate/DeleteTemplate)
  • Query structure
  • RelexBuilder / RelexParser (relex = "relational expression", like: users(name like "A%")[id] )