Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

implementing "where in" clause in Lambda?

Tags:

c#

.net

lambda

I have a expression which is returning me Ids:

var UserNotificationIds = _notificationBidderRepos.All(u => u.BidderId == BidderId).Select(n =>n.BidderId);

Another structure has Notifications and requirement is to filter notifications for which Id is provided in UserNotificationIds

var AllNotifications = _notificationRepos.All(n => n.ExpiresAt > DateTime.UtcNow).ToList();

I m trying the following code to query all Notifications but not getting how to impement "where in" in my expression.

Please help

like image 289
Toubi Avatar asked Feb 14 '23 04:02

Toubi


1 Answers

If it is selecting based off of 1 id

selectAll.where(x => x.id == varId)

If you pass in multiple ids then you need to use .Contains().

selectAll.where(x => idList.contains(x.id))
like image 198
Dassina Avatar answered Feb 18 '23 19:02

Dassina