Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Entity Framework Core Cookbook

You're reading from   Entity Framework Core Cookbook Transactions, stored procedures, query libraries, and more

Arrow left icon
Product type Paperback
Published in Nov 2016
Publisher Packt
ISBN-13 9781785883309
Length 324 pages
Edition 2nd Edition
Arrow right icon
Author (1):
Arrow left icon
Ricardo Peres Ricardo Peres
Author Profile Icon Ricardo Peres
Ricardo Peres
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. Improving Entity Framework in the Real World FREE CHAPTER 2. Mapping Entities 3. Validation and Changes 4. Transactions and Concurrency Control 5. Querying 6. Advanced Scenarios 7. Performance and Scalability A. Pitfalls Index

Using explicit transactions

Transactions define a boundary: anything (and everything) inside a transaction is either guaranteed to fail or succeed. Imagine a bank transfer from one bank to another. If you think of the steps involved, they are as follows:

  1. Some amount is withdrawn from a bank account.
  2. The same amount is deposited in another bank account.

One cannot exist without the other: both actions must either occur or neither of them can occur in isolation.

Transactions have what is commonly referred to as the ACID properties. This acronym is explained in the following sections.

Atomic

The execution of any transaction should either have the full intended effect or no effect at all. The results should be either complete (commit), or nothing should happen (roll back).

Consistent

Any transaction is a transition of state in an application, and therefore should preserve a consistent version of the application. For example, when updating a many-to-many relationship, both the foreign key and the reference...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image