Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <bag name="AccessRoles" table="ArtefactAccess" order-by="RoleID"
- lazy="true" access="field.camelcase-underscore" optimistic-lock="false">
- <key column="ArtefactID"/>
- <many-to-many class="Role" column="RoleID"/>
- </bag>
- <bag name="Roles" table="RolesToAccess" cascade="none" lazy="false">
- <key column="AccessId" />
- <many-to-many column="AccessId" class="Domain.Compound,Domain" />
- </bag>
- <bag name="RolesToAccess" cascade="save-update" inverse="true" lazy="false">
- <key column="AccessId" on-delete="cascade" />
- <one-to-many class="Domain.RolesToAccess,Domain" />
- </bag>
- <bag name="Accesses" table="RolesToAccess" cascade="none" lazy="false">
- <key column="RoleId" />
- <many-to-many column="RoleId" class="Domain.Compound,Domain" />
- </bag>
- <bag name="RolesToAccess" cascade="save-update" inverse="true" lazy="false">
- <key column="RoleId" on-delete="cascade" />
- <one-to-many class="Domain.RolesToAccess,Domain" />
- </bag>
- <bag name="Artifacts" table="[ArtifactAccess]" schema="[Dbo]" lazy="true"
- inverse="false" cascade="none" generic="true">
- <key column="[ArtifactID]"/>
- <many-to-many column="[RoleID]" class="Role" />
- </bag>
- <bag name="Roles" table="[ArtifactAccess]" schema="[Dbo]" lazy="true"
- inverse="false" cascade="none" generic="true">
- <key column="[RoleID]"/>
- <many-to-many column="[ArtifactID]" class="Role" />
- </bag>
- foreach(var artifact in role.Artifacts)
- foreach(var role in artifact.Roles)
- if(role == roleToDelete)
- artifact.Roles.Remove(role)
- artifact.Save();
- roleToDelete.Delete();
- roleToDelete.Artifacts.Clear(); //removes the association record
- roleToDelete.Delete(); // removes the artifact record
Add Comment
Please, Sign In to add comment