Make sure the provider is registered in the 'entityFramework' section of the application config file

ef-code-first entity-framework-6

Question

I have installed Entity Framework 6.2.0 and working with a code-first approach while creating database and fetch any data getting this error:

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file

I have attached the web.config and app.config.

Web.Config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings>
    <add key="webpages:Version" value="3.0.0.0"/>
    <add key="webpages:Enabled" value="false"/>
    <add key="ClientValidationEnabled" value="true"/>
    <add key="UnobtrusiveJavaScriptEnabled" value="true"/>
  </appSettings>
  <system.web>
    <compilation debug="true" targetFramework="4.6"/>
    <httpRuntime targetFramework="4.6"/>
  </system.web>
  <connectionStrings>
    <add name="GetMeShopContext"
          connectionString="Data Source=localhost;Initial Catalog=GetMeShop;Integrated Security=true" 
    providerName="System.Data.SqlClient"/>
  </connectionStrings>
  <system.webServer>
    <handlers>
      <remove name="ExtensionlessUrlHandler-Integrated-4.0"/>
      <remove name="OPTIONSVerbHandler"/>
      <remove name="TRACEVerbHandler"/>
      <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler"
        preCondition="integratedMode,runtimeVersionv4.0"/>
    </handlers>
  </system.webServer>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" culture="neutral" publicKeyToken="30ad4fe6b2a6aeed"/>
        <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Optimization" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="1.1.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.5.2.14234" newVersion="1.5.2.14234"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-5.2.3.0" newVersion="5.2.3.0"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cs"
        type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        warningLevel="4" compilerOptions="/langversion:6 /nowarn:1659;1699;1701"/>
      <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb"
        type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        warningLevel="4" compilerOptions="/langversion:14 /nowarn:41008 /define:_MYTYPE=\&quot;Web\&quot; /optionInfer+"/>
    </compilers>
  </system.codedom>
</configuration>

App.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="mssqllocaldb" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>
1
0
6/17/2018 12:01:11 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You're saying you have a web.config and an app.config which leads me to believe you probably have a web application, and the Entity Framework code is stored in a class library that this web application references.

This will work just fine - BUT the config from the class library (in the app.config) will not be read and used - you need to physically copy & paste that config (the <configSections> and <entityFramework> sections) from your class library's app.config, and insert those two sections into the web application's web.config so that it will have any effect at all.

This is a basic design decision of the .NET configuration system and holds true for all .NET application - only the main (host) application's config file is read and used - references class library's app.config files are not interpreted and used.

0
6/17/2018 1:19:36 PM

Related Questions

No connection string named 'MyEntities' could be found in the application config file

You are right, this happens because the class library (where the .edmx file) is not your startup / main project....You'll need to copy the connection string to the main project config file....Incase your startup / main project does not have a config file (like it was in my Console Application case) just add one (Startup project - Add New Item -> Ap...
asp.net-mvc-4 c# entity-framework
asked by Oren

a section registered as allowDefinition='MachineToApplication' beyond application level

After adding the assebly of System.Data.Entity to my web config I got this error: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. ...I have deleted the obj and bin folders, I removed the lin...
asp.net directory entity-framework virtual
asked by Kerieks

No connection string named 'MyEntities' could be found in the application config file

You are right, this happens because the class library (where the .edmx file) is not your startup / main project....You'll need to copy the connection string to the main project config file....Incase your startup / main project does not have a config file (like it was in my Console Application case) just add one (Startup project - Add New Item -> Ap...
asp.net-mvc-4 c# entity-framework
asked by Oren

SQLite Error: The 'DbProviderFactories' section can only appear once per config file (IBM Client Access)

I'm using for my application Entity Framework and System.Data.SQLite using WPF and C# on .NET 4.5 On my machine al work well, but on a test machine a received this error when I access to the sqlite db via EntityFramework:...The 'DbProviderFactories' section can only appear once per config file....I found that the error was that in the test machin...
c# entity-framework sqlite wpf
asked by abrfra

No connection string named "NorthwindConnection" could be found in the application config file

I have 2 projects: Console app and dll. In dll i am using EntityFramework. I have this app.config file:...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" t...
c# entity-framework
asked by BJladu4

No connectionstring named '' could be found in the application config file

I know this is asked several times before - and with mostly the same answer. But in these cases the problem often occours when more projects are using same entity and connectionstring not being present in all config files. In my case all is in the same project. And the connection string is present in App.config. I am using a viewmodel in XAML:...<W...
c# entity-framework-6 wpf
asked by Lysgaard

No connection string named could be found in the application config file

I'm using EF and generated .EDMX from it but then I only wanted it to be used for automated generation of Class Files. ...I then used the Class Files to create a Entity Model and then created a DB Context and then Repository. I'm calling a WebApi (which is in a separate project but same solution) to access the repository to GET data. While I run th...
asp.net-web-api c# entity-framework
asked by user1345260

The configuration section 'entityFramework' cannot be read because it is missing a section declaration

I've been working on this project for quite a while. But now it just crashed after I added Identity. The error is as according:...The configuration section 'entityFramework' cannot be read because it is missing a section declaration...It's some IIS error I think, because that's what the page is saying....My web.config file:...<?xml version="1.0" en...
.net asp.net c# entity-framework
asked by Peurr

How to Add/Activate "Oracle.ManagedDataAccess.Client" in the EF 6 provider config file?

I am learning to make ASP.Net MVC Web application using VS2013 following ...these video series.... When I got the following error:...No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'. Make sure the provider is registered in the 'entityFramework' section of the application config ...
asp.net-mvc c# entity-framework odp.net oracle-manageddataaccess
asked by Ian

No connection string named 'x' found in application config file... but it works?

I've seen several different questions relating to this error but none seem to be quite what I'm experiencing. I just followed a simple, one project tutorial on CodeProject.com to get a better understanding of using the MVVM pattern and Entity Framework (...http://www.codeproject.com/Articles/873592/Tutorial-for-a-Basic-WPF-MVVM-Project-Using-Entity...
c# entity-framework-6 mvvm wpf xaml
asked by Gaax

EF6 + NPGSQL - App.Config Settings - Provider with invariant name 'Npqsql' is either not registered etc. etc

Visual Studio 2015 / .NET Framework 4.5...EntityFramework v6.1.3...EntityFramework6.Npgsql v3.1.0...Npgsql 3.2.2...I have inherited a project which contains and EDMX EF6 model which I cannot open in Visual Studio (although the code runs OK) possibly (??) because I am getting the following error: -..."Error 175: The ADO.NET provider with invariant n...
entity-framework-6 npgsql
asked by inthegarden

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow