public static DataSet ExecuteDataset(string connectionString, string spName, params object[] parameterValues)
{
if ((parameterValues != null) && (parameterValues.Length > 0))
{
MySqlParameter[] spParameterset = I3MySqlHelperParameterCache.GetSpParameterset(connectionString, spName);
AssignParameterValues(spParameterset, parameterValues);
return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName, spParameterset));
}
return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName));
}
public static object ExecuteScalar(MySqlTransaction transaction, string spName, params object[] parameterValues)
{
if ((parameterValues != null) && (parameterValues.Length > 0))
{
MySqlParameter[] spParameterset = I3MySqlHelperParameterCache.GetSpParameterset(transaction.Connection.ConnectionString, spName);
AssignParameterValues(spParameterset, parameterValues);
return(ExecuteScalar(transaction, CommandType.StoredProcedure, spName, spParameterset));
}
return(ExecuteScalar(transaction, CommandType.StoredProcedure, spName));
}
