Test proejct test will not execute: unrecognized configuration section entityFramework

asp.net c# entity-framework

Question

When I try to run my test I get the following error in my app.config for my test project:

Result Message: 
Test method MYTESTPROJ.Repositories.MYREPO.MY_TEST threw exception: 
System.TypeInitializationException: The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception. ---> 
System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> 
System.Configuration.ConfigurationErrorsException: Unrecognized configuration section entityFramework. 
(C:\Dev\trunk\MYTESTPROJ\bin\Debug\MYTESTPROJ.dll.config line 20)
Result StackTrace:  
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
   at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()
   at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
 --- End of inner exception stack trace ---
    at System.Configuration.ConfigurationManager.PrepareConfigSystem()
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at System.Configuration.ConfigurationManager.get_ConnectionStrings()
   at System.Data.Entity.Internal.AppConfig..ctor()
   at System.Data.Entity.Internal.AppConfig..cctor()
 --- End of inner exception stack trace ---
    at System.Data.Entity.Internal.AppConfig.get_DefaultInstance()
   at System.Data.Entity.Internal.LazyInternalConnection..ctor(DbContext context, String nameOrConnectionString)
   at System.Data.Entity.DbContext..ctor(String nameOrConnectionString)

Here is my app.config:

    <?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="xxxConnection" connectionString="xxx" providerName="System.Data.EntityClient" />
  </connectionStrings>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
<system.data>
    <DbProviderFactories>
      <remove name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
</system.data>
<entityFramework>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider>
    </providers>
  </entityFramework>
</configuration>
1
27
4/10/2014 4:59:05 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You just need to add the configSections area at the top to register the section (you might need to change the EF version).

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="xxxConnection" connectionString="xxx" providerName="System.Data.EntityClient" />
  </connectionStrings>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
<system.data>
    <DbProviderFactories>
      <remove name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
</system.data>
<entityFramework>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider>
    </providers>
  </entityFramework>
</configuration>
63
4/10/2014 1:54:19 PM

Popular Answer

Had the same error, but thought I had the configSections declaration... I had mistakenly placed it in a sectionGroup instead of in the configSection.

Wrong:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <section name="quartz" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
        <sectionGroup name="common">
            <section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
      <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
        </sectionGroup>
    </configSections>...

Correct:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <section name="quartz" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
        <sectionGroup name="common">
            <section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
        </sectionGroup>
        <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    </configSections>
jaybro

Related Questions

How should I set up my integration tests to use a test database with Entity Framework?

Just setup a connection string in the app.config of your unit test project that points to the new DB instance....You can then use the initialisation and cleanup methods in your test class to create and delete the DB....The connection string is just the usual, e.g....<add name="UnitTestDBConnection" connectionString="Data Source=(local);Initial Cata...
asp.net-mvc c# ef-code-first entity-framework integration-testing
asked by Justin Harvey

EntityFramework,The specified store provider cannot be found in the configuration, or is not valid

I had this problem. I uninstalled Connector .NET and reinstalled it. Now it works.
c# entity-framework exception
asked by H2ONaCl

Can't add a reference to EntityFramework in my unit test project

Remove all the entries you have made to the web.config file. Just Right Click on your project name in the solution, Click on Manage Nuget Packages On your left hand Click on Online and on the right hand just put Entity Framework in the search box. Click on Install...this will do all the things automatically for you....Answer is taken from: ...Entit...
entity-framework visual-studio
asked by Dima Condur

This operation is not supported in wcf test client because it uses system.threading.tasks.task

Why are you making your service async? Async methods are created on the client side with the service reference. When you add a service reference to your service, mark the service reference as allow generation of asynchronous operations. With VS 2013 and .NET 4.5 you can either make task-based operations or asynchronous operations....Then your cl...
.net c# entity-framework multithreading wcf
asked by Blaine

Entity Framework Integration tests failing running multiple tests that are singularly passing [Resharper, NUnit, EF6]

I found the solution, that (after all) is pretty obvious. Below you can see the final solution....The key is the ...Database.SetInitializer... that configure EF to initialize the database using the registered ...IDatabaseInitializers.......EF6 allow you to use ...Context.Database.Initialize(true);... that forces the database to run all the initiali...
c# entity-framework-6 integration-testing nunit resharper
asked by Norcino

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

You are missing a section as the error says:...<?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" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, Entit...
.net asp.net c# entity-framework
asked by ErikEJ

Unit Test with Moq - Value can not be null

That is because test sets up ....Setup(c => c.Books)... in the data context but in actual code accesses ...Context.Set<TObject>()... in the ...GetAll()... method, so for test it will end up as being ...null.......try changing to ...mockContext.Setup(c => c.Set<Book>()).Returns(mockSet.Object);
c# entity-framework entity-framework-6 moq unit-testing
asked by Nkosi

EntityFramework, DbContextScope and Effort - exception: DbContext has been disposed inside unit test

For anyone who comes across a similar issue, I've created a bit dirty-but-working solution (at least I hope so). In addition to what I wrote in the question, I created a class derived from real context and made ...Dispose... method do... nothing. I also added a ...RealDispose... method which is called at the end of each test.... public class Tes...
c# dbcontext effort entity-framework unit-testing
asked by PJDev

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

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 ...
ef-code-first entity-framework-6
asked by marc_s

Making tests faster by using only partial database in EntityFramework Effort

Disclaimer...: I'm the owner of the project ...Entity Framework Effort...Our library has a feature that allows creating a restore point and rollbacking to it....So by using this trick, you could use the ...CreateRestorePoint()... only once when all tables are created and then for every test, start them with ...RollbackToRestorePoint.... (There is s...
effort entity-framework entity-framework-6 unit-testing
asked by Jonathan Magnan

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