EF Core conditional Include on parameter

November 14, 2023

I have a question about that if is it possible to include a navigation property only when it is needed.

void FetchUser(bool includePhoneNumbers, bool includeAddresses)
{
}

How can I include these properties only when the related parameter is true?

Thank you.

>Solution :

Try something like:

void FetchUser(bool includePhoneNumbers, bool includeAddresses)
{
    var query = dbContext.Users.AsQueryable();
    
    if (includePhoneNumbers)
    {
        query = query.Include(u => u.PhoneNumbers);
    }
    
    if (includeAddresses)
    {
        query = query.Include(u => u.Addresses);
    }
    
    var users = query.ToList();
}