Modern C# and .NET Tutorial: Cross-Platform Basics/

...

Working with Transactions

Learn about transactions in EF Core and their role in maintaining database integrity and ensuring the ACID properties.

We'll cover the following...

Transaction in EF Core
- Role of transaction
- ACID properties
Controlling transactions using isolation levels
Defining an explicit transaction
- Try it yourself

Transaction in EF Core

Every time we call the SaveChanges method, an implicit transaction is started so that if something goes wrong, it will automatically roll back all the changes. If the multiple changes within the transaction succeed, the transaction and all changes are committed.

Role of transaction

Transactions maintain the integrity of our database by applying locks to prevent reads and writes while a sequence of changes occurs.

ACID properties

Transactions are ACID, which is an acronym explained in the following list:

Press + to interact

Introduction

Hello, C#! Welcome, .NET!

Speaking C#

Controlling Flow, Converting Types, and Handling Exception

Writing, Debugging, and Testing Functions

Building Your Own Types with Object-Oriented Programming

Implementing Interfaces and Inheriting Classes

Packaging and Distributing .NET Types

Working with Common .NET Types

Working with Files, Streams, and Serialization

Working with Data Using Entity Framework Core

Querying and Manipulating Data Using LINQ

Introducing Web Development Using ASP.NET Core

Building Websites Using ASP.NET Core Razor Pages

Building Websites Using the Model-View-Controller Pattern

Building and Consuming Web Services

Building User Interfaces Using Blazor

Conclusion

Working with Transactions

Transaction in EF Core

Role of transaction

ACID properties