C
C#•2y ago
BokoGanga

EF Core Querying a List of Rows

Hey devs, I'm trying to optimize a query that checks DB for user with email. I have a list of emails that I need to check if they exist in the table of Users. Is there anyway in EF Core that allows checking by a list instead of looping through it and sending a request for each one? Thank you.
2 Replies
FroH.LVT
FroH.LVT•2y ago
use Contains. Eg: listOfEmails.Contains(x.Email)
BokoGanga
BokoGanga•2y ago
yeah, that worked perfectly. Thanks a lot
Want results from more Discord servers?
Add your server
More Posts
[ASP.NET] Trying to understand the [HttpGet] and [HttpPost] tagsI understand that the tag is used to provide precedence to one action method over another where samCreating a return to page buttonI have a post info page and posts page. Now posts page can have many filters, page number and stuff,azure functions isolated processHi all, This is a niche question, but hoping somebody could enlighten me. So I’m creating an azureASP NET Core 6 Launch without Debugging doesn't block Background Service but Debug DoesHi, I'm trying to have a ASP.NET Core BackgroundService run really in background, i mean really don[ASP.NET] Middleware Stops Controller From Receiving Login RequestThese are my buttons in /Views/Login ``` <form role="search" action="/Login/AddLoginCookie" meth.NET 6 ASP.NET API [Answered]Hello, I am programming a .NET and currently I am using ```using System.ComponentModel.DataAnnotati