Roadmap

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