Book Image

Entity Framework 4.1: Expert's Cookbook

By : Devlin Liles , Tim Rayburn
Book Image

Entity Framework 4.1: Expert's Cookbook

By: Devlin Liles , Tim Rayburn

Overview of this book

<p>Entity Framework 4.1 allows us to dive into the world of data access without having to write SQL statements. With the power to shape data access by your object model comes questions and this book holds the answers.</p> <p>Entity Framework 4.1: Expert's Cookbook holds many examples to help guide you through tough technical decisions and avoid technical landmines. The book will guide you from just using Entity Framework to enhancing the data access wizard.</p> <p>This book starts with examples that require some familiarity of object relational mappers, and then moves on to more advanced tasks. You will be guided through complex mapping scenarios, query definition, reusability, integration with other technologies, and architectural management. The approach is step-by-step and test driven so that it is focused as much as possible on solving problems and getting the most out of the time spent working through the book.</p> <p>Entity Framework 4.1: Expert's Cookbook is a must have for any .NET developer who uses Entity Framework, and wants better, cleaner, and more maintainable code.</p>

Related Content you might be interested in

Current Title:

Small book image
Entity Framework 4.1: Expert's Cookbook
Devlin Liles | Tim Rayburn
Mar, 2012 | 352 pages
No titles found
Table of Contents (15 chapters)
Entity Framework 4.1: Expert's Cookbook
Entity Framework 4.1: Expert's Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Improving Entity Framework in the Real World
Improving Entity Framework in the Real World
Introduction
Improving Entity Framework by using code first
Creating mock database connections
Implementing the repository pattern
Implementing the unit of work pattern
Testing queries
Creating databases from code
Testing queries for performance
Performing load testing against a database
2
Understanding the Fluent Configuration API
Understanding the Fluent Configuration API
Introduction
Improving property maps
Creating one-to-one maps
Creating one-to-many maps
Creating many-to-many maps
Mapping one table to many objects
Mapping many tables to one object
Handling inheritance based on database values
Handling complex key maps
3
Handling Validation in Entity Framework
Handling Validation in Entity Framework
Introduction
Validating simple properties
Validating complex properties
Validating collection properties
Creating custom property validation
Improving MVC UI with entity framework validation
4
Working with Transactions and Stored Procedures
Working with Transactions and Stored Procedures
Introduction
Using transaction scopes
Handling multiple context transactions
Executing stored procedures
Retrieving entities with stored procedures
Updating entities with stored procedures
5
Improving Entity Framework with Query Libraries
Improving Entity Framework with Query Libraries
Introduction
Creating reusable queries
Improving entity and library reuse
Implementing composed queries
Increasing performance with code access
Improving query testing
6
Improving Complex Query Scenarios
Improving Complex Query Scenarios
Introduction
Grouping at runtime without Lambda
Handling explicit loading
Improving complex where clauses
Implementing the specification pattern
7
Using Concurrent and Parallel Processing
Using Concurrent and Parallel Processing
Introduction
Implementing optimistic concurrency
Managing parallel contexts
Handling data retrieval in highly-threaded environments
Attaching objects with unit of work
Improving multiple context performance
8
Improving Entity Framework with Complex Business Scenarios
Improving Entity Framework with Complex Business Scenarios
Introduction
Handling soft delete
Implementing refreshing data on save
Capturing the audit data
Improving MVC 3 applications
Index
Index

Implementing the specification pattern

In this recipe, we will be implementing a specification pattern on top of Entity Framework and Repository Pattern to leverage maximum reuse without surfacing queryable objects to the consuming developers.

Getting ready

We will be using the NuGet package manager to install the Entity Framework 4.1 assemblies.

The package installer can be found at http://nuget.org.

We will also be using a database for connecting to and updating data.

Open the Improving Complex Query Testing solution in the included source code examples.

How to do it...

Carry out the following steps in order to accomplish this recipe.

  1. We start by writing a test which will query the database with a predefined specification. Use the following code:

    using System;
using System.Collections.Generic;
using System.Linq;
using BusinessLogic;
using DataAccess.Queries;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Rhino.Mocks;
using DataAccess;
using BusinessLogic.QueryObjects;
using Test.Properties...
Previous Section
End of Chapter 6
Next Chapter