예제 #1
0
 public static DataSet ExecuteDataset(string connectionString, string spName, params object[] parameterValues)
 {
     if ((parameterValues != null) && (parameterValues.Length > 0))
     {
         IDbDataParameter[] spParameterset = I3OracleHelperParameterCache.GetSpParameterset(connectionString, spName);
         AssignParameterValues(spParameterset, parameterValues);
         return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName, spParameterset));
     }
     return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName));
 }
예제 #2
0
 public static OracleDataReader ExecuteReader(OracleTransaction transaction, string spName, params object[] parameterValues)
 {
     if ((parameterValues != null) && (parameterValues.Length > 0))
     {
         IDbDataParameter[] spParameterset = I3OracleHelperParameterCache.GetSpParameterset(transaction.Connection.ConnectionString, spName);
         AssignParameterValues(spParameterset, parameterValues);
         return(ExecuteReader(transaction, CommandType.StoredProcedure, spName, spParameterset));
     }
     return(ExecuteReader(transaction, CommandType.StoredProcedure, spName));
 }