MySql.Data and MySql.EntityFrameworkCore for MariaDB

Looks like MySql.Data and MySql.EntityFrameworkCore packages do not work with MariaDB and gives very strange error:

System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ToInt32(Object value, IFormatProvider provider)
   at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection)
   at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
   at MySql.Data.MySqlClient.MySqlConnection.Open()

Fix for that is quite easy. Just delete nuget reference to MySql.Data or MySql.EntityFrameworkCore and add reference to MySqlConnector (if you don’t want EF Core), or Pomelo.EntityFrameworkCore.MySql (if you want EF Core).

Both connectors will work with MySql and MariaDB.

MySqlConnector will just work, Pomelo requires to change the way you connect to the database.

Instead of:

options.UseMySql(ConnectionString);

Use:

options.UseMySql(ConnectionString, ServerVersion.AutoDetect(ConnectionString));