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

Creating one-to-one maps

This recipe will allow us to map the direct relationships between two objects into the foreign keys that will hold this relationship in the database.

Getting ready

We will be using 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 One-To-One References solution in the included source code examples.

How to do it...

Let us get connected to the database using the following steps:

  1. We start by adding a new unit test named MappingTest to the Test project. We make a test that connects to the database and retrieves an object. This will test the configuration and ensure that the model matches the database schema. Use the following code:

    using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BusinessLogic;
using DataAccess;
using DataAccess.Database;
using Microsoft.VisualStudio.TestTools...
Previous Section
End of Section 4
Next Section