How to delete a navigation property of an object

Question

I have two model classses ; SecurityRole & SecurityRoleTypePermission. where each Securityrole can have zero to many SecurityRoleTypePermission. now i have the following repository method, with the aim to delete the associated SecurityRole & all of its SecurityRoleTypePermissions if they are avilable:- i tried the following code :-

public void DeleteRole(int id, string username)
        {
            var role = tms.SecurityRoles.SingleOrDefault(a=>a.SecurityRoleID ==id);
            var auditinfo = IntiateAdminAudit(tms.AuditActions.SingleOrDefault(a => a.Name.ToUpper() == "DELETE").ID, tms.SecurityTaskTypes.SingleOrDefault(a => a.Name.ToUpper() == "SECURITY ROLE").ID, username, role.Name);
            var srtp = role;
            foreach (var i in srtp.SecurityroleTypePermisions)
            {
                tms.SecurityroleTypePermisions.Remove(i);
            }
            tms.SecurityRoles.Remove(role);

            InsertOrUpdateAdminAudit(auditinfo);
        }

But i got the following exception :-

Collection was modified; enumeration operation may not execute.

so me question is why i am getting this error, although i have copied the role object to a new srtp variable ?

Second question , i need to know if there is a way to delete an object navigation property, without the need to loop though each record using the foreach as in my code ?

Thanks

thanks for the link, but this will answer my first question , while it did not answer my second question ? — John John, Nov 25 '13 at 11:07
have you tried cascading delete? if not, i'll try to add an answer with some example — rik.vanmechelen, Nov 25 '13 at 11:13
you mean cascade on delete at the database level ? i want to avoid doing it at the DB level ... — John John, Nov 25 '13 at 11:36
entity framework has it's own cascading delete. it will delete all the nested resources that are currently loaded into memory for the desired entity — rik.vanmechelen, Nov 25 '13 at 13:03

How to delete a navigation property of an object

0 Answers0