Skip navigation links
20.2.3.10 MySQL Website Configuration Tool »
Section Navigation      [Toggle]

20.2.3.9. Using the ADO.NET Entity Framework

Connector/NET 6.0 introduced support for the ADO.NET Entity Framework. ADO.NET Entity Framework was included with .NET Framework 3.5 Service Pack 1, and Visual Studio 2008 Service Pack 1. ADO.NET Entity Framework was released on 11th August 2008.

ADO.NET Entity Framework provides an Object Relational Mapping (ORM) service, mapping the relational database schema to objects. The ADO.NET Entity Framework defines several layers, these can be summarized as:

  • Logical - this layer defines the relational data and is defined by the Store Schema Definition Language (SSDL).

  • Conceptual - this layer defines the .NET classes and is defined by the Conceptual Schema Definition Language (CSDL)

  • Mapping - this layer defines the mapping from .NET classes to relational tables and associations, and is defined by Mapping Specification Language (MSL).

Connector/NET integrates with Visual Studio 2008 to provide a range of helpful tools to assist the developer.

A full treatment of ADO.NET Entity Framework is beyond the scope of this manual. You are encouraged to review the Microsoft ADO.NET Entity Framework documentation.

Tutorials on getting started with ADO.NET Entity Framework are available. See Section 20.2.4.5, “Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source” and Section 20.2.4.6, “Tutorial: Databinding in ASP.NET using LINQ on Entities”.


User Comments

Posted by Chris Van Vranken on July 21 2009 9:39pm[Delete] [Edit]

The above example for adding a datasource works for website projects. However it does not work for web application projects. To add an entity data source for a web application project see this article: http://msdn.microsoft.com/en-us/library/bb896242.aspx

Add your own comment.