c# - 为什么 distinct in LINQ 不适用于这种情况？

Question

我的对象Tenant有这个比较器

public class TenantComparer : IEqualityComparer<Tenant>
{
    // Products are equal if their names and product numbers are equal.
    public bool Equals(Tenant x, Tenant y)
    {

        //Check whether the compared objects reference the same data.
        if (Object.ReferenceEquals(x, y)) return true;

        //Check whether any of the compared objects is null.
        if (Object.ReferenceEquals(x, null) || Object.ReferenceEquals(y, null))
            return false;

        //Check whether the products' properties are equal.
        return x.Name == y.Name;
    }

    // If Equals() returns true for a pair of objects 
    // then GetHashCode() must return the same value for these objects.

    public int GetHashCode(Tenant tenant)
    {
        //Check whether the object is null
        if (Object.ReferenceEquals(tenant, null)) return 0;

        //Get hash code for the Name field if it is not null.
        int hashProductName = tenant.Name == null ? 0 : tenant.Name.GetHashCode();

        //Calculate the hash code for the product.
        return hashProductName;
    }
}

现在，我有一张 table ，上面有一些租户，其中一些租户同名。我想按名称获取那些不同的顺序:

public static List<Tenant> GetTenantListOrderyByNameASC()
{
    DataClassesDataContext db = new DataClassesDataContext();
    var tenantsList = (from t in db.Tenants
                       select t).Distinct().OrderBy( x => x.Name ).ToList();

    return tenantsList;
}

但是还是显示同名的租户...

你能告诉我哪里错了吗？

Answer 1

您需要明确提供比较器，目前您不需要:

var tenantsList = (from t in db.Tenants
                   select t)
    .Distinct(new TenantComparer())
    .OrderBy( x => x.Name )
    .ToList();

参见 documentation .