Exception thrown when using Entity Framework class library from ASP.NET Core 2.2 Web API project

Question

I have 2 projects in my solution:

An ASP.NET Core 2.2 Web API project
A .net framework class library

In my class library I have created my entities using a database-first approach. In my Web API project, I am referencing the class library.

When I run the application, an exception gets thrown at this point:

return entities.IP_Types.ToList();

This is the exception below:

System.ArgumentException: 'The ADO.NET provider with invariant name 'System.Data.SqlClient' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details.'

My app.config file seems to be correctly set up. I have the following code in it:

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
        <provider invariantName="System.Data.SqlClient" 
                  type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
</entityFramework>

Samir Boulos · Accepted Answer · 2019-07-05 06:54:57Z

1

I managed to get over the exception by adding this line to the Program's Main method:

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

answered Jul 5, 2019 at 6:54

Samir Boulos

214 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tejus · Accepted Answer · 2019-07-05 06:42:42Z

0

Check your database connection string. Either its missing the providerName or the config file is missing the settings for entityFramework provider.

<entityFramework>
    <providers>
        <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
</entityFramework>

To know more about the connection configuration, Check out EF Database Providers

answered Jul 5, 2019 at 6:42

Tejus

7241 gold badge7 silver badges19 bronze badges

Collectives™ on Stack Overflow

Exception thrown when using Entity Framework class library from ASP.NET Core 2.2 Web API project

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related