You are analyzing a Windows client application that uses Microsoft Visual Studio 2010 and Microsoft SQL Server 2008 The application updates two database tables from the main user interface (UI) thread You need to ensure that the following requirements are met
+ The database tables are either updated simultaneously or not updated at all
+ Users are notified of the success or failure of the updates
+ Users are able to perform other tasks during the update process
What should you do?
A.
“Move the database update logic to a Background Worker thread Ensure that the thread is
enclosed in a Transaction Scope using block in the Background Worker Do Work method
B.
“Use Transaction Scope in a using block on the UI thread Batch the database updates by setting the Db Data Adapter Update Batch Size property to 2.
Use Transaction Scope in a using block on the main thread Create a Back ground Worker thread within the block
C.
“Move the database updates to the Back ground Worker Do Work method ” Use Transaction Scope in a using block on the UI thread ” Create a Dependent Transaction object within the block and pass the object to the stack ground Worker uovvorx mentor
D.
“Use the object in the Do Work method to create a new Transaction Scope block