• Optimized SELECT COUNT queries — they are now executed natively in SQL.
• The Decimal type is no longer supported by default for the SQLite provider.
• Updated to .NET version 8.
• Replaced the SQLite driver from System.Data.SQLite v1.0.115.5 with Microsoft.Data.Sqlite v8.0.16.
• Replaced the MySQL driver from MySql.Data v8.0.28 with MySqlConnector v2.4.0.
• Replaced the MongoDB driver from MongoDB.Driver.signed v2.14.1 with MongoDB.Driver v2.30.0.
• Updated dependencies in the OptimaJet.DataEngine.Mssql package:
  • Microsoft.IdentityModel.JsonWebTokens to v8.10.0
  • System.IdentityModel.Tokens.Jwt to v8.10.0
  • System.Runtime.Caching to v8.0.1
  • System.Text.RegularExpressions to v4.3.1
• Updated dependencies in the OptimaJet.DataEngine.Oracle package:
  • System.Text.Json to v8.0.5
• Updated dependencies in the OptimaJet.DataEngine.Postgres package:
  • System.Text.Json to v8.0.5

• Fixed a bug in the StartsWith and EndsWith filters where they were working in reverse.

Contains Breaking Changes

• The parameter params string[] providerNames in TypeHandlersRegistry.Register has been changed to string providerName.
• Namespace corrections: TypeHandlers.Default is now simply TypeHandlers.
• TypeHandlersRegistry no longer overwrites user-defined handlers with default ones.
• And other minor code improvements.

Contains Breaking Changes

• Reworked the process of passing settings to providers' implementations. Added the method IProvider.UseOptions to create a local context with settings.
• Added the ability to specify the database schema. Note that this is not supported by all databases.
• Introduced splitting large queries in InsertAll and SelectByKeys into subqueries to avoid parameter overflow errors.
• Reworked the addition of TypeHandlers in SQL providers. This mechanism is now more reliable and understandable, and it also supports detecting vanilla Dapper in the project.
• Updated SqlKata to version 1.0.0.

Contains Breaking Changes

• Optimized namespace usage and project structure.
• Revised access modifiers for certain classes.

This release contains a significant number of breaking changes!

• The license has been changed to MIT.
• The mechanism for creating a repository object and selecting the current provider has been redesigned.
• Added provider context and the ability to easily swap them out.
• Enhanced transaction handling: nested transactions and passing external transactions are now supported.
• Optimized the mechanism for establishing database connections.
• Improved stability and thread safety.
• Numerous known bugs and errors have been fixed.