In a project, I have set up a relation between Project and 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?

Related posts

Recent Viewed