'The specified invariant name 'System.Data.SqlClient' wasn't found in the list of registered .NET Data Providers.' on a .netCore project

user_1533387 0
Viewed 10656

I am getting the error above on a .netCore API project that's referencing .netCore library that connects to a SQL database. Can anyone help me here? I have already referenced the System.Data.SQLClient or Microsoft.Data.SqlClient and still no luck.

Thanks,

Herbert

asp.net-core .net-core
2 Answers

There is no global configuration (commonly known as GAC) in .NET Core. As a result, the provider is not registered by default. You will have to manually register the provider. You can register it as

DbProviderFactories.RegisterFactory("System.Data.SqlClient", System.Data.SqlClient.SqlClientFactory.Instance);

//for Connection
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
DbConnection connection = factory.CreateConnection();
user_60603350

Just changing Systems.Data.SqlClient to Microsoft.Data.SqlClient in Nuget already worked for me

user_9026410
Related