Dear All,
I am using the SQl roleprovider classes for my application and the entity model.
When I made an edmx object and saw the diagram, the UsersInRole table is shown isolated and not connected between Users and Roles tables as it should be(I think)
The structure of this table is: UserID(PK ,FK Users table UserID); RoleID(PK, FK Roles table RolesID)
The combinatio of both keys is being taken as primary key.
These are the predefined SQLRoleProvider database tables, and I fail to understand how I see this error.Now I cannot understand why this table is being isolated from the Roles and Users table, and in fact I am not able to build the application or use data in any controls.
here is the error I face on build:
Problem in mapping fragments starting at lines 2087, 2292:Two entities with possibly different keys are mapped to the same row. Ensure these two mapping fragments map both ends of the AssociationSet to the corresponding ...
Go to the complete details ...