public DataTable ExecuteDataTable(CommandType commandType, string commandText) { try { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter (this.ProviderType); dataAdapter.SelectCommand = idbCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); idbCommand.Parameters.Clear(); if (dataSet.Tables.Count > 0) { return(dataSet.Tables[0]); } return(null); } catch (Exception) { throw; } }
public object ExecuteScalar(CommandType commandType, string commandText) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); object returnValue = idbCommand.ExecuteScalar(); idbCommand.Parameters.Clear(); return(returnValue); }
public void BeginTransaction() { if (this.idbTransaction == null) { idbTransaction = DBManagerFactory.GetTransaction(this.ProviderType, idbConnection); } this.idbCommand.Transaction = idbTransaction; }
private IDbDataAdapter CreateCommandAndDataAdapter() { //Command and Adapter creation this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter (this.ProviderType); return(dataAdapter); }
public IDataReader ExecuteReader(CommandType commandType, string commandText) { 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 AddParameters(string paramName, object objValue) { IDbDataParameter param = DBManagerFactory.GetParameter(this.providerType); param.ParameterName = paramName; param.Value = objValue; param.Direction = ParameterDirection.Input; idbParameters.Add(param); }
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 void AddParameters(string paramName, ParameterDirection direction, DbType type, object objValue = null) { IDbDataParameter param = DBManagerFactory.GetParameter(this.providerType); param.ParameterName = paramName; param.Value = objValue; param.Direction = direction; param.DbType = type; idbParameters.Add(param); }
public DataSet ExecuteDataSet(CommandType commandType, string commandText) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(this.ProviderType); dataAdapter.SelectCommand = idbCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); idbCommand.Parameters.Clear(); return(dataSet); }
public IDataReader ExecuteReader(CommandType commandType, string commandText) { if (this.Connection == null) { Open(); } this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); idbCommand.Connection = this.Connection; PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); this.DataReader = idbCommand.ExecuteReader(); // TODO: only clear out parameters if none of the parameters are of type output //idbCommand.Parameters.Clear(); return(this.DataReader); }
public object ExecuteScalar(CommandType commandType, string commandText) { if (this.Connection == null) { Open(); } this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); object returnValue = idbCommand.ExecuteScalar(); // TODO: only clear out parameters if none of the parameters are of type output // idbCommand.Parameters.Clear(); return(returnValue); }
public int ExecuteNonQuery(CommandType commandType, string commandText) { try { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); int returnValue = idbCommand.ExecuteNonQuery(); idbCommand.Parameters.Clear(); return(returnValue); } catch (Exception) { throw; } }
public DataSet ExecuteDataSet(CommandType commandType, string commandText) { if (this.Connection == null) { Open(); } this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); this.idbCommand.CommandTimeout = 0; PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(this.ProviderType); dataAdapter.SelectCommand = idbCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); // TODO: only clear out parameters if none of the parameters are of type output // idbCommand.Parameters.Clear(); return(dataSet); }
public DataSet SetDataSetForUpdate(CommandType commandType, string commandText) { try { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter (this.ProviderType); dataAdapter.SelectCommand = idbCommand; UpdateDataSet = new DataSet(); dataAdapter.Fill(UpdateDataSet); idbCommand.Parameters.Clear(); return(UpdateDataSet); } catch (Exception) { throw; } }
public void CreateParameters(int paramsCount) { idbParameters = new IDbDataParameter[paramsCount]; idbParameters = DBManagerFactory.GetParameters(this.ProviderType, paramsCount); }
private void GetTheCommandBuilder(IDbDataAdapter dataAdapter) { this.iDbCommandBuilder = DBManagerFactory.GetCommandBuilder(this.providerType, dataAdapter); }