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); }