public object ExecuteScalar(CommandType commandType, string commandText, int?requestTimeout = null) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); object returnObject = idbCommand.ExecuteScalar(); return(returnObject); }
public void BeginTransaction() { if (this.idbTransaction == null) { idbTransaction = DBManagerFactory.GetTransaction(this.ProviderType); } this.idbCommand.Transaction = idbTransaction; }
public int ExecuteNonQuery(CommandType commandType, string commandText, int?requestTimeout = null) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters, requestTimeout); int returnValue = idbCommand.ExecuteNonQuery(); idbCommand.Parameters.Clear(); return(returnValue); }
public IDataReader ExecuteReader(CommandType commandType, string commandText, int?requestTimeout = null) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); idbCommand.Connection = this.Connection; PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); this.DataReader = idbCommand.ExecuteReader(); idbCommand.Parameters.Clear(); return(this.DataReader); }
public void Open() { idbConnection = DBManagerFactory.GetConnection(this.providerType); idbConnection.ConnectionString = this.ConnectionString; if (idbConnection.State != ConnectionState.Open) { idbConnection.Open(); } this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); }
public DataSet ExecuteDataset(CommandType commandType, string commandText, int?requestTimeout = null) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters, requestTimeout); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(this.ProviderType); dataAdapter.SelectCommand = idbCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); return(dataSet); }
public void CreateParameters(int paramsCount) { idbParameters = new IDbDataParameter[paramsCount]; idbParameters = DBManagerFactory.GetParameter(this.ProviderType, paramsCount); }