Overall Tracing Refactoring, Version Alignment, GlobalConfigurations, Trace/Cache Async, Bug Fixes, Enhancements, Request

This release has included the long-awaited new Tracing capabilities, enablement of the Async Caching, Global Configurations and many more (i.e.: Bug Fixes, Enhancements, Community PRs and Requests).

RepoDb (v1.13.0) 🚀

Highlights

• Enhancement: Re-implement the Tracing overall implementations - Addressing the Simplicity and Extensibility #941

Breaking

• Enhancement: Simplified the constructors of the QueryField and DirectionalQueryField classes.
• Enhancement: Simplified the constructors of the extended query field objects FunctionalQueryField, LeftQueryField, RightQueryField, LeftTrimQueryField, RightTrimQueryField, LengthQueryField, LenQueryField, LowerQueryField, UpperQueryField, TrimQueryField classes.
• Enhancement: Removed the Field argument from all the query field objects.
• Enhancement: Removed the Type property from the DirectionalQueryField object.
• Enhancement: Enable IDbDataParameter as query arguments #1060

Non-Breaking

• Bug: No coercion operator is defined between types System.TimeSpan and System.Int64. #1033
• Bug: Type with custom mapping used in an array is not mapped to specific DBType #1053
• Bug: DbRepository's Truncate operations do not handle transactions #1041
• Bug: Sort Columns are no longer being verified #1049
• Enhancement: Explicit selection of the datatype for query parameters #1052
• Enhancement: Added the DbType as property to both the Parameter and QueryField classes.
• Enhancement: Removed the type filter (of class) in the ExecuteQueryMultiple operation.
• Enhancement: Remove the QueryBuilder on the IStatementBuilder interface methods #1055
• How to use ExecuteQueryMultiple cache? #1044
• Enhancement: Enable the Anonymous Types and Query Objects on QueryMultiple #1062
• Enhancement: Add the fields and cacheItemExpiration as arguments to the QueryMultiple operation #1071
• Enhancement: Enable the TableName invocation in the QueryMultiple operations #1065
  Enhancement: Enable the dynamic result from the QueryMultiple operations #1070
• Enhancement: Support the Type level assignment of PropertyValueAttribute #1059
• Enhancement: Removed the includeMappings argument from the PropertyInfo.GetPropertyValueAttributes(), PropertyValueAttributeCache and PropertyValueAttributeResolver methods.
• Enhancement: Introduced the PropertyValueAttributeTypeLevelResolver class.
• Enhancement: Obsoleted the PropertyValueAttributeResolver class and introduced the replacement class named PropertyValueAttributePropertyLevelResolver class.
• Request: Insert methods should return the PK regardless of if the PK was generated by the DB or not #1027
• Enhancement: TypeMapper for MSSQL (Udt and Spatial) #1023
• Enhancement: Introduce the Async methods to the ICache interface #1080
• Bug: QueryAsync interfering with PK #1046
• Question: How does one trace Async methods? #945
• Introduced the NullToDbNull method into the Converter class.
• Enhancement: Add a PropertyHandlerOptions and ClassHandlerOptions class #1088
• Obsoleted the Converter.ConversionType property.
• Removed the Constant.MaxParametersCount property.
• Enhancement: Introduce the initialization within the library using an GloalConfigOptions class #1087
• Enhancement: Add a switch of which value to return (Identity/Primary) during the push operations (Insert, InsertAll, Merge and MergeAll). #1086
• Enhancement: Add a switch of which value to return (Identity/Primary) during the push operations (Insert, InsertAll, Merge and MergeAll). #1086 - (Updates to both PostgreSQL, MySQL, SQLite (System/Microsoft) extended libraries)
• Enum: writing to db fails, when global-option is automatic or db-field is primary-key #1100
• Enums: error when dbValue doesn't exist in Enum-Values #1099
• Upgraded the Microsoft.Data.SqlClient package to v5.0.1.

Credits 🙇🏼‍♂️

Thank you to all the collaborators of this release (filing the Issues/Bugs, Questions, Recommendations, Verification/Validations, etc).

• @cajuncoding
• @karli1
• @iturribeitia
• @stefandevo
• @Swoorup
• @fla91fr
• @jgranger36
• @xperiandri
• @databrecht
• @Trobeloo
• @Garios
• @w5l
• @Simon-Carr
• @zetomatoz
• @seongguk2i
• @dendism
• @Grauenwolf
• @rafek1241
• @Vinko90
• @JanBrandenburger

For the other unlisted collaborators who made the contributions (i.e.: posting and answering comments) on the User Stories, and also to those who directly collaborated with our communities (in many ways), we are also extending our thanks to you.

Please continue to do so and many thanks!