The ADO.NET Entity Framework Extensions library includes utilities that make querying stored procedures, creating typed results from DB data readers and state tracking external data much easier in the Entity Framework. A sample application demonstrates several patterns using these utilities, including stored procedures with multiple result sets, materialization of CLR types, and registering entities in the Entity Framework state manager.

Overview

Utilities are included to simplify:

• Execution of store commands via the ObjectContext.
• Connection lifetime management.
• State management of entities from external sources.
• Materialization of arbitrary CLR types given a data reader or DB command.
• Stored procedure mapping:
• Multiple result sets.
• Column renames, polymorphic results and nested structures via the materialization service.
• Getting and setting key values for entity references.
• Rewrite InvocationExpressions in LINQ queries and expressions.

Requirements

Visual Studio 2008 SP1.

http://msdn.microsoft.com/en-us/vsts2008/products/cc533447.aspx

Other resources

The following post introduces the EFExtensions API and includes a walkthrough of the sample application:

http://blogs.msdn.com/meek/archive/2008/03/26/ado-entity-framework-stored-procedure-customization.aspx

For additional information on multiple result sets and relationships, see:

http://blogs.msdn.com/meek/archive/2008/12/07/stored-procedures-and-first-class-relationships-in-the-entity-framework.aspx

For additional information on InvocationExpression rewriting, see:

http://blogs.msdn.com/meek/archive/2008/12/07/invocationexpression-and-linq-to-entities.aspx