As far as I understand, you are using the Many to Many association between Users and Roles with a join table UserRoles, so that UserRoles is not present in your model.
In order to make the additional fields available, you will have to map this relationship using the other option – presenting the UserRoles class in the domain model, so that instead of Many to Many relation between User and Role you will have a diagram like the one attached.
To achieve that, first go to your Model Schema Explorer and set the IsJoinTable property of the UserRoles table to False. Then drag & drop the table into your diagram and the associations should be automatically created.
This way you will be able to use any additional fields that come with the UserRoles table. The only disadvantage is that you won’t have a direct link from a User to the Role and vice versa – you will have to use the UserRoles collection instead.
I am looking forward to your feedback.
the Telerik team
Want to use Telerik OpenAccess with SQL Azure? Download
the trial version today.