public SWPTransactionDBConnection(string connectionName) { _database = SWPDBHelper.DBFromConnectionName(connectionName); _connection = _database.CreateConnection(); _connection.Open(); _transaction = _connection.BeginTransaction(); }
protected override DataSet Select( DataSet ds, string selectStoredProcedure, params SWPGenericDbParameter[] parameters) { if (null == _dbTransactionConnection) { SWPDBHelper.StoredProcDataSet( _dbConnectionName, ds, selectStoredProcedure, TableName, parameters); } else { ds = SelectTransaction( ds, selectStoredProcedure, CommandType.StoredProcedure, parameters); } return(ds); }
protected virtual DbDataReader SqlStringReaderSelect(string selectText) { return(SWPDBHelper.SqlStringDataReader( _dbConnectionName, selectText, CommandType.Text)); }
protected virtual DbDataReader SqlStringReaderSelect( string selectText, params SWPGenericDbParameter[] parameters) { return(SWPDBHelper.SqlStringDataReader( _dbConnectionName, selectText, parameters)); }
public SWPTransactionDBConnection( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText) { _database = SWPDBHelper.DBConnection( connectionTextFormatType, connectionNameOrText); _connection = _database.CreateConnection(); _connection.Open(); _transaction = _connection.BeginTransaction(); }
protected virtual DataSet SqlStringSelect( DataSet ds, string selectText, params SWPGenericDbParameter[] parameters) { return(SWPDBHelper.SqlStringDataSet( _dbConnectionName, ds, selectText, TableName, parameters)); }
protected override DataSet SqlStringSelect( DataSet ds, string commandText, params SWPGenericDbParameter[] parameters) { if (null == _dbTransactionConnection) { SWPDBHelper.SqlStringDataSet( _dbConnectionName, ds, commandText, TableName, parameters); } else { SelectTransaction(ds, commandText, CommandType.Text, parameters); } return(ds); }
private void ProcessCommand( string storedProcedureName, DataTable table, DataRowVersion dataRowVersion, DbParameter [] parameters) { string candidateColumnName; bool parmSet; Database db = null; DbCommand command; DbConnection conn = null; if (table == null) { return; } try { if (_dbTransactionConnection == null) { db = SWPDBHelper.DBConnection( _connectionTextFormatType, _dbConnectionName); command = db.GetStoredProcCommand(storedProcedureName); conn = db.CreateConnection(); conn.Open(); command.Connection = conn; } else { command = _dbTransactionConnection.TransactionDatabase.GetStoredProcCommand( storedProcedureName); } command.CommandType = CommandType.StoredProcedure; foreach (DataRow row in table.Rows) { command.Parameters.Clear(); PopulateCommandWithParameters(command, parameters); foreach (DbParameter commandParameter in command.Parameters) { parmSet = false; // Skip the @ character candidateColumnName = ColumnName(_dbConnectionName, commandParameter.ParameterName); // we want to be case insensitive so lets // do this by hand foreach (DataColumn column in table.Columns) { if (String.Compare( column.ColumnName, candidateColumnName, true) == 0) { commandParameter.Value = row[column, dataRowVersion]; parmSet = true; break; } } if (!parmSet) { throw new Exception( "No matching column found for parameter: " + commandParameter.ParameterName); } } command.ExecuteNonQuery(); } } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn = null; } } }
protected virtual DbDataReader ReaderSelect(string selectText) { return(SWPDBHelper.StoredProcDataReader( _dbConnectionName, selectText)); }