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

添加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();
}

发布

新建配置文件

ok

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

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

标签：