Bug: Could not load type 'MySql.Data.MySqlClient.MySqlDbType

[phungxuanvuong]

When I try run Portal project, how can I fix it.

Unhandled exception. System.TypeLoadException: Could not load type 'MySql.Data.MySqlClient.MySqlDbType' from assembly 'MySqlConnector, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d33d3e53aa5f8c92'.
   at Quartz.AspNetCore.MySqlConnector.MySqlConnectorDbMetadata..ctor()                                                                reServicesWithContainerConfiguration|0(IServiceCollection services).AspNetCore.Hosting.ConfigureServicesBuilder.Invoke(Object instance, IServiceCollection services)StartupServicesFilterPip
   at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.ConfigureServices(IServiceCollection services)lection services)serviceCollecti
   at Microsoft.AspNetCore.Hosting.WebHost.EnsureApplicationServices()gateBuilder`1.<>c__DisplayClass14_0.<ConfigureServices>g__Configur
   at Microsoft.AspNetCore.Hosting.WebHost.Initialize()
   at Microsoft.AspNetCore.Hosting.WebHostBuilder.Build()
   at DotnetSpider.Portal.Program.Main(String[] args) in F:\learn\crawer\DotnetSpider\src\DotnetSpider.Portal\Program.cs:line 36

When I updated Mysql to 1.0.0, the error was resove. But I get another error:

A relational store has been configured without specifying either the DbConnection or connection string to use

[JmlSaul]

seems the problem is with Quartz.AspNetCore.MySqlConnector, the project is targeting MySqlConnector 0.61.0, where the type MySql.Data.MySqlClient.MySqlDbType is existed. in the current version of MySqlConnector it is removed.

[JmlSaul]

temporarily copy these two class to your portal project, and remove reference to Quartz.AspNetCore.MySqlConnector may fix the problem. or the owner updates Quartz.AspNetCore.MySqlConnector .

        public static class ServiceCollectionExtensions
    {
        public static QuartzOptionsBuilder UseMySqlConnector2(this QuartzOptionsBuilder builder, string connectString, string serializerType = "binary", string tablePrefix = "QRTZ_")
        {
            builder.UseMySql(connectString, serializerType, tablePrefix);
            builder.Properties.Set("quartz.dataSource.myDs.provider", "MySqlConnector");
            MySqlConnectorDbMetadata mySqlConnectorDbMetadata = new MySqlConnectorDbMetadata
            {
                ParameterDbTypePropertyName = "MySqlDbType",
                DbBinaryTypeName = "Blob"
            };
            mySqlConnectorDbMetadata.Init();
            DbProvider.RegisterDbMetadata("MySqlConnector", mySqlConnectorDbMetadata);
            return builder;
        }
    }

    public class MySqlConnectorDbMetadata : DbMetadata
    {
        private readonly Type _parameterDbType;

        private readonly Type _connectionType;

        private readonly Type _commandType;

        private readonly Type _parameterType;

        private readonly Type _exceptionType;

        public override string ProductName => "MySQL, MySQL provider";

        public override string ParameterNamePrefix => "?";

        public override Type ConnectionType => _connectionType;

        public override Type CommandType => _commandType;

        public override Type ParameterDbType => _parameterDbType;

        public override Type ParameterType => _parameterType;

        public override Type ExceptionType => _exceptionType;

        public override bool BindByName => true;

        public MySqlConnectorDbMetadata()
        {
            _parameterDbType = typeof(MySqlDbType);
            _connectionType = typeof(MySqlConnection);
            _commandType = typeof(MySqlCommand);
            _parameterType = typeof(MySqlParameter);
            _exceptionType = typeof(MySqlException);
        }
    }