LINQ Group By Count for Many to Many(LINQ Group By Count for Many to Many)

 我有2个实体，有1对多的关系，我打算把它切换成多对多，但我需要帮助进行分组和计数。 
 
 SearchString - >许多JobResults 
 
 SearchSting用于查找作业结果，作业结果存储为SearchString的集合属性： 
 
public class SearchString
{
    public int SearchStringId { get; set; }
    public string SearchStringName { get; set; }
    public string query { get; set; }
    public JobFunction JobFunction { get; set; }
    public JobSeniority JobSeniority { get; set; }
    public virtual ICollection<JobSearchResult> results { get; set; }
}
public class JobSearchResult
{        
    public int JobSearchResultId { get; set; }
    public string jobtitle { get; set; }
    public string company { get; set; }
    public virtual SearchString SearchString { get; set; }
}
 
 我得到了所有工作结果的前5个JobFunction，如下所示： 
 
var top5jobfunctions = JobSearchResults.Where(a => (a.SearchString != null)).
            GroupBy(s => new { s.SearchString.JobFunction.JobFunctionId, s.SearchString.JobFunction.JobFunctionName }).
            Select(g => new { value = g.Key.JobFunctionId, displayname = g.Key.JobFunctionName, count = g.Count() }).
            OrderByDescending(x => x.count).
            Take(5).ToList();
 
 我打算把它切换成多对多： 
 
public class SearchString
{
    public int SearchStringId { get; set; }
    public string SearchStringName { get; set; }
    public string query { get; set; }
    public JobFunction JobFunction { get; set; }
    public JobSeniority JobSeniority { get; set; }
    public virtual ICollection<JobSearchResult> results { get; set; }
}
public class JobSearchResult
{        
    public int JobSearchResultId { get; set; }
    public string jobtitle { get; set; }
    public string company { get; set; }
    public virtual ICollection<SearchString> SearchStrings { get; set; }
}
 
 一旦将其切换为多对多，我如何才能获得前5个作业功能？ 
 
 我选择正确方法的结构是什么？ 例如，我想知道是否有一个搜索结果的子集合可能不是最好的方法，也许我应该让SearchStrings成为JobResult的集合属性。 

I have 2 entities, with a 1 to many relationship, and I'm going to switch it to many to many but I need help with grouping and counts.
 
SearchString -> many JobResults
 
A SearchSting is used to find job results and job results are stored as a collection property of SearchString:
 
public class SearchString
{
    public int SearchStringId { get; set; }
    public string SearchStringName { get; set; }
    public string query { get; set; }
    public JobFunction JobFunction { get; set; }
    public JobSeniority JobSeniority { get; set; }
    public virtual ICollection<JobSearchResult> results { get; set; }
}
public class JobSearchResult
{        
    public int JobSearchResultId { get; set; }
    public string jobtitle { get; set; }
    public string company { get; set; }
    public virtual SearchString SearchString { get; set; }
}
 
I get the top 5 JobFunctions of all job results as follows:
 
var top5jobfunctions = JobSearchResults.Where(a => (a.SearchString != null)).
            GroupBy(s => new { s.SearchString.JobFunction.JobFunctionId, s.SearchString.JobFunction.JobFunctionName }).
            Select(g => new { value = g.Key.JobFunctionId, displayname = g.Key.JobFunctionName, count = g.Count() }).
            OrderByDescending(x => x.count).
            Take(5).ToList();
 
I'm going to switch it to many to many as such:
 
public class SearchString
{
    public int SearchStringId { get; set; }
    public string SearchStringName { get; set; }
    public string query { get; set; }
    public JobFunction JobFunction { get; set; }
    public JobSeniority JobSeniority { get; set; }
    public virtual ICollection<JobSearchResult> results { get; set; }
}
public class JobSearchResult
{        
    public int JobSearchResultId { get; set; }
    public string jobtitle { get; set; }
    public string company { get; set; }
    public virtual ICollection<SearchString> SearchStrings { get; set; }
}
 
How do I get my top 5 jobfunctions counts once I switch it to many to many?
 
Also, is the structure I chose the right approach? For example I wonder if having jobresults a child collection of SearchString was maybe not the best way to go and that perhaps I should just have SearchStrings be a collection property of JobResult.

原文：https://stackoverflow.com/questions/40326141