8,497
社区成员
发帖
与我相关
我的任务
分享
var orders = from ord in ctx.Orders
where ord.OrderDate.Value.Year == ord.RequiredDate.Value.Year
&& ord.OrderDate.Value.Month == ord.RequiredDate.Value.Month
&& ord.OrderDate.Value.Day < ord.RequiredDate.Value.Day - 1
var query = "SELECT VALUE O FROM NORTHWNDEntities.Orders AS O WHERE SqlServer.DATEDIFF('DAY', O.RequiredDate, O.OrderDate) < 1";
ctx.Connection.Open();
var orders = new ObjectQuery<Order>(query, ctx);
foreach (var o in orders)
Console.WriteLine(o.OrderID);
(年-2000)×384 + 月×32 + 日