首先我想说明一下:相比最原始的ADO.NET,一般都认为封装过一层的ORM性能上会有损耗,但其实在使用中你会发现,当你需要把数据库对象转化为实体模型时,很多所谓的DbHelper其实封装的很低效,反而是成熟的orm框架性能非常高;
在操作之前先在nuget里获取dapper和mysql.data的程序包:
插入数据:
///
///增加一条数据///
public boolAdd(User model)
{int cnt = 0;string sQuery = "INSERT INTO user (Id,Login_Name,User_Pwd,User_Name,Phone_Num,Head_Portrait,Enabled,Create_Time,Update_Time)"
+ "VALUES(@Id,@Login_Name,@User_Pwd,@User_Name,@Phone_Num,@Head_Portrait,@Enabled,@Create_Time,@Update_Time)";using (var connection = newMySqlConnection(connstr))
{
cnt=connection.Execute(sQuery, model);
}if (cnt > 0)
{return true;
}else{return false;
}
}
删除数据
///
///根据ID删除一条数据///
public bool Delete(intid)
{int cnt = 0;string sQuery = "Delete FROM user" + "WHERE Id=@Id";using (var connection = newMySqlConnection(connstr))
{
cnt= connection.Execute(sQuery, new { Id =id });
}if (cnt > 0)
{return true;
}else{return false;
}
}
修改数据
///
///更新一条数据///
public boolUpdate(User model)
{string sQuery = "UPDATE user SET Login_Name=@Login_Name,User_Pwd=@User_Pwd,User_Name=@User_Name,Phone_Num=@Phone_Num,Head_Portrait=@Head_Portrait,Enabled=@Enabled,Create_Time=@Create_Time,Update_Time=@Update_Time"
+ "WHERE Id=@Id";int cnt = 0;using (var connection = newMySqlConnection(connstr))
{
cnt=connection.Execute(sQuery, model);
}if (cnt > 0)
{return true;
}else{return false;
}
}
查询数据
///
///根据ID获取实体对象///
public User GetModel(intid)
{string sQuery = "SELECT Id,Login_Name,User_Pwd,User_Name,Phone_Num,Head_Portrait,Enabled,Create_Time,Update_Time FROM user" + "WHERE Id = @Id";using (var connection = newMySqlConnection(connstr))
{return connection.Query(sQuery, new { Id =id }).FirstOrDefault();
}
}
调用分页存储过程
///
///分页获取数据列表///
public IEnumerable GetListByPage(int PageSize, int PageIndex, string strWhere, string orderStr, ref introwsnum)
{using (var connection = newMySqlConnection(connstr))
{var param = newDynamicParameters();
param.Add("@p_table_name", "user");
param.Add("@p_fields", "Id,Login_Name,User_Pwd,User_Name,Phone_Num,Head_Portrait,Enabled,Create_Time,Update_Time");
param.Add("@p_page_size", PageSize);
param.Add("@p_page_now", PageIndex);
param.Add("@p_where_string", strWhere);
param.Add("@p_order_string", orderStr);
param.Add("@p_out_rows", 0, DbType.Int32, ParameterDirection.Output);
IEnumerable infoList = connection.Query("pr_pager", param, null, true, null, CommandType.StoredProcedure);
rowsnum = param.Get("@p_out_rows");returninfoList;
}
在不进行任何代码特殊优化的测试中,同过Emit反射IDataReader的序列队列,来快速的得到和产生对象的dapper性能是很不错的。