具有不变名称"MySql.Data.MySqlClient"的ADO.NET提供程序未在计算机或应用程序配置文件中注册 [英] The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file

问题描述

我有一个使用实体框架6到mysql服务器的asp.net解决方案.

I have an asp.net solution using entity framework 6 to mysql server.

现在我必须在新计算机上研究该解决方案，
但我有一些问题:
1)构建解决方案时出现错误:具有不变名称'MySql.Data.MySqlClient'的ADO.NET提供程序未在计算机或应用程序配置文件中注册".

now I have to work on that solution on a new machine,
but I have some problems:
1) when building the solution I get error: "The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file".

App.config:

App.config:

<entityFramework>
  <providers>
    <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider>
  </providers>
</entityFramework>
<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.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
  </DbProviderFactories>
</system.data>  

2)打开model.edmx文件时，出现消息:
实体模式设计器无法显示您请求的文件".

2) when opening model.edmx file I get message:
"the entity mode designer is unable to display the file you requested".

我已在计算机上安装:

1)mysql连接器/网络6.9.9
2)适用于Visual Studio 1.2.6的mysql
3)mysql连接器odbc 5.3.6.

1) mysql connector/net 6.9.9
2) mysql for visual studio 1.2.6
3) mysql connector odbc 5.3.6.

我该怎么办?

推荐答案

我遵循了互联网上大多数建议的解决方案，但对不起，所有解决方案都失败了.发生问题是因为Visual Studio缺少MySql连接器，而我已经通过安装mysql-connector-net-7.0.4( https://downloads.mysql.com/archives/c-net/)

I followed most suggested solutions in the internet but for sorry all were failed. The problem occurs because visual studio lacks for MySql connector and I have solved it by installing mysql-connector-net-7.0.4 (https://downloads.mysql.com/archives/c-net/)

这篇关于具有不变名称"MySql.Data.MySqlClient"的ADO.NET提供程序未在计算机或应用程序配置文件中注册的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！