LINQ query NOT IN-CodePudding

Home > Mobile > LINQ query NOT IN

LINQ query NOT IN

Time：01-21

I have this simple SQL query using NOT IN operator:

SELECT * FROM List l WHERE L.ListName NOT IN ('POType','MailClass')

How can I write this using LINQ query syntax?

CodePudding user response：

string[] listNames = {"POType", "MailClass"};
var query = from l in List
            where ! listNames.Contains(l.ListName)
            select l;