alinq mysql_ALinq 让Mysql变得如此简单

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingMySql.Data.MySqlClient;namespaceCimDataImport

{publicclassTestCharacter

{publicconststringmysqlConnection="User Id=root;Host=localhost;Database=cim;password=root";//添加数据//publicintAdd(UserBase entity)

{stringsql="INSERT INTO cimuser (userid,userNickName) VALUE (@userid,@userNickName)";using(MySqlConnection mycn=newMySqlConnection(mysqlConnection))

{

mycn.Open();

MySqlCommand command=newMySqlCommand(sql, mycn);

command.Parameters.AddWithValue("@userid", entity.UserId);

command.Parameters.AddWithValue("@userNickName",entity.UserNickName);returncommand.ExecuteNonQuery();

}

}//修改数据/publicintUpdate(UserBase entity)

{stringsql="UPDATE cimuser SET userNickName=@userNickName WHERE userid=@userid";using(MySqlConnection mycn=newMySqlConnection(mysqlConnection))

{

mycn.Open();

MySqlCommand command=newMySqlCommand(sql, mycn);

command.Parameters.AddWithValue("@userid", entity.UserId);

command.Parameters.AddWithValue("@userNickName", entity.UserNickName);returncommand.ExecuteNonQuery();

}

}//删除数据/publicintDelete(intprimaryKey)

{stringsql="DELETE FROM cimuser WHERE userid=@userid";using(MySqlConnection mycn=newMySqlConnection(mysqlConnection))

{

mycn.Open();

MySqlCommand command=newMySqlCommand(sql, mycn);

command.Parameters.AddWithValue("@userid", primaryKey);returncommand.ExecuteNonQuery();

}

}//根据主键查询/publicUserBase Get(intprimaryKey)

{stringsql="SELECT userid,userNickName FROM cimuser where userid=@userid";using(MySqlConnection mycn=newMySqlConnection(mysqlConnection))

{

mycn.Open();

MySqlCommand command=newMySqlCommand(sql, mycn);

command.Parameters.AddWithValue("@userid", primaryKey);

MySqlDataReader reader=command.ExecuteReader();

UserBase userBase=null;if(reader.Read())

{

userBase=newUserBase();

userBase.UserId=Convert.ToInt32(reader["userid"]);

userBase.UserNickName=reader["userNickName"]==DBNull.Value?null: reader["userNickName"].ToString();

}returnuserBase;

}

}//查询集合//publicIListGetList()

{stringsql="SELECT userid,userNickName FROM cimuser limit 1,10";using(MySqlConnection mycn=newMySqlConnection(mysqlConnection))

{

mycn.Open();

MySqlCommand command=newMySqlCommand(sql, mycn);

MySqlDataReader reader=command.ExecuteReader();

IListlist=newList();

UserBase userBase=null;while(reader.Read())

{

userBase=newUserBase();

userBase.UserId=Convert.ToInt32(reader["userid"]);

userBase.UserNickName=reader["userNickName"]==DBNull.Value?null: reader["userNickName"].ToString();

list.Add(userBase);

}returnlist;

}

}

}