使用DbProviderFactories.GetFactory()创建数据连接ySqlClientFactory的时候报错:
Unable to find the requested .Net Framework Data Provider. It may not be installed.
创建代码:
DbProviderFactory _factory
=
DbProviderFactories.GetFactory(“MySql.Data.MySqlClient”);
解决方案:
web.configs配置
代码
<
system.data
>
< DbProviderFactories >
< add name ="MySQL Data Provider" invariant ="MySql.Data.MySqlClient" description =".Net Framework Data Provider for MySQL" type ="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</ DbProviderFactories >
</ system.data >
...
< pages >
< namespaces >
< add namespace ="MySql.Data" />
< add namespace ="MySql.Data.MySqlClient" />
</ namespaces >
</ pages >
< compilation debug ="true" >
< assemblies >
< add assembly ="MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D" />
</ assemblies >
</ compilation >
...
</ system.web >
< DbProviderFactories >
< add name ="MySQL Data Provider" invariant ="MySql.Data.MySqlClient" description =".Net Framework Data Provider for MySQL" type ="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</ DbProviderFactories >
</ system.data >
...
< pages >
< namespaces >
< add namespace ="MySql.Data" />
< add namespace ="MySql.Data.MySqlClient" />
</ namespaces >
</ pages >
< compilation debug ="true" >
< assemblies >
< add assembly ="MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D" />
</ assemblies >
</ compilation >
...
</ system.web >
成功解决问题。