Linq to SQL获取按日期分组的不同记录

using System;
using System.Linq;

// 创建Linq to SQL上下文
var dbContext = new YourDbContext();

// 查询按日期分组的不同记录
var result = dbContext.YourTable
    .GroupBy(x => x.Date)
    .Select(g => new
    {
        Date = g.Key,
        Records = g.ToList()
    })
    .ToList();

// 遍历结果并输出
foreach (var group in result)
{
    Console.WriteLine($"日期: {group.Date}");
    foreach (var record in group.Records)
    {
        Console.WriteLine($"记录: {record}");
    }
    Console.WriteLine();
}