How do i use the connection to the database that strataframe has made to execute miscellaneous sql? select statements, stored procedures, etc.

Is it possible for me to bind these to a transaction and roll them back if any of them fail? I wasnt sure if StrataFrame supports transactional updates.



DataBasics.DataSources("").ExecuteStoredProcedure("STI30PostTempTagsToInventory", DbCommandExecutionType.ExecuteNonQuery, loParams.ToArray)

DataBasics.DataSources("").ExecuteStoredProcedure("STI30CreateProductionCosts", DbCommandExecutionType.ExecuteNonQuery, loParams.ToArray)



Thanks

If you need manual access to a transaction, you will need to create the transaction and create the SqlCommand objects manually and execute them like this:

Try
    '-- Start the transaction
    DataBasics.DataSources("").TransactionBegin("MyTrans", Data.IsolationLevel.ReadCommitted)

    '-- Create the command object
    Dim command As New SqlCommand("STI30PostTempTagsToInventory")
    command.CommandType = Data.CommandType.StoredProcedure
    command.Transaction = CType(DataBasics.DataSources("").Transactions("MyTrans"), SqlTransaction)

    '-- Execute the command
    DataBasics.DataSources("").ExecuteScalar(command)

    '-- Commit the transaction
    DataBasics.DataSources("").TransactionCommit("MyTrans")

Catch ex As Exception

    DataBasics.DataSources("").TransactionRollback("MyTrans")

End Try