var user = await context.Customers
                .Include(x => x.CustomerPreferences)
                .ThenInclude(up => up.CustomerNations)
                .Where(x => x.Id == userId).FirstOrDefaultAsync(cancellationToken);

客户国家实体具有

public Customer Customer { get; set; } = null!;
public virtual IList<CustomerNation> CustomerNations { get; set; } = new List<CustomerNation>();

我在CustomerNation表中没有记录，但是根据此代码，CustomerNations中有一条记录，当我在调试过程中观察时，Result视图显示0个结果。

var preferences= user.preferences
                .ToList();

if (preferences.Any())
{
    var customerNations= user.CustomerPreferences
        .Select(x => x.CustomerNations);

    if (customerNations.Count() != 0) //Both, Any() and Count shows there is one record. I check dropdown and Result view has 0 results.
    {
        foreach (var nation in customerNations)
        {
            context.Remove(counterParty);
        }
    }
}

计数为1，但结果视图显示

不同