vs2013 C# webapi Mysql新手，求各位大神指导

最近喜欢喜欢上了webapi模板。ajax请求数据，webap输出json，angular将数据绑定DOM，简单明了，简直是小前端的福音。实在忍不住，装上vs，连上数据库，成功输出数据。

visual studio2013 新建webapi

解决方案，右键管理NuGet程序包，MySql.Data MySql.Data.Entity

然后配置文件（web.config）添加链接字符串。

<connectionStrings>
<!--<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20150910132908;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20150910132908.mdf" />-->
<add name="MySQLConnString" connectionString="Server=localhost;Port=3306;Database=products;Uid=root;Pwd=" providerName="MySql.Data.MySqlClient" />
</connectionStrings>

添加MySql辅助类，mysqlHelper

name和下文的System.Configuration.ConfigurationManager.AppSettings相同

/This connectionString for the local test
public static readonly string connectionStringManager = System.Configuration.ConfigurationManager.AppSettings["MySQLConnString"];
//ConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;

//hashtable to store the parameter information, the hash table can store any type of argument
//Here the hashtable is static types of static variables, since it is static, that is a definition of global use.
//All parameters are using this hash table, how to ensure that others in the change does not affect their time to read it
//Before ,the method can use the lock method to lock the table, does not allow others to modify.when it has readed then unlocked table.
//Now .NET provides a HashTable's Synchronized methods to achieve the same function, no need to manually lock, completed directly by the system framework
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

已经可以使用mysql

var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();

using (MySqlConnection conn = new MySqlConnection(strConn))
{
conn.Open();
}

感谢海洋教我。

执行select语句

var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();

using (MySqlConnection conn = new MySqlConnection(strConn))
{
conn.Open();
MySqlCommand mycmd = new MySqlCommand("insert into product(name,price) values('小王','11')", conn);
MySqlCommand objCmd = new MySqlCommand("select * from `product` ", conn);
MySqlDataReader r = objCmd.ExecuteReader();
int i = 0;
while (r.Read())
{
try
{
products[i].Id = r.GetInt32(0);
products[i].Name = r.GetString(2);
products[i].Price = r.GetInt32(1);
i++;
}
catch
{

}

}
conn.Close();
}

发布

新建配置文件

引用请注明http://www.cumt.top/blog/?p=107