用SqlClient链接SQLService数据库时一直有异常:"The specified invariant name 'System.Data.SqlClient' wasn't found in the list of registered .NET Data Providers."('在已注册的 .NET 数据提供程序列表中找不到指定的不变名称 'System.Data.SqlClient'.在 .netCore 项目上)让我头大,通过不懈努力找到了解决方法。
只需要在Program开头部分加入:
#region //NetCore需要手动注册SqlClient
DbProviderFactories.RegisterFactory("System.Data.SqlClient", System.Data.SqlClient.SqlClientFactory.Instance);
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
DbConnection connection = factory.CreateConnection();
#endregion //NetCore需要手动注册SqlClient
public static void Main(string[] args)
{
#region //NetCore需要手动注册SqlClient
DbProviderFactories.RegisterFactory("System.Data.SqlClient", System.Data.SqlClient.SqlClientFactory.Instance);
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
DbConnection connection = factory.CreateConnection();
#endregion //NetCore需要手动注册SqlClient
CreateHostBuilder(args).Build().Run();
}