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
Post a Comment