EF LINQ select entities where Id is in List

Question

I was trying to select a list of entities using EF and Linq and I should retrieve only those that has a specific AccountId inside the Participants ICollection

public class Conversation
{
    public Conversation()
    {
        Participants = new List<Account>();
        Messages = new List<Message>();
    }

    [Key]
    public Int32 conversationId { get; set; }
    public ICollection<Message> Messages { get; set; }
    public ICollection<Account> Participants { get; set; }
}

_Db is DbContext

public async Task<List<Conversation>> FindByAccountIdAsync(Int32 id)
{
   return await _Db.Conversations.Where(....).ToListAsync(); 
   // .... select conversations where id == AccountId inside ICollection<Account> Participants
}

I have no idea on how to compose the query in LINQ

Answer 1

Use Any:

return await _Db.Conversations
    .Where(c => c.Participants.Any(p => p.Id == id))
    .AsQueryable()
    .ToListAsync();