Laurents Meyer

Add capabilities to distinguish between ACID compliant and non-compliant databases/benchmarks

1

Since I am currently working on improving/adding MySQL and MariaDB benchmarks to TFB, @roji and I came across capabilities differences and usage scenarios of database systems, which may give the...

How can users distinguish between other benchmark properties than the common ones?

4

I would like users to be able to differentiate between two different data access libraries, both accessing the same database. In this concrete case, using MySqlConnector (community developed) will be...

Change `Match` extension methods and introduce `IsMatch` ones

5

The `Match()` methods should return the relevance value of the match in the same way as the `MATCH...AGAINST` clause does in MySQL. For convenience, we keep the previous functionality to...

See https://github.com/dotnet/efcore/issues/28104.

Add support for MariaDB's "system-versioned tables" (temporal tables)

20

The SQL Server provider recently added support for [temporal tables](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-6.0/whatsnew#sql-server-temporal-tables). While MySQL has not yet added support for temporal tables, MariaDB has in form of their [system-versioned tables](https://mariadb.com/kb/en/system-versioned-tables/). We should...

See https://github.com/dotnet/efcore/pull/28056 and https://github.com/dotnet/efcore/issues/21202 upstream.

See https://github.com/dotnet/efcore/pull/28048 upstream.

Implementation should be possible for MariaDB but currently not for MySQL, that will need a workaround. See https://github.com/dotnet/efcore/issues/27372#issuecomment-1059767176.

See https://github.com/dotnet/efcore/issues/27503 upstream.

> Design decisions: > > * We will stop wrapping single-updates SaveChanges with transactions. > * For SQL Server, we will prepend `SET IMPLICIT_TRANSACTIONS OFF` for SQL Server to ensure...