c# – Linq multiple choice (if not contains)

Question:

Here is a sample for 2 conditions

using (AccidentContext db = new AccidentContext())
{
    var kinds = new[] { "Delete", "Change" };
    var accidents = db.Accidents.Where(p => kinds.Contains(p.Kind));
    foreach (var VARIABLE in accidents)
    {
        AccidentList.Add(VARIABLE);
    }
}

And how to make the same selection that selects all other options except Delete and Change?

Answer:

You can simply expand the condition:

db.Accidents.Where(p => !kinds.Contains(p.Kind));

Or use Except :

var kinds = new[] { "Delete", "Change" };
var accidents = db.Accidents.Where(p => kinds.Contains(p.Kind));
var accidentsExceptDeleteAndChange = db.Accidents.Except(accidents);