public static object ExecuteScalar(OracleConnection connection, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, connection, null, commandType, commandText, commandParameters);
object retval = cmd.ExecuteScalar();
cmd.Parameters.Clear();
return(retval);
}
public static XmlReader ExecuteXmlReader(OracleTransaction transaction, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);
XmlReader retval = cmd.ExecuteXmlReader();
cmd.Parameters.Clear();
return(retval);
}
public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(connectionString, spName);
OracleDataAccess.AssignParameterValues(commandParameters, parameterValues);
return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, commandParameters));
}
return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName));
}
public static XmlReader ExecuteXmlReader(OracleTransaction transaction, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
OracleDataAccess.AssignParameterValues(commandParameters, parameterValues);
return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, commandParameters));
}
return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName));
}
public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
object result;
using (OracleConnection cn = new OracleConnection(connectionString))
{
cn.Open();
result = OracleDataAccess.ExecuteScalar(cn, commandType, commandText, commandParameters);
}
return(result);
}
public static int ExecuteNonQueryBulk(OracleConnection connection, CommandType commandType, string commandText, int numRecords, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, connection, null, commandType, commandText, commandParameters);
cmd.ArrayBindCount = numRecords;
int retval = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return(retval);
}
public static int ExecuteNonQueryBulk(string connectionString, CommandType commandType, string commandText, int numRecords, params OracleParameter[] commandParameters)
{
int result;
using (OracleConnection cn = new OracleConnection(connectionString))
{
cn.Open();
result = OracleDataAccess.ExecuteNonQueryBulk(cn, commandType, commandText, numRecords, commandParameters);
}
return(result);
}
public static DataSet ExecuteDataset(OracleTransaction transaction, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.Parameters.Clear();
return(ds);
}
public static DataSet ExecuteDatasetPage(OracleTransaction transaction, CommandType commandType, string commandText, string tableName, int pageIndex, int pageSize)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, null);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, pageIndex, pageSize, tableName);
cmd.Parameters.Clear();
return(ds);
}
private static void PrepareCommand(OracleCommand command, OracleConnection connection, OracleTransaction transaction, CommandType commandType, string commandText, OracleParameter[] commandParameters)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
command.CommandType = commandType;
if (commandParameters != null)
{
OracleDataAccess.AttachParameters(command, commandParameters);
}
}
private static OracleDataReader ExecuteReader(OracleConnection connection, OracleTransaction transaction, CommandType commandType, string commandText, OracleParameter[] commandParameters, OracleDataAccess.OracleConnectionOwnership connectionOwnership)
{
OracleCommand cmd = new OracleCommand();
OracleDataAccess.PrepareCommand(cmd, connection, transaction, commandType, commandText, commandParameters);
OracleDataReader dr;
if (connectionOwnership == OracleDataAccess.OracleConnectionOwnership.External)
{
dr = cmd.ExecuteReader();
}
else
{
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
cmd.Parameters.Clear();
return(dr);
}
public static OracleDataReader ExecuteReader(string connectionString, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleConnection cn = new OracleConnection(connectionString);
cn.Open();
OracleDataReader result;
try
{
result = OracleDataAccess.ExecuteReader(cn, null, commandType, commandText, commandParameters, OracleDataAccess.OracleConnectionOwnership.Internal);
}
catch
{
cn.Close();
throw;
}
return(result);
}
public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteNonQuery(connectionString, commandType, commandText, null));
}
public static DataSet ExecuteDataset(OracleConnection connection, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteDataset(connection, commandType, commandText, null));
}
public static DataSet ExecuteDataset(OracleTransaction transaction, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteDataset(transaction, commandType, commandText, null));
}
public static XmlReader ExecuteXmlReader(OracleTransaction transaction, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteXmlReader(transaction, commandType, commandText, null));
}
public static object ExecuteScalar(OracleTransaction transaction, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteScalar(transaction, commandType, commandText, null));
}
public static int ExecuteNonQuery(OracleTransaction transaction, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteNonQuery(transaction, commandType, commandText, null));
}
public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteScalar(connectionString, commandType, commandText, null));
}
public static OracleDataReader ExecuteReader(OracleTransaction transaction, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
return(OracleDataAccess.ExecuteReader(transaction.Connection, transaction, commandType, commandText, commandParameters, OracleDataAccess.OracleConnectionOwnership.External));
}
public static OracleDataReader ExecuteReader(OracleConnection connection, CommandType commandType, string commandText)
{
return(OracleDataAccess.ExecuteReader(connection, commandType, commandText, null));
}
