How to correct the error: Schema specified is not valid

1

I modified the DB for my project and did the update of my edmx file, but now when I try to compile the error is appearing:

  

No Entity Framework provider found for the   ADO.NET provider with invariant name 'MySql.Data.MySqlClient'.   Make sure the provider is registered in the 'entityFramework'   section of the application config file.   See link for more information

I do not know how to solve this problem does anyone have any tips?

The webconfig of my project:

<?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" />
        <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    </configSections>
    <system.web>
        <compilation debug="true" targetFramework="4.5" />
        <httpRuntime targetFramework="4.5" />
    </system.web>
    <system.data>
        <DbProviderFactories>
            <remove 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>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>-->
    <connectionStrings>
        <add name="bancotccEntities" connectionString="metadata=res://*/bancotcc.csdl|res://*/bancotcc.ssdl|res://*/bancotcc.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;user id=root;password=tcc2012;persistsecurityinfo=True;database=bancotcc&quot;" providerName="System.Data.EntityClient" />
    </connectionStrings>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <assemblyIdentity name="EntityFramework" publicKeyToken="b77a5c561934e089" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
</configuration>

Thanks for any help.

    
asked by anonymous 31.05.2014 / 23:44

1 answer

1

The <entityFramework> section is wrong. Change to:

<entityFramework>
  <providers>
    <provider invariantName="MySql.Data.MySqlClient"
              type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity" />
  </providers>
</entityFramework>
    
01.06.2014 / 00:21