Packt+ | Advance your knowledge in tech

You're reading from Entity Framework Core Cookbook - Second Edition

Product type Book

Published in Nov 2016

Publisher Packt

ISBN-13 9781785883309

Pages 324 pages

Edition 2nd Edition

Languages

Concepts

Application Development

Author (1):

Ricardo Peres

Table of Contents (15) Chapters

Entity Framework Core Cookbook - Second Edition

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

1. Improving Entity Framework in the Real World

Introduction
Improving Entity Framework by using a code-first approach
Unit testing and mocking
Creating databases from code
Creating mock database connections
Implementing the repository pattern
Implementing the unit of work pattern

2. Mapping Entities

Introduction
Mapping non-public members
Mapping interfaces
Shadow properties
Creating one-to-one maps
Creating one-to-many maps
Creating many-to-many maps
Creating custom conventions
Using sequence key generators
Using GUIDs as keys
Implementing inheritance – Table per Class hierarchy

3. Validation and Changes

Introduction
Validating simple properties
Validating the whole entity
Validating groups of entities
Intercepting saving changes
Intercepting property changes
Setting the state of an entity
Improving MVC UI with entity framework validation
Inserting, updating, and deleting entities with stored procedures
Updating the database from model changes
Dumping the SQL script for the database creation

4. Transactions and Concurrency Control

Introduction
Using explicit transactions
Using transactions in custom SQL operations
Implementing optimistic concurrency in SQL Server
Implementing optimistic concurrency in a database-agnostic way

5. Querying

Introduction
Executing client-side functions in LINQ queries
Mixing SQL with LINQ queries
Getting entities from the local cache
Creating filtered collections
Creating reusable queries
Querying shadow properties
Implementing the query object pattern
Using dynamic LINQ

6. Advanced Scenarios

Introduction
Generating entities from the database
Implementing multitenancy
Strongly typed bulk operations
Handling soft deletes
Adding logging
Capturing the audit data
Retrieving entity metadata
Improving MVC applications
Hooking infrastructure services
Using other databases

7. Performance and Scalability

Introduction
Improving the performance of queries
Testing and profiling queries
Using asynchronous operations
Eager loading
Using the cache

Pitfalls

Introduction
GroupBy executes on the client side
Table per class hierarchy requires nullable columns for derived classes
References not eagerly fetched are lost
Date/time operations are not supported
Paging in SQL Server earlier than 2012
Database null semantics
Migrations and contexts with parameterized constructors
Migrations with contexts in different projects
Accessing the service provider too soon
Setting the maximum string length
Mapping discriminator columns
Composite primary keys
Refreshing entities
Cascading entity deletes

Index

Introduction

In this chapter, we will see how Entity Framework Core deals with concurrency, that is, multiple simultaneous (or almost) changes to the same database object. In particular, we will see the two most common ways to handle concurrency: optimistic concurrency control and pessimistic concurrency control, also known as transactions.