jeudi 20 août 2015

C# - Search in List with array in WHERE clause

C#

Ok, I have something like that:

var message = db.Table<Message>().Where(cond => cond.ID == messageID).Single();
message.Status = status;

But I'd like to change my messageID from int to int[], so I will select all data where cond.ID is in my int[] messageID. I need something like .Where(cond => cond.ID IN messageID). I don't want to do that in a way like:

foreach(var ID in messageID)
{
   message = db.Table<Message>.Where(cond => cond.ID == ID).Single();
   message.Status = status;
   db.Update(message);
}

I use SQLite, any help with update multiple rows at once will be very appreciated.

Aucun commentaire:

Enregistrer un commentaire