SQL Query convert to LINQ

Question

I have SQL Query

SELECT project_id,count(project_id) as vote_count from Votesgroup by project_id;

And how i can write this with LINQ? My LINQ starting code:

 private int GetCountOfVotes()
    {
        using (var db = new SafetyFundDbContext(Options))
        {

            return db.Votes.Select()

        }          
    }

Sorry, Yes I know question is so stupid, but Im newbie :D .

Answer 1

Don't vote and mark as correct answer.

foreach(var vote in  db.Votes.GroupBy(vot => vot.project_id)
                    .Select(group => new { 
                         ProjectID = group.Key, 
                         Count = group.Count() 
                    })
                    .OrderBy(x => x.ProjectID)
{
    Console.WriteLine("{0} : {1}", vote.ProjectID, vote.Count);
}