8,497
社区成员
发帖
与我相关
我的任务
分享
public class DataRowComparer : IEqualityComparer<Company>
{
public bool Equals(Company t1, Company t2)
{
return (t1.UserId == t2.UserId
&& t1.CompanyName == t2.CompanyName
&& t1.Jobs==t2.Jobs);
}
public int GetHashCode(Company t)
{
return t.ToString().GetHashCode();
}
}
var query = (from j in db.Job
join c in db.Company on j.UserId equals c.UserId
into cj
from c in cj.DefaultIfEmpty()
select new Company
{
UserId = b.UserId,
CompanyName = b.CompanyName,
Jobs = b.Jobs.ToList()
}).Distinct(new DataRowComparer());