public SWPTransactionDBConnection(
            SWPConnectionTextFormatType connectionTextFormatType,
            string connectionNameOrText)

        {
            _database = SWPDBHelper.DBConnection(
                connectionTextFormatType,
                connectionNameOrText);
            _connection = _database.CreateConnection();
            _connection.Open();
            _transaction = _connection.BeginTransaction();
        }
Exemplo n.º 2
0
        public static Database DBConnection(
            SWPConnectionTextFormatType connectionTextFormatType,
            string connectionNameOrText)
        {
            if (connectionTextFormatType == SWPConnectionTextFormatType.ConnectionName)
            {
                return(DBFromConnectionName(connectionNameOrText));
            }

            else // if (connectionTextFormatType == SWPConnectionTextFormatType.ConnectionString)
            {
                return(DBFromConnectionText(connectionNameOrText));
            }
        }
Exemplo n.º 3
0
 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));
 }
Exemplo n.º 4
0
 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));
 }
Exemplo n.º 5
0
 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));
 }
Exemplo n.º 6
0
 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));
 }
Exemplo n.º 7
0
        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;
 }