当存储在App.config中一个MySQL连接字符串，什么样的价值应该ProviderName属性设置为？

例如在下面的App.config文件，我应该使用的的providerName什么价值？有没有关系呢？

 ＆LT; XML版本=1.0编码=UTF-8＆GT？;
＆lt;结构＆GT;
  ＆LT;的ConnectionStrings＆GT;
    ＆LT;添加名称=MySQL的的connectionString =SERVER = 8.8.8.8; DATABASE = foo的; UID =酒吧; PASSWORD = foobar的的providerName =WhatGoesHere？ /＆GT;
  ＆LT; /的ConnectionStrings＆GT;
＆LT; /结构＆gt;
 

解决方案

试试这个：

 ＆LT;的ConnectionStrings＆GT;
＆LT;添加名称=MySQL的的connectionString =SERVER = 8.8.8.8; DATABASE = foo的; UID =酒吧; PASSWORD = foobar的的providerName =MySql.Data.MySqlClient/＆GT;
＆LT; /的ConnectionStrings＆GT;
 

When storing a MySQL connection string in App.config, what value should the providerName property be set to?

For example in the below App.config file, what value should I use for the providerName? Does it matter?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="MySQL" connectionString="SERVER=8.8.8.8; DATABASE=foo; UID=bar; PASSWORD=foobar" providerName="WhatGoesHere?" />
  </connectionStrings>
</configuration>

Try this:

<connectionStrings>
<add name="MySQL" connectionString="SERVER=8.8.8.8; DATABASE=foo; UID=bar; PASSWORD=foobar" providerName="MySql.Data.MySqlClient" />
</connectionStrings>