Refine in the EDM Designer

This topic introduces the Entity Data Model (EDM) Designer which is a Visual Studio tool for defining conceptual entities and mapping them to the database.

Introduction

The EDM Designer is a Visual Studio design tool for defining your Entity Data Model (EDM). It reads and updates the EDMX file that represents the model in XML. Every DevForce developer who is responsible for writing and maintaining an Entity Framework EDM will use this tool.

You can implement almost every EDM feature with the EDM Designer. A few features require editing in raw XML and some tasks can be accomplished more quickly in XML. But the EDM Designer is preferred because the EDMX file is large and challenging to work with directly.

When you have created a new EDM with the EDM Wizard, the wizard leaves you in the EDM Designer. If you chose the "Data First" approach and generated the initial model from a database schema, the EDM Designer might look a bit like this:

The screenshot shows two of the four windows within which you specify the conceptual entities and how they map to the database.

You may be completely satisfied with the model as it was initialized from the database schema in which case your next stop might be to review the generated entity classes and start customizing them with your own business logic. 

Most developers adjust the EDM here in the designer in order to shape the entities to meet their needs. They may want to 

• change the name of an entity (or property) from its default value which is the name of the database table (or column). 
• establish an inheritance hierarchy among some of the entity types.
• add a custom base class
• designate concurrency properties
• specify how keys are generated
• consolidate related simple properties into a ComplexType property
• add XML documentation that will appear in the generated classes.

The basic workflow for such changes is:

• Select the object (entity, property, association) to modify in the diagram or search for it in the "Model Browser" window.
• Set the EDM properties for that object in the "Properties" window.
• Adjust mappings in he "Mapping Details" window.
• Save, causing DevForce to re-generate the entity classes.
• Build the application and test it.

Some of the object properties that you set in the designer are actually DevForce-specific properties. They were added by the DevForce EDM Designer Extension when you installed DevForce itself.

Update the model from the database

You probably shouldn't model every table in the database all at once. You'll add new entities over time and, if you use the Data-First approach, you'll want to initialize those entities and their mappings from information in the database just as you did when you first created the model with the EDM Wizard. 

When you change the database, you may need to change the EDM to match. 

Don't start over. Use the Update Model Wizard described here.

Learn More

The Microsoft documentation in MSDN is a place to start.

Microsoft-sponsored Entity Framework videos are short, excellent guides to building entity models with the EDM Designer. 

Julie Lerman's Programming Entity Framework, 2nd edition is authoritative on Entity Framework matters in general and the EDM Designer in particular. Julie's blog will keep you on top of the latest EF techniques.