public IDataReader ExecuteReader(CommandType commandType, string commandText) { dbEntity.Command = DBManagerFactory.GetCommand(dbEntity.ProviderType); dbEntity.Command.Connection = dbEntity.Connection; PrepareCommand(dbEntity.Command, dbEntity.Connection, dbEntity.Transaction, commandType, commandText, dbEntity.Parameters); dbEntity.DataReader = dbEntity.Command.ExecuteReader(); dbEntity.Command.Parameters.Clear(); return(dbEntity.DataReader); }
public int ExecuteNonQuery(CommandType commandType, string commandText) { dbEntity.Command = DBManagerFactory.GetCommand(dbEntity.ProviderType); this.PrepareCommand(dbEntity.Command, dbEntity.Connection, dbEntity.Transaction, commandType, commandText, dbEntity.Parameters); int returnValue = dbEntity.Command.ExecuteNonQuery(); dbEntity.Command.Parameters.Clear(); return(returnValue); }
public DataSet ExecuteDataSet(CommandType commandType, string commandText) { dbEntity.Command = DBManagerFactory.GetCommand(dbEntity.ProviderType); this.PrepareCommand(dbEntity.Command, dbEntity.Connection, dbEntity.Transaction, commandType, commandText, dbEntity.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(dbEntity.ProviderType); dataAdapter.SelectCommand = dbEntity.Command; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); dbEntity.Command.Parameters.Clear(); return(dataSet); }