linq middle join betwenn enumerable db table


i'm perplexing establish annals mislay database user submits form.
the page twin checkboxlist representing annals before alteration after.



i simply comparison values need deleted this...



//get equipment comparison selected before
var oldselecteditems = oitem oldchklspecialneeds.items.cast<listitem>()
where !(from nitem newchklspecialneeds.items.cast<listitem>()
where nitem.selected
name nitem.value).contains(oitem.value)
&& oitem.selected
name oitem.value;


now i am perplexing something nonetheless isn't permitting it...



var itemstodelete = specialneed db.specialneeds
join oldselecteditem oldselecteditems specialneed.specialneedstypecd equals oldselecteditem.value
where specialneed.customerid == customerid


i simply only foreach loop .deleteonsubmit() any vigilant nonetheless i'm pondering there proceed functionality linq pass whole query outcome an middle join .deleteallonsubmit()



//like so
db.specialneeds.deleteallonsubmit(itemstodelete);


any ideas?



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?