Entity Framework 4.1 · Expert's Cookbook by Liles, Devlin -- Read -- Imperial Library of Trantor

Index

Entity Framework 4.1: Expert's Cookbook

Entity Framework 4.1: Expert's Cookbook Credits About the Authors About the Reviewers www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe? Free Access for Packt account holders Instant Updates on New Packt Books

Preface

What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support

Downloading the example code Errata Piracy Questions

1. Improving Entity Framework in the Real World

Introduction Improving Entity Framework by using code first

Getting ready How to do it...

How it works... There's more...

Convention over configuration Model-View-Controller Single responsibility principle Testing

See also

Creating mock database connections

Getting ready How to do it...

How it works... There's more...

One object under test Integration tests Arrange, act, assert

Implementing the repository pattern

Getting ready How to do it...

How it works... There's more...

Dependency inversion principle Repository and caching Mocking Where constraint

See also

Implementing the unit of work pattern

Getting ready How to do it...

How it works... There's more...

Call per change Interface segregation principle Refactor

See also

Testing queries

Getting ready How to do it... How it works... There's more...

Query execution plan Query performance

See also

Creating databases from code

Getting ready How to do it...

How it works... There's more...

Configuration and creation Sample data

Testing queries for performance

Getting ready How to do it...

How it works... There's more...

Why do performance testing?

See also

Performing load testing against a database

Getting ready How to do it... How it works... There's more...

Stress testing Real-world simulation

See also

2. Understanding the Fluent Configuration API

Introduction Improving property maps

Getting ready How to do it... How it works... There's more...

Mapping storage More fluent configurations Finding tools to help

See also

Creating one-to-one maps

Getting ready How to do it... How it works... There's more...

Using more fluent configurations Considering eager versus lazy

See also

Creating one-to-many maps

Getting ready How to do it... How it works... There's more...

More fluent configurations More than one way to improve

See also

Creating many-to-many maps

Getting ready How to do it... How it works... There's more...

Payload More fluent configuration

See also

Mapping one table to many objects

Getting ready How to do it... How it works... There's more...

The cost Shared primary key association

See also

Mapping many tables to one object

Getting ready How to do it... How it works... There's more...

When to combine tables Security concerns

See also

Handling inheritance based on database values

Getting ready How to do it... How it works... There's more...

Table per hierarchy Table per type Table per concrete type

See also

Handling complex key maps

Getting ready How to do it... How it works... There's more...

Keys are used for relationships

See also

3. Handling Validation in Entity Framework

Introduction Validating simple properties

Getting ready How to do it... How it works... There's more...

Deciding between configuration and attributes Sharing validation Delaying validation Displaying error messages

See also

Validating complex properties

Getting ready How to do it... How it works... There's more...

Reusing the base class logic Performing all at once validation

See also

Validating collection properties

Getting ready How to do it... How it works... There's more...

Limiting reusability Validating the internal structure

See also

Creating custom property validation

Getting ready How to do it... How it works... There's more...

Coupling Avoiding complexity

See also

Improving MVC UI with entity framework validation

Getting ready How to do it... How it works... There's more...

Understanding the Html helper

4. Working with Transactions and Stored Procedures

Introduction Using transaction scopes

Getting ready How to do it... How it works... There's more...

Ensuring read/update separation Triggering careful now Remembering that size matters

See also

Handling multiple context transactions

Getting ready How to do it... How it works... There's more...

Atomic Consistent Isolation Durability

Executing stored procedures

Getting ready How to do it... How it works... There's more...

Handling return type mapping Remembering access rules

See also

Retrieving entities with stored procedures

Getting ready How to do it... How it works... There's more...

Column Mapping

See also

Updating entities with stored procedures

Getting ready How to do it... How it works... There's more...

Manually changing states Abstract usage Extensions for stored procedure support

See also

5. Improving Entity Framework with Query Libraries

Introduction Creating reusable queries

Getting ready How to do it... How it works... There's more...

Extension methods Naming conflict

See also

Improving entity and library reuse

Getting ready How to do it... How it works... There's more...

Schema and contract NuGet

Implementing composed queries

Getting ready How to do it... How it works... There's more...

Don't repeat yourself (DRY) Single responsibility principle

See also

Increasing performance with code access

Getting ready How to do it... How it works... There's more...

Developer discipline Cost of architecture

See also

Improving query testing

Getting ready How to do it... How it works... There's more...

IQueryable<T> IEnumerable

See also

6. Improving Complex Query Scenarios

Introduction

Improving dynamic sorting Getting ready How to do it... How it works... There's more...

Expression Trees Deferred execution Encapsulation

See also

Grouping at runtime without Lambda

Getting ready How to do it... How it works... There's more...

System.Linq.Dynamic Separation of concern AsQueryable and AsEnumerable

See also

Handling explicit loading

Getting ready How to do it... How it works... There's more...

Lambda statements LINQ aggregate Expression of function of T

Improving complex where clauses

Getting ready How to do it... How it works... There's more...

Compose-able LINQ

See also

Implementing the specification pattern

Getting ready How to do it... How it works... There's more...

Specification pattern

See also

7. Using Concurrent and Parallel Processing

Introduction Implementing optimistic concurrency

Getting ready How to do it... How it works... There's more...

Atomic execution Leaving no mess behind Isolation

See also

Managing parallel contexts

Getting ready How to do it... How it works... There's more...

Race conditions Locking

See also

Handling data retrieval in highly-threaded environments

Getting ready How to do it... How it works... There's more...

Client wins Store wins Custom determined

See also

Attaching objects with unit of work

Getting ready How to do it... How it works... There's more...

Attaching related objects Detaching objects

See also

Improving multiple context performance

Getting ready How to do it... How it works... There's more...

Thread interleaving Data race conditions Chess

8. Improving Entity Framework with Complex Business Scenarios

Introduction Handling soft delete

Getting ready How to do it... How it works... There's more...

Entity framework interceptors Soft delete pattern

See also

Implementing refreshing data on save

Getting ready How to do it... How it works... There's more...

EntityState EntityKey DbEntityEntry

See also

Capturing the audit data

Getting ready How to do it... How it works... There's more...

Created date and created by, modified date and modified by Action taken

See also

Improving MVC 3 applications

Getting ready How to do it... How it works... There's more...

Specification pattern Expression trees Strategy pattern

See also

← Prev
Back
Next →

← Prev
Back
Next →