Exploring the Security EDM
The EDM allows the application to have its own view of the application's data. Consider the following EDM created using the Visual Studio 2015 ADO.NET EDM Wizard:
The Security Entity Data Model
Note that the relationships and the respective fields are displayed along with their multiplicity. You can also see the scalar and navigation properties. While the Scalar Properties section lists the attributes or the fields of the entity, the Navigation Properties are those that denote the associations of a particular entity with other entities.
As an example, the UserRole entity uses the User and the Role entities to relate its foreign keys UserID and RoleID respectively. This is also called a join table
and facilitates a many-to-many relationship.
The Mapping Details window
Now we will take a look at the mappings details. That is, how the properties of the entities are mapped to the underlying database.
To do this, select any entity in the Security DataModel in the design...
