Minimizing and Handling Database Operation Conflicts with Microsoft® Visual Studio® 2005 (4227)


This 2-hour workshop explains how data conflicts occur when multipleusers attempt to read or modify the same data at the same time.Suggestions and guidelines are provided to help you decide how tominimize, detect, and resolve these data conflicts when using MicrosoftADO.NET and Microsoft SQL Server™ 2005.

In the lab, you will write code to investigate optimistic concurrencyconflicts and you will run multiple instances of a prewrittenapplication to investigate the effects of different isolation levels.

As a workshop, most of your learning will take place during theextensive lab.

ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.



  • Explain why data conflicts arise and describe the strategies that minimize the conflicts.
  • Handle data concurrency by using ADO.NET and verify the effects of locking using different transaction isolation levels.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-MHD-OCM
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend