Support to both driver 'System.Data.SQLite.Core' and 'Microsoft.Data.Sqlite'.

RepoDb.SqLite (v1.0.16)

• Supported both the drivers from System.Data.SQLite.Core and Microsoft.Data.Sqlite.
• The switch from System.Data.SQLite.Core to Microsoft.Data.SQLite.Core is a pretty big breaking change #497.

Credits

• Thank you @dalebrubaker and @FutureTD for pushing this.

Bulk Async Optimizations, Bug Fixes, Enhancements

RepoDb (v1.11.6)

• Code optimizations and XML comments refactoring.
• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Bug: Typed UpdateAsync fails for composite key table #493
• Bug: RepoDb does not seem to work for SQL Server tables with dot in the name #492
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Using async DbFieldCache #481
• Enhancement: Add a SessionId property in the TraceLog class. #484
• Enhancement: Refactor the usage of Count() and ElementAt().
• Request: Enable the Enumerable when calling the operations with IN operation. #495
• Obsolete: Completely removed the PropertyTypeHandlerMapper class.
• Obsolete: Completely removed the TypeMapper.Map() method.
• Obsolete: Completely removed the TypeMapper.Unmap() method.
• Obsolete: Completely removed the TypeMapper.ConversionType property.
• Added some micro optimizations #476
• Added a DataEntityReader.Connection property.
• Added a DataEntityReader.Transaction property.
• Added a DataEntityReader.Initialize method
• Added a DataEntityReader.InitializeAsync() method.

RepoDb.SqlServer (v1.0.13)

• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Refactor the usage of Count() and ElementAt().
• Bug: RepoDb does not seem to work for SQL Server tables with dot in the name #492

RepoDb.SqlServer.BulkOperations (v1.0.14)

• Enhancement: Async all the way #477
• Enhancement: Refactor the usage of Count() and ElementAt().

RepoDb.SqLite (v1.0.15)

• Updated the underlying driver from System.Data.SQLite to Microsoft.Data.Sqlite.Core.
• Request: RepoDb.SqLite remove dependency on EntityFramework #486
• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Refactor the usage of Count() and ElementAt().

RepoDb.MySql (v1.0.15)

• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Refactor the usage of Count() and ElementAt().
• Upgraded the driver version of MySql.Data to v8.0.21

RepoDb.MySqlConnector (v1.0.4)

• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Refactor the usage of Count() and ElementAt().

RepoDb.PostgreSql (v1.0.12)

• Bug: NullReferenceException occurs when InsertAllAsync is executed on Connection that belongs to TransactionScope. #490
• Enhancement: Remove the SchemaSeparator property from the IDbSetting interface #475
• Enhancement: Refactor the usage of Count() and ElementAt().

Credits

• Thank you @SergerGood for the PRs (#476, #477 and #483).

Bug Fixes, Enhancements, Requests, Upgrades

RepoDb (v1.11.4)

• Bug: Table schema is ignored for the identical table names #456
• Bug: Regression Issue #457
• Bug: Table Attribute Potential Bug #464
• Bug?: SqlException: Incorrect syntax near ')' #463
• Updated the XML documentations of the cache argument for both Query and QueryAll operations.

RepoDb.SqlServer (v1.0.11)

• Updated the version of Microsoft.Data.SqlClient into v2.0.0.
• Bug: table schema are ignored #456
• Referenced the version RepoDb.Core (v1.11.4).

RepoDb.SqlServer.BulkOperations (v1.0.12-beta1)

• Enhancement: Support commandTimeout parameter in Bulk Operations #466.
• Referenced the version RepoDb.SqlServer (v1.0.11)

RepoDb.SqLite (v1.0.13)

• Referenced the version RepoDb.Core (v1.11.4).
• Upgraded the reference of System.Data.SQLite version 1.0.113.1.

RepoDb.MySql (v1.0.13)

• Referenced the version RepoDb.Core (v1.11.4).

RepoDb.PostgreSql (v1.0.10)

• Referenced the version RepoDb.Core (v1.11.4).
• Upgraded the reference of Npgsql version 4.1.3.1.

BulkOperations Performance, Field Expression Parsing for Multiple Properties

RepoDb (v1.11.3)

• Community Request: Enhancement: Enable Field class to Parse the Expression for Multiple Properties #453
• Enhancement: Set the return type Field.Parse<T>() to IEnumerable<Field> (instead of Field).
• Added more Unit Tests on Field class parsing method.
• Removed the BeforeBulkInsert and AfterBulkInsert from the ITrace interface.
• Made the CancellableTraceLog class non-sealed, and also, exposed the constructor.
• Added an overload method for the Merge, MergeAll and UpdateAll operations that accepts the expression for the qualifiers argument.

RepoDb.MySql (v1.0.12)

• Referenced the version RepoDb.Core (v1.11.3).

RepoDb.MySqlConnector (v1.0.1)

• Referenced the version RepoDb.Core (v1.11.3).

RepoDb.PostgreSql (v1.0.9)

• Referenced the version RepoDb.Core (v1.11.3).

RepoDb.SqLite (v1.0.12)

• Referenced the version RepoDb.Core (v1.11.3).

RepoDb.SqlServer (v1.0.10)

• Referenced the version RepoDb.Core (v1.11.3).

RepoDb.SqlServer.BulkOperations (v1.0.11)

• Enhancement: Enable Field class to Parse the Expression for Multiple Properties at BulkOperations (BulkDelete, BulkInsert, BulkMerge and BulkUpdate). #453

Initial Support for MySqlConnector, Support to SQL Server Bulk Operations Return Identity

RepoDb.MySql (v1.0.0)

• Initial release to MySqlConnector. References (#446, Commits).
• Added the extensive Unit Tests and Integration Tests for MySqlConnector.
• Added the AppVeyor for MySqlConnector.

RepoDb.SqlServer.BulkOperations (v1.0.9)

• Enhacement: Return the identity values during the BulkInsert and BulkMerge. #396
• Added the BulkOperationIdentitiesResult class to cater the bulk operation results for BulkInsert and BulkMerge.
• Added the isReturnIdentity and usePhysicalPseudoTempTable arguments in the BulkInsert and BulkMerge operations.
• Added the hints argument in the BulkInsert operations.
• Added more Integration Tests to cater the changes made for isReturnIdentity and hints arguments.

Credits to Contributor

• @bgrainger - thank you for realizing the RepoDb.MySqlConnector package.

RepoDb v1.11.1 (Bug Fixes, Enhancements)

RepoDb (v1.11.2)

• Bug: [SQL Server 2019] RepoDb truncates strings of "Text" types #444
• Request: [SQL Server] Provide better exception message when table mapping is wrong #443

RepoDb.SqlServer (v1.0.9)

• Referenced the version RepoDb.Core (v1.11.2).

RepoDb.SqlServer.BulkOperations (v1.0.8)

• Referenced the version RepoDb.SqlServer (v1.0.9).

RepoDb.PostgreSql (v1.0.8)

• Referenced the version RepoDb.Core (v1.11.2).

RepoDb.MySql (v1.0.11)

• Referenced the version RepoDb.Core (v1.11.2).

RepoDb.SqLite (v1.0.11)

• Referenced the version RepoDb.Core (v1.11.2).

Credits to Contributors

• @cwaldron - for enabling the Key, Table and Column attribute supports.
• @davidrot - for issuing a fix on the PropertyHandlers triggering bugs.
• @fake-fur - for fixing the conflicting database field generation at MySql.
• @GeeWee - for fixing some snippets in the documentation and by linking in our README.

Thank you for your contributions!

New Features (Implicit Mapping), Bug Fixes, Enhancements

RepoDb (v1.11.1)

• Bug: The property handler mapping via FluentMapper or PropertyHandlerMapper is not being triggered. #438
• Requests: Support for Table attribute #360
• Optimization: Transfer the logic of ClassProperty into various mappers.
• Optimization: Added an IResolver interface that does not require an input argument.
• Bug: The property handler mapping via FluentMapper or PropertyHandlerMapper is not being triggered. #438
• Bug: No coercion operator is defined between types System.String and System.Guid. #437
• Added an extensive Integration Tests for Property Handler Implicit Mapping.
• Added an extensive Unit and Integration Tests for Key, Column and Table attributes support. #435
• Added more Unit Tests for Key/Primary and Table/Column/Map collisions. #435
• Added the GetTypeMapAttribute(), GetPropertyHandler(), GetPropertyHandlerAttribute() methods in the ClassProperty class.
• Added the PrimaryResolver to resolve the primary ClassProperty of the data entity type.
• Added the IdentityResolver to resolve the identity ClassProperty of the data entity type.
• Added the ClassMappedNameResolver to resolve the database object name mapping of the data entity type.
• Added the PropertyMappedNameResolver to resolve the cached column name mappings of the property.
• Added both the TypeMapPropertyLevelResolver and TypeMapTypeLevelResolver classes to resolve the equivalent DbType object of both the property and .NET CLR type.
• Added both the PropertyHandlerPropertyLevelResolver and PropertyHandlerTypeLevelResolver classes to resolve the equivalent property handler of both the property and .NET CLR type.
• Added the entityType argument in the DbCommandExtensions.CreateParameters() method.

RepoDb.SqlServer (v1.0.8)

• Referenced the version RepoDb.Core (v1.11.1).

RepoDb.SqlServer.BulkOperations (v1.0.7)

• Referenced the version RepoDb.SqlServer (v1.0.8).

RepoDb.SqLite (v1.0.10)

• Referenced the version RepoDb.Core (v1.11.1).
• Upgraded the reference of System.Data.SQLite version 1.0.112.2.

RepoDb.MySql (v1.0.10)

• Referenced the version RepoDb.Core (v1.11.1).
• Bug: insert<T> issue - parameter 'xxx' already added #432
• Referenced the latest beta version of RepoDb.Core (v1.11.0-beta4).

RepoDb.PostgreSql (v1.0.7)

• Referenced the version RepoDb.Core (v1.11.1).
• Bug: (Direct Reports) Fixed the issue at DeleteAll() via primary keys if the items is beyond 2100.
• Performance: Reverted the value of Constant.DefaultBatchOperationSize into 10.

Credits to Contributors

• @cwaldron - for enabling the Key, Table and Column attribute supports.
• @fake-fur - for fixing the conflicting database field generation at MySql.

Thank you for your contributions!

Bug Fixes, Enhancements (Cache, Bulk), Expression Trees), IExpirable Interface

RepoDb (v1.10.11):

• Implemented the IExpirable into CacheItem.
• Added a TEntity generic type in the CacheItem properties.
• Added the IExpirable interface.
• Added the CacheItem.CacheItemExpiration property.
• Added the ConverterNotFoundException class.
• At the CancellableTraceLog.Cancel() method, the throwException argument has been defaulted the True.
• Enhancement: Ensure that PropertyHandler(s) must ignore the TypeMapper automatic conversion and also Enum handlers. #412
• Enhancement: Make the Constant.DefaultBatchOperationSize property value to 30. Targetting the bulk operations (ie: BulkInsert, BulkDelete, BulkMerge and BulkUpdate) default batch-size.
• Bug: UnaryExpression: Add support for && and || operators in the expressions 398
• Bug: Enum Bug #400
• Bug: Enum Bug on Null value on Insert. #401
• Bug: PropertyHandler for Nullable Enum #402
• Bug: Calling to DeleteAll operation with the list of PrimaryKeys and Transaction object is failing. Reported by Christian Franck. #404.

Links:

You can visit the releases here.

RepoDb Bulk Operations Full Support

RepoDb.SqlServer.BulkOperations v1.0.4:

• Referenced the latest version of RepoDb.Core (v1.10.10).
• Fully supported the Bulk Operations (BulkDelete, BulkInsert, BulkMerge and BulkUpdate) for both System.Data.SqlClient and Microsoft.Data.SqlClient namespace.
• Auto set the options to SqlBulkCopyOptions.KeepIdentity for BulkDelete, BulkMerge and BulkUpdate (if there an identity primary/column from the DB).
• Used an underscore over dashes when composing the temporary/pseudo tables.
• Added an extensive Integration Tests for all Bulk methods (both SDS and MDS namespaces).

RepoDb.Core v1.10.10:

• Features: Full support to Bulk Operations (BulkDelete, BulkInsert, BulkMerge and BulkUpdate).
• Enhancement: AsFieldsAsAliasFields - added left and right aliases.
• Enhancement: XML Documentation updates for the SQL Statement Builders.
• Enhancement: Add a Type extended method named IsNullable.
• Bug: Solve the intermittent "NullReferenceException" when calling the Batch Operations (ie: InsertAll, MergeAll, UpdateAll). #392
• Bug: The property handlers mapped via PropertyTypeHandlerMapper is failing if both NULLABLE and NON-NULLABLE property types are present in the class. #394

RepoDb Stable Release - Initial Core Features

This is the first stable release of RepoDb together with all its extensions (RepoDb.MySql, RepoDb.SqLite, RepoDb.PostgreSql).