/// <summary>
/// 获取TopicModel
/// </summary>
/// <param name="topicGuid">topicGuid</param>
/// <returns></returns>
private TopicModel GetTopicModel(string topicGuid)
{
string sqlstring = "select * from t_utility_topic where topic_guid=@topic_guid";
DynamicParameters parameters = new DynamicParameters();
parameters.Add("topic_guid", topicGuid, System.Data.DbType.String);
using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection())
{
return(conn.QueryFirst <TopicModel>(sqlstring, parameters));
}
}
public void Test()
{
string connString = "";
using (var conn = new MySql.Data.MySqlClient.MySqlConnection("server=192.168.255.128;User Id=root;password=root;Database=testdb"))
{
conn.Open();
string sql = "select count(1) from tb_user";
int count = conn.QueryFirst <int>(sql);
}
Console.WriteLine("Hello World!");
}