Skip to content

Releases: mikependon/RepoDB

Fix the MDS v5.0.1 Memory Leaks | Bug Fixes

16 Mar 22:05
@mikependon mikependon
v1.13.1
4ee230b
Compare
Choose a tag to compare
Fix the MDS v5.0.1 Memory Leaks | Bug Fixes Latest
Latest

This release has included the updates to fix the Memory Leak issue of the MDS 5.0.1 (see dotnet/SqlClient#1810). It also contains some of the minor bug fixes.

RepoDb (v1.13.1) 🚀

  • Feature: Introduce the SkipQuery operation. #377
  • Bug: RepoDb.SqlServer v1.13.0 - Memory leak in Microsoft.Data.SqlClient 5.0.1 #1128
  • Introduced the DynamicHandler() method into the IDbSetting interface.
  • Could not load file or assembly 'RepoDb.PostgreSql.dll' #1040
  • Fixed the issues when writing the records into the database via System.DataTable object using the BinaryBulkImport, when an Enum-based property is present.
  • Upgraded the Microsoft.Data.SqlClient package v5.1.0.
  • Upgraded the Npgsql package to v7.0.2.
  • Upgraded the MySql.Data package to 8.0.32.1.
  • Upgraded the MySqlConnector package to 2.2.5.
  • Upgraded the Microsoft.Data.Sqlite package to v7.0.4.

Credits 🙇🏼‍♂️

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

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!

Contributors

pmarflee, SergerGood, and 8 other contributors
Assets 11

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

02 Nov 22:11
@mikependon mikependon
v1.13.0
dc368aa
Compare
Choose a tag to compare
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

Non-Breaking

Credits 🙇🏼‍♂️

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

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!

Contributors

stefandevo, xperiandri, and 18 other contributors
Assets 11

SQLite Separation, Postgre BulkOperations, Bug Fixes, Enhancements, Request, Upgrades

18 Feb 23:31
@mikependon mikependon
v1.12.10
44c9e32
Compare
Choose a tag to compare
SQLite Separation, Postgre BulkOperations, Bug Fixes, Enhancements, Request, Upgrades

This release has included the recent bug fixes, enhancements, community pull-requests, requests and upgrades.

Credits

Thank you to our contributors and to all the collaborators.

Contributors

  • @SergerGood - Sergei Khlebnikov - special thanks to you man 🚀 🙇🏼‍♂️
    • Fix #963 Removed logic that the ordering fields should be in the select #985
    • Fix #964 Bug: NullReferenceException occurs during BulkMerge() #984
    • Support net6.0 #983
    • Add IAsyncEnumerable support to BulkInsertAsync #954

Collaborators

For our active collaborators on this release:

For the other collaborators of this release (filing the Issues/Bugs, Questions, Recommendations, Verification/Validations, etc)

Please continue to do so and many thanks!

RepoDb (v1.12.10)

  • Bug: the DeleteAll(T entities) method results in System.InvalidOperationException errors #1011
  • 实体继承基类的主键以及字段，无法在派生类中体现？ #986
  • MemoryCache: "Cannot update the item that is not yet expired." #1017
  • Behavioral Change: When calling the MemoryCache.Add method, the existing cached item (if present) information will be updated by the latest and updated one.
  • Bug: Dot in schema name #1015
  • Deprecated the method DataEntityExtension.GetSchema(string). Use the DataEntityExtension.GetSchema(string, IDbSetting) instead.
  • Deprecated the method DataEntityExtension.GetTableName(string). Use the DataEntityExtension.GetTableName(string, IDbSetting) instead.
  • Deprecated the method Type.GetImplementedInterfaces() (extended method). Use the Type.GetInterfaces() instead.
  • Bug: PropertyHandler doesn't seem to work in F# #1021
  • Bug: QueryField IN not working with multiple collections with varying sizes #1026
  • Enhancement: Use the HashCode.Combine() method in all Hashcode generations. #1031
  • Upgraded the System.Linq.Async package to v6.1.0.
  • Compiler update to utilize the customized DbParameterExtension class to compliment the compiler's needs for the NpgsqlParameter.NpgsqlDbType.Unknown.
  • Complimentary support to the Enum(s) for the RepoDb.PostgreSql.BulkOperations package.
  • Upgraded the System.Linq.Async package to v5.1.0.
  • Upgraded the Microsoft.Bcl.AsyncInterfaces package to v6.0.0.
  • (Additional Fixes) Bug: Exceptions are thrown when using a custom PropertyHandler and a Where Expression to process an Enum value (that has NULL or invalid Enum Id); the Get/Set is never invoked. #991
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Question: why to order by a field, it needs to be in the select? #963
  • Bug: Exceptions are thrown when using a custom PropertyHandler and a Where Expression to process an Enum value (that has NULL or invalid Enum Id); the Get/Set is never invoked. #991
  • Supported the .NET v6.0.
  • Initial support to PostgreSQL bulk operations.
  • Code refactoring specifically on the QueryBuilders.

RepoDb.SqlServer (v1.1.5)

  • Bug: Dot in schema name #1015
  • Referenced the RepoDb package v1.12.10.
  • Referenced the Microsoft.Data.SqlClient package v4.0.1.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Enhancement: Remove System.Data.SqlClient reference from RepoDB.SqlServer #857 - (BREAKING CHANGES)
  • Removed both the MicrosoftSqlServerTypeMapAttribute and SystemSqlServerTypeMapAttribute attributes. Use the the SqlDbTypeAttribute attribute instead.
  • Supported the .NET v6.0.

RepoDb.SqlServer.BulkOperations (v1.1.6)

  • Referenced the RepoDb package v1.12.10.
  • Referenced the RepoDb.SqlServer package v1.1.5.
  • Upgraded the System.Linq.Async package to v6.1.0.
  • Added the Microsoft.Bcl.AsyncInterfaces (version 6.0.0).
  • Initial support to the IAsyncEnumerable interface.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).

RepoDb.PostgreSql (v1.1.5)

  • Bug: Dot in schema name #1015
  • Referenced the RepoDb package v1.12.10.
  • Upgraded the Npgsql package to v6.0.3.
  • Upgraded the Npgsql package. Used the v5.0.11 for FTM netcoreapp2.0 and v6.0.0 for FTM net5.0 and net6.0.
  • Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Complimentary support to the Enum(s) for the RepoDb.PostgreSql.BulkOperations package.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Added the customized DbParameterExtension class to compliment the compiler's needs for the NpgsqlParameter.NpgsqlDbType.Unknown.
  • Upgraded the Npgsql package to v6.0.1.
  • Initial support to PostgreSQL bulk operations.
  • Enhancement: Introduced the ClientTypeToNpgsqlDbTypeResolver class.
  • Enhancement: Introduced the PostgreSqlDbTypeNameToNpgsqlDbTypeResolver class.

RepoDb.PostgreSql.BulkOperations (v0.0.9)

  • Bug: Dot in schema name #1015
  • Referenced the RepoDb package v1.12.10.
  • Upgraded the Npgsql package. Used the v5.0.11 for FTM netcoreapp2.0 and v6.0.0 for FTM net5.0 and net6.0.
  • Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Complimentary support to the Enum(s) for the RepoDb.PostgreSql.BulkOperations package.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Added the customized DbParameterExtension class to compliment the compiler's needs for the NpgsqlParameter.NpgsqlDbType.Unknown.
  • Upgraded the Npgsql package to v6.0.1.
  • Initial support to PostgreSQL bulk operations.
  • Enhancement: Introduced the ClientTypeToNpgsqlDbTypeResolver class.
  • Enhancement: Introduced the PostgreSqlDbTypeNameToNpgsqlDbTypeResolver class.

RepoDb.Sqlite.Microsoft (v1.0.1)

  • Initial release.
  • Referenced the RepoDb package v1.12.10.
  • Upgraded the Microsoft.Data.Sqlite to v6.0.2.
  • Bug: Dot in schema name #1015- Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Microsoft.Data.Sqlite Version #995
  • Upgraded the Microsoft.Data.Sqlite to v6.0.1.
  • Added the 6.0 to the target frameworks.
  • Request: Separate the SqLite Nuget Library into 2 #880.

RepoDb.SQLite.System (v1.0.0)

  • Initial release.
  • Referenced the RepoDb package v1.12.10.
  • Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Bug: Dot in schema name #1015
  • Added the 6.0 to the target frameworks.
  • Upgraded the System.Data.SQLite.Core package to v1.0.115.5.
  • Request: Separate the SqLite Nuget Library into 2 #880.

RepoDb.MySql (v1.1.6)

  • Upgraded the MySql.Data package to 8.0.28.
  • Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Bug: Dot in schema name #1015
  • Referenced the RepoDb package v1.12.10.

RepoDb.MySqlConnector (v1.1.5)

  • Upgraded the MySqlConnector package to 2.1.6.
  • Question: why to order by a field, it needs to be in the select? #963
  • Supported the .NET v6.0.
  • Added the Title and PackageTags tags in the Nuget Package (.nuspec references).
  • Bug: Dot in schema name #1015
  • Referenced the RepoDb package v1.12.10.

Contributors

marciogoularte, pmarflee, and 24 other contributors
Assets 11

PropertyValueAttributes, Bug Fixes, Enhancements, Requests, Upgrades

23 Sep 15:02
@mikependon mikependon
v1.12.8
6fefb49
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
PropertyValueAttributes, Bug Fixes, Enhancements, Requests, Upgrades

This release has included the recent bug fixes, enhancements, community pull-requests, requests and upgrades.

Credits

Thank you to our contributors and to all the collaborators.

Contributors

  • @SergerGood - Sergei Khlebnikov - special thanks to you man 🚀 🙇🏼‍♂️

    • Added benchmarks for Linq2Db #804
    • Small optimizations #805
    • using the is pattern expression #806
    • TextAttibute was deleted #809
    • AutomaticConvert == Convert.ChangeType #810
    • upgrade packages #811
    • Support net5 #815
    • using new language features #817
    • fixed some allocations #818
    • QueryBuilder work with StringBuilder #819
    • Fixed tests after change QueryBuilder #820
    • Collections used for contains are replaced with HashSet #827
    • Using strings for Concat #828
    • GetHashCode without Sting.Concat #829
    • Upgrade packages #830
    • Unnecessary allocation #833
    • Async enumerable #834
    • Removed unnecessary calls the methode GetHashCode #835
    • replace Activator.CreateInstance() with new T() #841
    • Using Comparer for OrderBy #842
    • More optimal use of method String.IndexOf #843
    • More optimal use of methods String.StartsWith and String.EndsWith #844
    • More optimal use of method String.Contains #845
    • Use readonly struct for less allocations #846
    • Typed mappers #848
    • Upgrade packages #852
    • GetHashCode for own type #853

  • @orthoxerox

    • [WIP] Postgres enum <-> .Net enum #855

Collaborators

For our active collaborators on this release:

For the other collaborators of this release (filing the Issues/Bugs, Questions, Recommendations, Verification/Validations, etc)

Please continue to do so and many thanks!

RepoDB (v1.12.8)

RepoDB.SqlServer (v1.1.4)

RepoDB.SqlServer.BulkOperations (v1.1.4)

Read more

Contributors

SpaceOgre, casperOne, and 27 other contributors
Assets 9

Bug Fixes, Enhancements, Requests, Upgrades

09 Feb 14:30
@mikependon mikependon
v1.12.7
47469e1
Compare
Choose a tag to compare
Bug Fixes, Enhancements, Requests, Upgrades

This release has included the recent bug fixes, enhancements, community pull-requests, requests and upgrades.

Credits

Thank you to our contributors and to all the collaborators.

Contributors

  • @tommasobertoni - Bugfix: TDbConnection handling #757
  • @fredliex - for the following PRs
    • Refactory db command extension [746](Refactory db command extension)
    • rewrite sql where empty array parameter. 698
    • Follow the #690 review suggestion to make adjustments 692
    • fix null parameter being mistaken for the string type 690
  • @SimonCropp - for these awesome code refactoring.
    • try fix null reference during fetch #749
    • Create RepoDb.All.sln 747
    • remove some redundant null checks 745
    • some redundant usings 744
    • fix some spelling 743
    • page and rowsPerBatch can never be null [741]#741)
    • remove some un used variables 740
    • use some null Propagation 739
    • fix broken Xml docs 734
    • fix 2 more null ref querybuilders 733
    • unnecessary delegate 731
    • spelling 730
    • minor ToUpper perf tweak 729
    • simplify some ternaries 728
    • remove some redundant constructors 727
    • inline some outs 726
    • pass some cancellationTokens 725
    • use some discards 724
    • merge type checks 723
    • add some null coalescing 722
    • no point concating single strings 721
    • remove redundant filteredDbFields (might be a Bug?) 720
    • remove redundant UtcNow 719
    • remove some redundant equality checks 718
    • fix more null refs 717
    • enable c# 9 716
    • add props file for shared settings 715
    • fix queryBuilder NullRefException 714
    • redundant tostring 713
    • add some missing param names to arg exceptions 695
    • remove some async state machines 694
    • Fixx some Spelling 693

Collaborators

For our active collaborators on this release:

For the other collaborators of this release (filing the Issues/Bugs, Questions, Recommendations, Verification/Validations, etc)

Please continue to do so and many thanks!

RepoDB (v1.12.7)

  • Enhancement: Add a Reset() method into the Parameter object. #709
  • Enhancement: Add a method DbParameter into the QueryField object. #711
  • Enhancement: Revisits the Immutable Classes Instantiation #753
  • Bug: Extract function throws exception when using ExecuteQueryMultiple #761
  • Bug: RepoDb.SqlServer Enum picking up 2 types when upgraded from 1.1.1 -> 1.1.2 #736
  • Bug: null reference during fetch #748

RepoDB.SqlServer (v1.1.3)

RepoDB.SqlServer.BulkOperations (v1.1.4)

RepoDB.SqlServer.BulkOperations (v1.1.3)

  • Bug: Identity Values not set correctly with Bulk Insert from Sql Server due to Incorrect Sorting of data. #691
  • The hints argument is removed from the BulkInsert via DbDataReader.
  • Added the WriteToServer method to cater the ordered resultset of the __RepoDb_OrderColumn custom column.

RepoDB.PostgreSql (v1.1.3)

RepoDB.SqLite (v1.1.3)

RepoDB.MySql (v1.1.4)

RepoDB.MySqlConnector (v1.1.3)

Assets 9

Complete Support to Dynamics, Bug Fixes and Enhancements

30 Dec 15:25
@mikependon mikependon
v1.12.5
5472110
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
Complete Support to Dynamics, Bug Fixes and Enhancements

This release has included the complete support to the dynamic objects (i.e.: ExpandoObject and IDictionary<string, object>).

Credits

Thank you to our contributors and to all the collaborators.

Contributors

  • @fredliex - for issuing the following PRs
    • #657 - fix #650 TypeExtension.IsPlainType seems to misjudge the string property
    • #658 - some unit test case assign culture en-US when convert DateTime to String.
    • #680 - fix convert error for type level with propertyHandler. 🚀 This is awesome!
  • @SergerGood - for issuing the following PRs. Btw, thanks for being a frequent PR contributor.
    • #625 - Benchmarks for the UpdateAll methods
    • #620 - Benchmarks for the GetAll methods
  • @Swoorup - for issuing a PR #619
  • @SpaceOgre - for issuing a PR #678
  • @stefandevo - for issuing a PR #642 - Bug: Incorrect syntax near the keyword 'WITH' BulkMergeAsync
  • @bobduncan - for issuing a PR #649 - #645 Correctly passed through tableName parameter in the DeleteAll

Collaborators

For our active collaborators on this release:

For the other collaborators of this release (filing the Issues/Bugs, Questions, Recommendations, Verification/Validations, etc)

Please continue to do so and many thanks!

RepoDb (Core) (v1.12.5)

  • Fixed the related issues found at model-based operation ExecuteQuery (almost related to #666)
  • Adhoc: Remove the Initialize method from the DataEntityDataReader. #673 - this is a breaking changes
  • Bug: Query failed when field mapping used on FSharp records. #662
  • Bug: FluentMapper is not working with Abstract Properties #666
  • Bug: BulkInsert with mappings #668
  • Question: IPropertyHandler for Dictionary<string, string> #647
  • Upgraded the Microsoft.Data.SqlClient to v2.1.0.
  • Upgraded the System.ComponentModel.Annotations to v5.0.0.
  • Request: Introduce optional caching to ExecuteScalar methods. #648
  • Enhancement: Add the non-parameterized Truncate operation. #652
  • Request: Do not crash if on empty enumerable on bulk operation #635.
  • Bug: Exception is being thrown for the Type level PropertyHandler for Dynamic Insertion #628.
  • Added a validation to ensure the type of the TPropertyHandler has implemented the IPropertyHandler interface when calling the Add() method of the PropertyHandlerCache object.
  • Enhancement: Add the dynamic ExecuteQueryMultiple method in the DbRepository #630
  • Possible bug - Enum with Flag attribute is not correctly handled #624
  • [Core] Support ExpandoObject in Insert via TableName. #234
  • [Core] Support ExpandoObject in Merge via TableName. #238
  • [Core] Support ExpandoObject in Update via TableName. #236
  • [Core] Support ExpandoObject in InsertAll via TableName. #235
  • [Core] Support ExpandoObject in MergeAll via TableName. #239
  • [Core] Support ExpandoObject in UpdateAll via TableName. #237
  • Introduce the support of Dynamic and ExpandoObject in BulkInsert. #243
  • Enhancement: Support ExpandoObject in BulkInsert #610
  • Enhancement: Support ExpandoObject in BulkMerge #611
  • Enhancement: Support ExpandoObject in BulkUpdate #612
  • Enhancement: Support ExpandoObject in BulkDelete #613

RepoDb.SqlServer.BulkOperations (v1.1.2)

  • Bug: BulkInsert with mappings #668
  • Bug: System.Data.SqlClient.SqlException: 'Column name 'ID' does not exist in the target table or view.' #651
  • Refactor the internal method implementations to only utilize the base methods for both the MDS and SDS method calls.
  • Reverted the changes to the #635.
  • Bug: Incorrect syntax near the keyword WITH BulkMergeAsync #640
  • Request: Do not crash if on empty enumerable on bulk operation #635
  • Referenced the version RepoDb.Core (v1.12.5-beta2).
Assets 9

Complete Support to Cancellation Token

03 Oct 12:51
@mikependon mikependon
v1.12.4
a05466a
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
Complete Support to Cancellation Token

This release as supported the CancellationToken as a response to #343. It affects all the supported different DB Provider packages.

Thank you @SergerGood for opening and pushing this feature for us to work with.

Assets 9

Stable 1.12.X Version - Fixes

01 Oct 20:31
@mikependon mikependon
v1.12.3
6e2d985
Compare
Choose a tag to compare
Stable 1.12.X Version - Fixes

This release is the more stable and more mature than the original v1.12.0. Various issues and requests has been pushed on the last minor releases.

RepoDB (v1.12.3)

  • Bug: Behavior change from previous versions prior v1.12.0 #602
  • Bug: Async fetch operations are not using the DbDataReader.ReadAsync method (in v1.12.0 to v1.12.2) #601

RepoDB (v1.12.2)

  • Bug: A NullReferenceException Is Thrown for NULL Query Expression #600

RepoDB (v1.12.1)

Assets 3

Compiler Collision Problem

27 Sep 12:37
@mikependon mikependon
v1.12.1
fdae148
Compare
Choose a tag to compare
Compiler Collision Problem

RepoDB (v1.12.1)

Credits

  • Thanks @Swoorup for being so collaborative here specially for your post-request on the bug #595.
Assets 3

F# Support, Class Handler, Enhanced Compiler, Many More

24 Sep 04:02
@mikependon mikependon
v1.12.0
2a3b823
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
F# Support, Class Handler, Enhanced Compiler, Many More

Release Notes

The version 1.12.0 / v1.1.0 (extensions) are one of the biggest release of RepoDB. It contains the various updates (i.e. Features, Capabilities, and Request from the Community).

  • Complete Support to F#
  • Class Handler
  • Enhanced Compiler
  • Anonymous Type / ExpandoObject / IDictionary<string, object>
  • Immutable Classes
  • Table-Based Fluent Calls
  • Complete Exposure of the fields argument
  • Support to .NET CLR Typed Result Execution
  • Support to Table-Valued Parameters (TVP)

Credits

Thank you to our contributors and to all the collaborators.

Contributors

Collaborators

RepoDB (Core) (v1.12.0)

  • Complete support to F# programming language as requested by the F# Community. Thank you to Isaac Abraham and Angel Munoz for being so collaborative.
  • Request: F# - Consider the Anonymous Types in the Query and QueryAll operation #536.
  • Bug: QueryAsync with empty QueryField list throws SQL exception #498.
  • Bug: IPropertyHandler not being called #514
  • Bug: Property mapping fails with Turkish locale #502
  • Bug: Non-query statements are not taking into account SQL Server table hints #533.
  • Bug: Async methods use synchronous calls #589
  • Feature: Introduce the ClassHandler Support #524
  • Feature: Support to Enumerable Scalar Values #538 - NEW
  • Request: Completely expose the fields argument in the BatchQuery, Query, Insert, Merge and Update operations (and all its Batch operations). #523
  • Request: Add caching for ExecuteQuery and ExecuteQuery<TEntity> #522
  • Request: Adds an overloaded method for QueryAll<TEntity> operation that takes the tableName parameter. #521 - BREAKING
  • Request: Add caching for ExecuteQuery and ExecuteQuery<TEntity> #522
  • Request: Add the 'isMoveToNextResult' argument to the QueryMultipleExtractor (Extract and Scalar) methods #591
  • Request: Support the Immutable Entities #465
  • Question: Question on how to properly configure type mapping for FSharp Option types #483
  • Question: Specific Columns in Query<TEntity> #545
  • Enhancement: Use the Identity field if the Primary field is not available during the Query, Delete and Update operations.
  • Refactoring: Enhance the coding in the Core Compiler #479. BREAKING
  • Enhancement: Complete support to the Fluent named-based operation #499.
  • Enhancement: Replaces the usage of IsNullOrEmpty to IsNullOrWhiteSpace.
  • Enhancement: Replaces the usage of ToLower() to ToLowerInvariant().
  • Enhancement: Replaces the usage of string equality to string.Equals(value1, value2, StringComparer.OrdinalIgnoreCase).
  • Enhancement: Added the Async methods in the compiler. #482 #477
  • Enhancement: Add the dynamic ExecuteQuery method in the DbRepository. #517
  • Enhancement: Renamed the whereOrPrimaryKey argument to what to extend the support to both (data entity object, dynamic/object expression, primary key and identity key), to further support the F# community. BREAKING
  • Enhancement: Updated the QueryGroup.Parse() method to be an argument-typed-based method.
  • Enhancement: Refactored and optimized the Parse method of the QueryField and QueryGroup objects.
  • Enhancement: Refactor the Table-Based Calls to return IEnumerable<ExpandoObject> instead of IEnumerable<dynamics>. #540
  • Enhancement: Consider supporting the execution of the TVP in SQL Server. #566
  • Enhancement: Support for returning IDictionary<string, object> instead of ExpandoObject. #537
  • Enhancement: Re-assess if the IsAssignableFrom can be used over the customized IsInterfacedTo. #469
  • Enhancement: Handle the Exception Handling of the Serialization/Deserialization process of the ClassHandler that is connected to a different Data Entity #539
  • Refactoring: Make all the cacheItemExpiration arguments nullable. BREAKING
  • Refactoring: Make the BaseRepository and DbRepository objects CacheItemExpiration property nullable.
  • Refactoring: Make the CacheItem object CacheItemExpiration property nullable.
  • Test: Added the Integration Tests for the NonKeyedTable.
  • Integration Tests: Added more Integration Tests for the DbType Map Attribute (includes SQL Server, PostgreSQL and MySQL).
  • Added the KeyFieldNotFoundException, MissingQualifierFieldsException and the IdentityFieldNotFoundException.
  • Added the <TEntity>(TableName) methods to the BatchQuery operation.
  • Added the <TEntity>(TableName) methods to the Query and QueryAll operations.
  • Added the <TEntity>(TableName) methods to the Delete and DeleteAll operations.
  • Added the <TEntity>(TableName) methods to the Insert and InsertAll operations.
  • Added the <TEntity>(TableName) methods to the Merge and MergeAll operations.
  • Added the <TEntity>(TableName) methods to the Update and UpdateAll operations.
  • Added the <TEntity, TResult> methods to the Average and AverageAll operations.
  • Added the <TEntity, TResult> methods to the Max and MaxAll operations.
  • Added the <TEntity, TResult> methods to the Min and MinAll operations.
  • Added the <TEntity, TResult> methods to the Sum and SumAll operations.
  • Added the execution context provider internal classes for the Insert, Merge, Update, internal class for the InsertAll, MergeAll and UpdateAlloperations.

RepoDb.SqlServer (v1.1.0)

  • Complete support to F# programming language as requested by the F# Community. Thank you to Isaac Abraham and Angel Munoz for being so collaborative.
  • Breaking: Introduced the fields argument to the fetch (i.e.: Query, ExecuteQuery and BatchQuery) and push (i.e.: Insert, [Merge](https://...
Read more
Assets 9