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

Product type Paperback

Published in Nov 2016

Publisher Packt

ISBN-13 9781785883309

Length 324 pages

Edition 2nd Edition

Tools

Entity Framework

Concepts

Application Development

Author (1):

Ricardo Peres

View More author details

Table of Contents (10) Chapters

Preface

What this book covers
What you need for this book
Who this book is for
Sections
Conventions
Reader feedback
Customer support
Downloading the example code

1. Improving Entity Framework in the Real World FREE CHAPTER

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

A. 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

Preface

This book is about the new Entity Framework Core 1.0. In here, you will find recipes that will hopefully make your life easier when working with Entity Framework Core. If all goes well, you will also have some fun while doing it.

It has something for both beginners as well as more seasoned developers.

The rest of the chapter is locked

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

Table of Contents (10) Chapters

Preface

Authors (1)

Personalised recommendations for you

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

Table of Contents (10) Chapters

Preface

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you