Paradigm.ORM 5.0.0

• Changed .NET Standard libraries to .NET 8.0.
• Updated dependencies to latest versions.
• Migrated SQL Server connector to use Microsoft.Data.SqlClient vs System.Data.SqlClient. This will bring a lot of new security options to connect to Azure Entra ID, and a lot of security fixes and validations.

  IMPORTANT: This is a breaking change. If you were using the SqlServer connector, your connection strings will probably require some updates, to use either one of several options provided within Azure, or to use proper certificates and encryption.

Paradigm.ORM v4.0.1

• Updated dependencies to latest versions.
• Updated the pgsql connector, and enabled a compatibility mode for function calls.
• NEW: The DbPublisher will accept reading the connection string from an environment variable to improve source code security. You can use the environment variable Paradigm_ORM_ConnectionString

  Paradigm_ORM_ConnectionString="Server=127.0.0.1;User=sa;Password=Paradigm_Test_1234;Connection Timeout=3600"

Paradigm.ORM v4.0.0

• Updated projects to .net 7.0.
• Updated dependencies to latest versions.
• Updated how the scylla docker db is created, and tests executed.
• NEW: Added a new #go directive to DbPublisher to allow multiple commands in one file. The application will separate the commands and execute individually.
• NEW: DbPublisher will now exit with a non-zero value when errors are found during the process to allow for CI tests.

Paradigm.ORM v3.0.0

• Updated projects to .net6.0.
• Updated dependencies to latest versions.
• Updated tests to utilize new features.
• Due to breaking changes on PostgreSQL, a temporal fix has been added to the connection to support old date formats, see more here and here.

Paradigm.ORM v2.6.4

• Added a new feature to the dbpublisher tool to ignore script errors on execution. This only works while executing scripts, but the parameter will be dropped and ignored for file generation. To ignore the errors produced by a script, add the line #ignore-errors to your script file, and the ScriptBuilder will configure the script to ignore errors, and will remove that line from the content. This can come in handy for cassandra and scylla, because there's no way of checking before altering a table, and subsequent executions will produce errors if you are using dbpublisher for incremental builds.

Paradigm.ORM v2.6.3

• Updated cassandra connector to cache active connections by connection string instead of disposing them. When working with multiple threads, the ORM used to create multiple connections, and dispose them after finalization.
  Disposing the active connection also disposed the internal cluster and session, producing unintended side effects inside the datastax driver: A lot of leaked references being captured and not collected by GC.
  With this new change, we expect to provide a better performance and memory footprint overall.
  If you need to clean all the static connections, you can still call to CqlConnectionManager.ClearConnections() but note that clearing the connections won't free everything, due to how the datastax driver caches internal pool objects.
• Updated nuget dependencies.

Paradigm.ORM Release v2.6.2

• Moved the open check to a more generic method.

Paradigm.ORM v2.6.1

• Updated connector to open connection before creating a transaction, if the connection was closed.
• Added tests for transactions.

Paradigm.ORM v2.6.0

• Updated connector specific commands to check if the connection has been opened before executing.
• Removed open check from extensions.
• Updated nuget dependencies.

Paradigm.ORM v2.5.0

• Due to a constraint with Tuples, now the reader stored procedure must return a Tuple<List<TResult8>> for the last parameter.
• Updated code to use declarative using.
• Updated code to use async when possible in some cases that was calling the sync version.