将简单的SQL分组转换为LINQ to SQL

SELECT Category, COUNT(*)
FROM Products
GROUP BY Category

var query = from p in db.Products
            group p by p.Category into g
            select new { Category = g.Key, Count = g.Count() };

using System;
using System.Linq;
using System.Data.Linq;

class Program
{
    static void Main(string[] args)
    {
        DataContext db = new DataContext("connectionString");

        var query = from p in db.Products
                    group p by p.Category into g
                    select new { Category = g.Key, Count = g.Count() };

        foreach (var item in query)
        {
            Console.WriteLine("Category: {0}, Count: {1}", item.Category, item.Count);
        }

        Console.ReadKey();
    }
}