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

Improving MVC 3 applications

In this recipe, we will work through a full MVC 3 application, using patterns and the Entity Framework to give a solid basis for any enterprise application.

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.codeplex.com/.

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

Open the Improving MVC 3 Applications solution in the included source code examples.

How to do it...

  1. We start off with a couple of tests that will make sure that our controller and our repository work the way that we intend. We need to add a new C# test class named ControllerTests with the following code:

    using System.Collections.Generic;
using System.Web.Mvc;
using BusinessLogic;
using BusinessLogic.Interfaces;
using DataAccess.Queries;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Rhino.Mocks;
using UI.Controllers;

namespace Test
{
  [TestClass]
  public...
Previous Section
End of Chapter 8
Next Chapter