public static T SqlExecuteGet <T>(string procName, DynamicParameters parms, string outParamName, string connectionName) { using (SqlConnection connection = MsSqlMapperHepler.GetOpenConnection(connectionName)) { var x = connection.Execute(procName, (object)parms, commandType: CommandType.Text, commandTimeout: commandTimeout); return(parms.Get <T>("@" + outParamName)); } }
public static U StoredProcInsertWithID <T, U>(string procName, DynamicParameters parms, string connectionName) { using (SqlConnection connection = MsSqlMapperHepler.GetOpenConnection(connectionName)) { var x = connection.Execute(procName, (object)parms, commandType: CommandType.StoredProcedure, commandTimeout: commandTimeout); return(parms.Get <U>("@ID")); } }