public SWPTransactionDBConnection( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText) { _database = SWPDBHelper.DBConnection( connectionTextFormatType, connectionNameOrText); _connection = _database.CreateConnection(); _connection.Open(); _transaction = _connection.BeginTransaction(); }
public static Database DBConnection( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText) { if (connectionTextFormatType == SWPConnectionTextFormatType.ConnectionName) { return(DBFromConnectionName(connectionNameOrText)); } else // if (connectionTextFormatType == SWPConnectionTextFormatType.ConnectionString) { return(DBFromConnectionText(connectionNameOrText)); } }
public static DataSet SqlStringDataSet( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText, DataSet ds, string commandText, string tableName, params SWPGenericDbParameter[] parameters) { return(SqlStringDataSet( DBConnection(connectionTextFormatType, connectionNameOrText), ds, commandText, tableName, parameters)); }
public static DataSet StoredProcDataSet( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText, DataSet ds, string storedProcedureName, string tableName, params SWPGenericDbParameter[] parameters) { return(StoredProcDataSet( DBConnection(connectionTextFormatType, connectionNameOrText), ds, storedProcedureName, tableName, parameters)); }
public static DataSet StoredProcDataSetSchema( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText, string dataSetName, string commandText, string sourceTableName, SchemaType schemaType) { return(DataSetSchema( DBConnection(connectionTextFormatType, connectionNameOrText), dataSetName, commandText, sourceTableName, schemaType, CommandType.StoredProcedure)); }
private static DataSet DataSetSchema( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText, string dataSetName, string commandText, string sourceTableName, SchemaType schemaType, CommandType commandType) { return(DataSetSchema( DBConnection(connectionTextFormatType, connectionNameOrText), dataSetName, commandText, sourceTableName, schemaType, commandType)); }
public static DataSet SqlStringDataSet( SWPConnectionTextFormatType connectionTextFormatType, string connectionNameOrText, string commandText, string dataSetName, string tableName, params SWPGenericDbParameter[] parameters) { DataSet ds = new DataSet(dataSetName); return(SqlStringDataSet( connectionTextFormatType, connectionNameOrText, ds, commandText, tableName, parameters)); }
public SWPDataReadWriteBase( SWPConnectionTextFormatType connectionTextFormatType, string dbConnectionNameOrText) : base(connectionTextFormatType, dbConnectionNameOrText) { }
public SWPDataReadOnlyBase(string dbConnectionNameOrText) { _dbConnectionName = dbConnectionNameOrText; _connectionTextFormatType = SWPConnectionTextFormatType.ConnectionName; }