public static T GetSingle <T>(this IConnectionMaster <DbConnection> connMaster, ConnectionMasterParameters param)
{
T item;
using (var con = connMaster.GetOpenConn())
{
item = con.Query <T>(param.SpName, DpsFromParaDic(param.ParamDic) as object, commandType: CommandType.StoredProcedure).FirstOrDefault();
return(item);
}
}
public static IEnumerable <T> GetList <T>(this IConnectionMaster <DbConnection> connMaster, ConnectionMasterParameters param)
{
IEnumerable <T> items;
using (var con = connMaster.GetOpenConn())
{
items = con.Query <T>(param.SpName, DpsFromParaDic(param.ParamDic), commandType: CommandType.StoredProcedure);
return(items);
}
}
public static void ExecuteSP(this IConnectionMaster <DbConnection> connMaster, ConnectionMasterParameters param)
{
using (var conn = connMaster.GetOpenConn())
conn.Execute(param.SpName, DpsFromParaDic(param.ParamDic), commandType: CommandType.StoredProcedure);
}
