仅适用于SQL linq的C#日期

using (var context = new YourDataContext())
{
    var results = from order in context.Orders
                  where order.OrderDate == new DateTime(2023, 1, 1)
                  select order;
}

var startDate = new DateTime(2023, 1, 1);
var endDate = new DateTime(2023, 12, 31);

var resultsInRange = from order in context.Orders
                     where order.OrderDate >= startDate && order.OrderDate <= endDate
                     select order;

var ordersThisYear = context.Orders
                            .Where(order => order.OrderDate.Year == DateTime.Now.Year);

var results = context.Orders
                     .Where(order => DbFunctions.TruncateTime(order.OrderDate) == DbFunctions.TruncateTime(new DateTime(2023, 1, 1)));

var utcNow = DateTime.UtcNow;
var ordersToday = context.Orders
                         .Where(order => DbFunctions.TruncateTime(order.OrderDate.ToUniversalTime()) == DbFunctions.TruncateTime(utcNow));