字符串截取日期linqEFlambda⽐较字符串⽇期时间⼤⼩在使⽤EF时，想要⽐较字符串类型的⽇期时，参考以下：
SQL语句：
1 2 3 41）select*　from TableName where StartTime > '2015-04-08' 2）select*　from TableName where StartTime >= '2015-04-08' 3）select*　from TableName where StartTime < '2015-04-08' 4）select*　from TableName where StartTime <= '2015-04-08'
lambda表达式写法：
1 2 3 41）.Where(a => a.StartTime.CompareTo('2015-04-08') > 0) 2）.Where(a => a.StartTime.CompareTo('2015-04-08') >= 0) 3）.Where(a => a.StartTime.CompareTo('2015-04-08') < 0) 4）.Where(a => a.StartTime.CompareTo('2015-04-08') <= 0)
更规范的写法：
1 2 3 41）.Where(a => String.Compare(a.StartTime, '2015-04-08', StringComparison.Ordinal) > 0) 2）.Where(a => String.Compare(a.StartTime, '2015-04-08', StringComparison.Ordinal) >= 0) 3）.Where(a => String.Compare(a.StartTime, '2015-04-08', StringComparison.Ordinal) < 0) 4）.Where(a => String.Compare(a.StartTime, '2015-04-08', StringComparison.Ordinal) <= 0)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。