-
Course
- Core Tech
Enterprise Patterns: Concurrency in Business Applications
When multiple users are editing the same data, concurrency effects can result in lost work or errors. This course teaches you how to prevent concurrency errors at database level, and for business transactions that span multiple pages and postbacks.
What you'll learn
When developing applications where multiple users can edit the same data, concurrency effects can result in work being overwritten and inconsistent data being read, which can cost a business time, money, and frustration. In this course, Enterprise Patterns: Concurrency in Business Applications, you'll learn how to recognize and prevent these types of errors. First, you'll explore how to use isolation levels within database transactions. Next, you'll discover how to implement optimistic and pessimistic concurrency in code for long-running business transactions. Finally, you'll learn how to design a locking framework for your application. When you’re finished with this course, you'll have a foundational knowledge of concurrency patterns that will help you as you move forward to design more robust, enterprise applications. Software required: Microsoft Visual Studio.
Table of contents
- Introduction | 3m 36s
- Properties of Transactions | 2m 3s
- Optimistic and Pessimistic Concurrency Control | 2m 16s
- Concurrency Issues in App Development | 3m 18s
- Database Isolation Levels | 8m 51s
- SQL Server Isolation Levels | 7m 1s
- Understanding Database Deadlocks | 1m 23s
- Deadlock Examples with Entity Framework Core | 4m 39s
- Preventing Deadlocks with Table Hints | 2m 7s
- Recovering from Deadlocks with Retries | 2m 12s
- Module Summary | 48s
About the author
Neil is a solutions architect and developer, with a passion for web development, architecture, and security. He has worked in large and small IT organizations, written articles on development, and spoken at local .NET user groups. Neil has several Microsoft Certifications, including MCPD, MCSA, and MCSD.
More Courses by Neil