You are modifying an existing Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the data into a database. The database includes one parent table and many child tables.
Inserting captured data in the database locks many database tables and delays application access.
You have the following requirements:
Reduce delays when saving data.
Ensure that other application users are not blocked from reading data. Ensure that captured data is available only after all child tables are updated.
You need to recommend an approach for inserting captured data into the database.
What should you recommend?
A.
Insert all captured data in a single transaction when the user completes the wizard.
B.
Insert captured data by using a single transaction as the user completes each wizard page.
C.
Insert captured data by using non-transactional operations when the user completes the wizard.
D.
Insert captured data by using optimistic concurrency as the user completes each wizard page.