c# - Entity Framework 4 - Delete Object -


i have 3 tables in database

cmsmasterpages cmsmasterpagesadvslots (pure juction table) cmsadvslots 

here picture of edm:

enter image description here

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

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -