Release Notes

General Changes

• Added support for .NET 10
• Updated Dapper to version 2.1.66

Database Driver Updates

MySQL Driver

• Updated MySQL.Data to version 9.5.0

MySqlConnector Driver

• Updated MySqlConnector to version 2.5.0

PostgreSQL Driver

• Updated Npgsql to version 10.0.0

System.Data.SQLite Driver

• Updated System.Data.SQLite to version 2.0.2
• Updated System.Data.SQLite.Core to version 1.0.119

Microsoft.Data.Sqlite

• Updated Microsoft.Data.Sqlite to version 10.0.0
• Updated Microsoft.Data.Sqlite.Core to version 10.0.0

SQL Server

• Updated Microsoft.Data.SqlClient to version 6.1.3

Breaking Changes

⚠️ Important: Please review the following breaking changes before upgrading:

• Dropped support for .NET 6 - This version is no longer supported
• Changes to Contains method behavior - Some calls using the Contains method to generate IN queries may require adjustments due to a breaking change in C# 14. For migration examples, please refer to this commit that fixes the unit tests

Full Changelog: 1.2.5...1.3.0

• Add support for other types than int while Inserting data (AUTO_NUMBERED columns)
• Async/Await improvements
• external dependencies updated (MySQL.Data, MySQLConnector, PostgreSQL, SQLServer Client)
• Fix a bug while retrieving PrimaryKey information on SQLServer

Attention point for PostgreSQL, npgsql 6 changes behavior regarding DateTime, see here for info https://github.com/npgsql/doc/blob/main/conceptual/Npgsql/types/datetime.md/

Thanks to @avtc for merge request !

• Add TableExists, CreateTable and DropTable on OrmConnection (#35 )
• Fix SQLServer decimal support (#32 )
• Add support for Computed Column information

Some fixes in GetTableColumnDefinition

Bug fix release:

• Ensuring that commands are well disposed

Release 1.2.0 !

• SQL Query generation rewritten to be easily maintained and to improve speed
• A lot of new features (string and date functions, Schema support, dynamic query support, database metadata, ...)
• A new web site with all the documentation Simplestack.org
• Huge efforts in Unit test to improve coverage
• Update dependencies, Dapper, MysqlConnector, ...

This is a major release, expect some changes in API but migration should be quite straightforward.

Add support for butwize operators (&|,<<,>>)
Fix NULL detection to always use IS NULL