dbproviderfactories mysql_c# – 在.NET Core 2.1中安装.NET SQL Client后,DbProviderFactories.GetFactoryClass...

在.NET Framework中,提供程序可通过machine.config自动获取,并且还在GAC中全局注册.

在.NET Core中,不再有GAC或全局配置.

这意味着您必须首先在项目中注册您的提供者,如下所示：

using System.Collections.Generic;

using System.Data.CData.MySQL; // Add a reference to your provider and use it

using System.Data.Common;

using System.Linq;

namespace ConsoleApp

{

class Program

{

static void Main(string[] args)

{

// Register the factory

DbProviderFactories.RegisterFactory("test", MySQLProviderFactory.Instance);

// Get the provider invariant names

IEnumerable invariants = DbProviderFactories.GetProviderInvariantNames(); // => 1 result; 'test'

// Get a factory using that name

DbProviderFactory factory = DbProviderFactories.GetFactory(invariants.FirstOrDefault());

// Create a connection and set the connection string

DbConnection connection = factory.CreateConnection();

connection.ConnectionString = "Server = test, Database = test";

}

}

}

正如您所看到的,在这种情况下,我必须添加对Provider的引用,“System.Data.CData.MySQL”.

令人遗憾的是,您不能仅仅获得所有可用的提供程序,但这是我们必须在.NET核心中使用的.