.net - LLBL: Delete Where NOT IN -


I am trying to do the following query in LLBL and I am not very fortunate.

  Remove from DBA. Mattel is not my time ('39', '43', '44')  

Basically, I am at this point:

  Private static Remove Zero (MyTableCollection newRecs) {PredicateExpression Filters = New PredicateExpression (); MyTableCollection allRecords = New MyTableCollection (); Filter.Add (New FieldCompareSetPredicate (MyTableFields.MyTableId, MyTableFields.MyTableId, SetOperator.In, blank, empty, string, empty, 0, blank, true)); AllRecords.DeleteMulti (filter); }  

I'm not sure the above code is correct, but I do not understand how I can store new collections for use in my section.

Note: I realized that I have used static ID in my SQL example, but I 'm actually trying to use the ID that The new REC is stored in the parameter.

"not" to work, you have to pass some sort of array to do something like Try:

  list & lt; Int & gt; ID not idlelist = new list & lt; Int & gt; (); Foreign exchange (MyTableEntity ent in Nunech) {idsNotToDelete.Add (ent.MyTableId); } Launch Expression Filter = New Prakrit Expression (MyTableFields.MyTableId! = ID Noolaelet) MyTableCollection allRecords = New MyTableCollection (); AllRecords.DeleteMulti (filter);  

Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -