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 4m
- Properties of Transactions 2m
- Optimistic and Pessimistic Concurrency Control 2m
- Concurrency Issues in App Development 3m
- Database Isolation Levels 9m
- SQL Server Isolation Levels 7m
- Understanding Database Deadlocks 1m
- Deadlock Examples with Entity Framework Core 5m
- Preventing Deadlocks with Table Hints 2m
- Recovering from Deadlocks with Retries 2m
- Module Summary 1m
- Introduction 1m
- Understanding the Optimistic Offline Lock Pattern 5m
- Optimistic Concurrency with Entity Framework Core 2m
- Overview of Demo Project 10m
- Implementing Optimistic Offline Lock 7m
- Managing State of Disconnected Entities 6m
- Concurrency Conflicts When Deleting an Entity 8m
- Module Summary 1m
About the author
Neil has worked on everything from early mobile .NET compact framework apps to modern Azure based web apps during his years in IT. As a developer and architect, he has focused on .NET and JavaScript application development, security, and hosting across a variety of Microsoft platforms, including ASP.NET, SharePoint, and Dynamics CRM. Neil has several Microsoft Certifications, including MCPD, MCSA, and MCSD.