ConfigurationErrorException in trying to run console app with MySQL Entity Framework 6

.net c# entity-framework mysql visual-studio-2013

Question

I am trying to learn how to use Entity Framework 6 with MySQL. Since I already have an existing database, I am following the Model First approach. However, I am always faced with this error message that is vaguely helpful.

The error triggers in this line of code in Program.cs:

List<Student> students = dbContext.Students.ToList();

The error message just says:

An unhandled exception of type 'System.Configuration.ConfigurationErrorsException' occurred in System.Configuration.dll Additional information: Unrecognized attribute 'name'.

My first assumption is that there is something wrong with my App.config file. However, I don't know which name attribute in the App.config file it was talking about. I tried searching for existing answers or possible solutions to no avail so I decided to post my problem hoping for you guys to help me.

What I am using:

  • Visual Studio 2013 (Installed in my PC)
  • MySQL Server 5.6 (Installed in my PC)
  • Entity Framework 6.1.1 (Installed in my project through NuGet Package Manager)
  • MySql.ConnectorNET.Data 6.8.3.2 (Installed in my project through NuGet Package Manager)
  • MySql.ConnectorNet.Entity 6.8.3.2 (Installed in my project through NuGet Package Manager)

What steps I did:

  1. Created a new console app
  2. Installed Entity Framework, MySql.ConnectorNET.Data, and MySql.ConnectorNet.Entity into the project through NuGet Package Manager
  3. Added an ADO.Net Entity Data Model named DSWS_Model using my existing database
  4. Entered some simple code that iterates and prints the list of students into the console
  5. RUN
  6. Then stupid runtime error shows up

Program.cs

namespace MySQLEntityFramework6
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Start?");
            Console.ReadLine();
            try
            {
                using (dswsEntities dbContext = new dswsEntities())
                {
                    List<Student> students = dbContext.Students.ToList();
                    foreach (Student student in students)
                    {
                        Console.WriteLine(student.name);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionUtility.LogException(ex);
            }
            Console.ReadLine();
        }
    }
}

DSWS_Model.Context.cs

namespace MySQLEntityFramework6
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;

    public partial class dswsEntities : DbContext
    {
        public dswsEntities()
            : base("name=dswsEntities")
        {
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }

        public virtual DbSet<Administrator> Administrators { get; set; }
        public virtual DbSet<BuildingSetting> BuildingSettings { get; set; }
        public virtual DbSet<Evaluation> Evaluations { get; set; }
        public virtual DbSet<LockerReservation> LockerReservations { get; set; }
        public virtual DbSet<Locker> Lockers { get; set; }
        public virtual DbSet<LoginQueue> LoginQueues { get; set; }
        public virtual DbSet<Student> Students { get; set; }
    }
}

App.config

<?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, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
  <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" />
      <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>
  <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>
  <connectionStrings>
    <add name="dswsEntities" connectionString="metadata=res://*/DSWS_Model.csdl|res://*/DSWS_Model.ssdl|res://*/DSWS_Model.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;user id=root;password=root;persistsecurityinfo=True;database=dsws&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
</configuration>

Error Log

    Exception Type: System.Configuration.ConfigurationErrorsException
Exception: Unrecognized attribute 'name'. (C:\Users\Nico\Documents\Visual Studio 2013\Projects\MVA\Entity Framework\MySQLEntityFramework6\MySQLEntityFramework6\bin\Debug\MySQLEntityFramework6.vshost.exe.Config line 23)
Source: System.Configuration
Stack Trace: 
   at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
   at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
   at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
   at System.Data.Common.DbProviderFactories.Initialize()
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.GetService(Type type, Object key, Func`3 handleFailedLookup)
   at System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.CachingDependencyResolver.<>c__DisplayClass1.<GetService>b__0(Tuple`2 k)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.Data.Entity.Infrastructure.DependencyResolution.CachingDependencyResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.<>c__DisplayClass3.<GetService>b__0(IDbDependencyResolver r)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.RootDependencyResolver.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.<>c__DisplayClass3.<GetService>b__0(IDbDependencyResolver r)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Infrastructure.DependencyResolution.ResolverChain.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver`2.GetService(Type type, Object key)
   at System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key)
   at System.Data.Entity.Core.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
   at System.Data.Entity.Core.EntityClient.EntityConnection..ctor(String connectionString)
   at System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionStringSetting(ConnectionStringSettings appConfigConnection)
   at System.Data.Entity.Internal.LazyInternalConnection.TryInitializeFromAppConfig(String name, AppConfig config)
   at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
   at System.Data.Entity.Internal.LazyInternalConnection.CreateObjectContextFromConnectionModel()
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.Initialize()
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator()
   at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at MySQLEntityFramework6.Program.Main(String[] args) in c:\Users\Nico\Documents\Visual Studio 2013\Projects\MVA\Entity Framework\MySQLEntityFramework6\MySQLEntityFramework6\Program.cs:line 19
Target Site: System.Object EvaluateOne(System.String[], System.Configuration.SectionInput, Boolean, System.Configuration.FactoryRecord, System.Configuration.SectionRecord, System.Object)

Thank you in advance for those who will reply.

1
3
7/6/2014 6:29:41 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

From your stack trace it would appear that it's complaining about the 'name' attribute on one of the DbProviderFactory elements in your configuration file. You don't need to specify name on the remove element, just invariant. Try removing it and things should start working!

5
7/6/2014 6:31:17 PM

Related Questions

Entity Framework 5 Nuget Console commands

So I am making a DB with EF 5 Code first, I have checked some guides and found some "important"/useful commands like: "Update-Database -Force -Verbose". However I know there must be more commands like these, something like: "Purge-Database", but no success in finding them. So my question is, where can I find all the availible commands and flags(for...
command-line ef-migrations entity-framework nuget
asked by Maximc

How to add entity-framework to console application (images are included)

I try to add entity-framework to console application: I press "add new item" and ...then ...then...then I added code:... class Program { static void Main(string[] args) { try { Database1Entities db = new Database1Entities(); db.AddToTableTest(new TableTest { name = "na...
asp.net c# database entity-framework objectcontext
asked by Paul T.

I get Error when i run enable-migrations in package manager console

The error message exactly states what the problem is and what needs to be done - including the command that needs to be issued. Apparently there is more than one context in your project (Web.Infrastructure.DepartmentDb and Web.Models.UsersContext) and migrations does not know for which of these migrations should be enabled. You need to point to the...
asp.net-mvc entity-framework
asked by Pawel

InnerException in Entity Framework when I try add an entity

It doesn't mean that you are doing an Update, that just means a SQL error occurred. You need to read the inner exception to find out what the actual error is. From the looks of it, it may be something related to a primary key, or foreign key constraint, ie. you are adding an item and that primary key is already in the table. But again, the actual e...
c# entity-framework entity-relationship visual-studio-2010
asked by Despertar

Enable-Migrations error when trying to run the command

I am trying to run the command Enable-Migrations in the NuGet console but I keep getting the following error... PM> enable-migrations System.ArgumentException: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) Server stack trace: at EnvDTE.Properties.Item(Object index) at System.Runtime.Remoting.Messaging.St...
entity-framework-6 nuget
asked by user1514213

Entity Framework's Entity Data Wizard Crashes When Connecting to MySQL Database

It is caused by version mismatch....On my system, I had MySQL Connector 6.9.6. Issuing the command in NuGet Package Manger Console:...Install-Package MySql.Data.Entity installs version 6.9.8 by default. Your connector must match the actual version of the NuGet Package. You can download an updated version of the connector from: ...https://www.mysql....
c# entity-framework-6 mysql visual-studio-2015
asked by Lars Meldgård

Entity Framework 6 MySQL - performance difference vs MySQL engine

So there's a few posts around complaining about the performance of the MySQL plugin for Entity Framework 6. Most of these, however, seem to come down to it generating bad SQL. I'm suffering with this issue but it seems to be due to a performance lag due to the plugin itself....Here's my query in LINQ:...List<Address> matches = _rep.GetAddresses(s =...
c# entity-framework entity-framework-6 linq mysql
asked by Bob Tway

MySQL version 7.0.6-IR3 issue when try to connect to db

I got below error when i try to connect to MySQL db....Inheritance security rules violated by type: 'MySql.Data.MySqlClient.MySqlProviderServices'. Derived types must either match the security accessibility of the base type or be less accessible....Below is the entityframework config:... <entityFramework codeConfigurationType="MySql.Data.Enti...
entity-framework-6 mysql
asked by eikaz

Exception when trying to migrate database in Entity Framework v6.2.0 in Visual Studio v15.8.4

It sometimes work to just clean and rebuild your solution
c# database-migration ef-migrations entity-framework entity-framework-6
asked by simon desmet

Exception when trying to use Mysql.Data.Entity

I'm trying to get a test project running using MySQL and EF6 using Visual Studio 2019 Community Preview for Mac. I am using the ...Web Application (Model-View-Controller)... / ....NET Core -> App... template as a starting point as well as the ...MyWind... database. I'm getting the following exception and am not sure how to proceed....TypeLoadExcept...
connector-net entity-framework-6 mono mysql xamarin
asked by Don 01001100

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