Entity Framework & Linq to Entities: “Movies” Example Setup

The Entity Data Model Used in the “Movies” Example

Below are diagrams representing the database, entity data, and entity object model used in the Linq to Entities Quick Reference posts. The Quick References are meant to provide numerous examples of performing common CRUD (Create, Read, Modify, and Delete) tasks with Linq to Entities.

Visit: C# Entity Framework & Linq to Entities (Quick Reference)

Database Structure for the "Movies" Example

Database Structure for the "Movies" Example

Directors Database Records

Directors Database Records

Movies Database Records

Movies Database Records

Entity Diagram for the "Movies" Example

Entity Diagram for the "Movies" Example

This Entity Model was created by adding an ADO.NET Entity Data Model item to the solution and specifying that the model should be generated based on the Movies database. The model was then modified slightly using the Entity Designer within Visual Studio 2008. For instance, the FirstLastName property was changed to Name.
Class diagram of the entity data model for the "Movies" example.

Class diagram of the entity data model for the "Movies" example.

This class diagram is a visual representation of the Entity Framework object model for the Movies example and serves as a valuable resource for understanding its structure, properties, and methods. You can create such a class diagram in your Visual Studio 2008 project by adding a new Class Diagram item to the project, and then dragging the file representing your entity model (.edmx extension) from the Solution Explorer onto the Class Diagram’s design surface. Once the diagram has been created, right click on each of the classes and choose the “Show Base Class” option from the context menu. Doing so will include the core entity framework base classes, such as the ObjectContext class, to the diagram giving you a complete view into what’s available to you.
Advertisements

5 Responses

  1. […] Linq to Entities: “Movies” Example Setup […]

  2. […] Linq to Entities: “Movies” Example Setup contains diagrams representing the database structure, entity data model, and entity object model used in the following code examples. […]

  3. […] Entity Framework & Linq to Entities: “Movies” Example Setup contains diagrams representing the database structure, entity data model, and entity object model used in the following code examples. […]

  4. […] Entity Framework & Linq to Entities: “Movies” Example Setup contains diagrams representing the database structure, entity data model, and entity object model used in the following code examples. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: