In a project, I have set up a relation between
ProjectMembers such that a Project can have a list of ProjectMembers and ProjectMemebers can only participate in one project (see Concurrency Check on an ICollection (during add)).
I would like to have a field that is auto-incremented, however, it shouldn't be an identity column.
For example, given a Project, once we add a new ProjectMemeber, that member will receive a number (like an id) that allows us to identify that ProjectMemeber only in that particular Project.
Is there any way to achieve this using EF?