c# - Entity Framework 4 - Delete Object -
i have 3 tables in database
cmsmasterpages cmsmasterpagesadvslots (pure juction table) cmsadvslots
here picture of edm:
i need find out objects cmsadvslot connected cmsmasterpage (it working in code posted belove), , delete result (cmsadvslot) database.
my problem i not able delete objects when found theme.
error: object cannot deleted because not found in objectstatemanager.
int findmasterpageid = convert.toint32(uxmasterpageslistselector.selectedvalue); cmsmasterpage mymasterpage = context.cmsmasterpages.firstordefault(x => x.masterpageid == findmasterpageid); var resultadvslots = mymasterpage.cmsadvslots; // working until here foreach (var todeleteadv in resultadvslots) { context.deleteobject(mymasterpage.cmsadvslots.any()); // erorr here!! context.savechanges(); }
any idea how solve it? time! :-)
try this:
while (mymasterpage.cmsadvslots.count > 0) { var slot = mymasterpage.cmsadvslots.first(); mymasterpage.cmsadvslots.remove(slot); // required in scenarios - depends on type of entities using. context.deleteobject(slot); } context.savechanges();
Comments
Post a Comment