只返回某些列

Question

因为有人告诉我，我需要一个新的问题：

我有这个疑问来自这个问题（Ranking Search Results With LINQ/.NET MVC）：

var results = db.People 
.Join(db.Menu, p => p.ID, m => m.PersonID, (p, m) => new { p = p, m = m }) 
.Join(db.Domain, m => m.m.DomainID, d => d.ID, (m, d) => new { m = m, d = d }) 
.Select(d => new 
     { 
      rank = searchTermArray.Any(x => d.m.p.p.Name.Contains(x)) ? 3 : searchTermArray.Any(x => d.m.p.p.Biography.Contains(x)) ? 2 : searchTermArray.Any(x => d.d.domain.Contains(x)) ? 1 : 0, 
      m = d 
     }) 
.Where(a => a.rank > 0) 
.OrderByDescending(a => a.rank) 
.Select(a => a.m).Distinct(); 

我需要返回的排名只是在某些来自db.People的列。我怎么做？

Answer 1

，正如你在查询做，新{...}这样的：

var results = db.People 
    .Join(db.Menu, p => p.ID, m => m.PersonID, (p, m) => new { p = p, m = m }) 
    .Join(db.Domain, m => m.m.DomainID, d => d.ID, (m, d) => new { m = m, d = d }) 
    .Select(d => new 
    { 
     rank = searchTermArray.Any(x => d.m.p.p.Name.Contains(x)) ? 3 : searchTermArray.Any(x => d.m.p.p.Biography.Contains(x)) ? 2 : searchTermArray.Any (x => d.d.domain.Contains(x)) ? 1 : 0, 
     m = d 
    }) 
    .Where(a => a.rank > 0) 
    .OrderByDescending(a => a.rank) 
    .Select(a => new { 
    column1 = a.column1, 
    column2 = a.column2 
    .... 
    }).Distinct();