This article describes an All-In-One Code Framework sample that is available for download. This code sample includes a step-by-step guide about how to work with Entity Data Model in various ways, including One-to-Many association, Many-to-Many association, One-to-One association, table merging, table splitting, Table-per-Hierarchy inheritance, and Table-per-Type inheritance.
To download this code sample, click the following link:
The Entity Framework is a set of technologies in ADO.NET that support development of data –oriented software applications. It enables developers to work with data in the form of domain-specific objects and properties, such as customers and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is stored.
The Entity Data Model (EDM) is a specification for defining the data used by applications built on the Entity Framework. Applications using the EDM define entities and relationships in the domain of the application in the design schema. The design schema is used to build programmable classes used by application code. Storage structures that persist data for applications in this model are represented in another schema called the storage schema. A mapping specification connects the design schema and the storage schema.
This code sample shows how to work with the EDM in various ways, including how to create One-to-Many association, Many-to-Many association and One-to-One association between EDM entities, how to merge two database tables into one EDM entity and split one database table into two EDM entities with one-to-one association, how to implement Table-per-Hierarchy inheritance and Table-per-Type inheritance in EDM.
Note For more information about how to create the sample application and how to deploy the sample application, see the Readme.txt file that is included in the download package.
This code sample contains the following programming languages:
Visual Basic .NET
You must attach the database file (.mdf) that is included in the download package to your SQL Server instance, and then modify the connection string information in the app.config file.
This sample application was created by using Visual Studio 2008 with Service Pack 1 installed.
Entity Framework, Entity Data Model
What is All-In-One Code Framework?
All-In-One Code Framework shows most Microsoft development techniques by using code samples in different programming languages. Each example is carefully selected, composed, and documented to show one common code scenario. For more information about All-In-One Code Framework, visit the following Web site: http://cfx.codeplex.com
How to find more All-In-One Code Framework samples
Microsoft corporation and/or its respective suppliers make no representations about the suitability, reliability, or accuracy of the information and related graphics contained herein. All such information and related graphics are provided "as is" without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information and related graphics, including all implied warranties and conditions of merchantability, fitness for a particular purpose, workmanlike effort, title and non-infringement. You specifically agree that in no event shall Microsoft and/or its suppliers be liable for any direct, indirect, punitive, incidental, special, consequential damages or any damages whatsoever including, without limitation, damages for loss of use, data or profits, arising out of or in any way connected with the use of or inability to use the information and related graphics contained herein, whether based on contract, tort, negligence, strict liability or otherwise, even if Microsoft or any of its suppliers has been advised of the possibility of damages.
Microsoft Visual Studio 2008 Academic Edition, Microsoft Visual Studio 2008 Professional Edition, Microsoft Visual Studio 2008 Standard Edition, Microsoft Visual Studio Team System 2008 Database Edition, Microsoft Visual Studio Team System 2008 Architecture Edition, Microsoft Visual Studio Team System 2008 Development Edition, Microsoft Visual Studio Team System 2008 Test Edition, Microsoft Visual Studio Team System 2008 Team Suite