LINQ to SQL的只是时间比较 [英] Linq To Sql compare Time only

问题描述

我如何没有得到以下

错误只比较的DateTime对象时间：

 System.NotSupportedException类型的异常出现在mscorlib.dll但在用户代码的其他信息没有处理：'的TimeOfDay'不是在LINQ支持实体指定类型的成员。只有初始化，实体成员和实体导航属性都支持。 
  

我的代码：

  VAR日期= DateTime.Parse（query.DueTime）; 
实体= entities.Where（R = GT; r.DueTime.TimeOfDay.Equals（date.TimeOfDay））; 
  

解决方案

这就是答案！

  VAR日期= DateTime.Parse（query.DueTime）; 
实体= entities.Where（R = GT; DbFunctions.CreateTime（r.DueTime.Hour，r.DueTime.Minute，r.DueTime.Second）== DbFunctions.CreateTime（date.Hour，date.Minute， date.Second））; 
  

How do I compare time only of DateTime Object without getting the following

Error:

An exception of type 'System.NotSupportedException' occurred in mscorlib.dll but was not handled in user code Additional information: The specified type member 'TimeOfDay' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

My code:

var date = DateTime.Parse(query.DueTime);
entities = entities.Where(r => r.DueTime.TimeOfDay.Equals(date.TimeOfDay));

解决方案

This is the answer!

var date = DateTime.Parse(query.DueTime);
entities = entities.Where(r => DbFunctions.CreateTime(r.DueTime.Hour, r.DueTime.Minute,  r.DueTime.Second) == DbFunctions.CreateTime(date.Hour, date.Minute, date.Second));

这篇关于LINQ to SQL的只是时间比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！