LINQ/EF/Lambda 比较字符串日期时间大小

在使用EF时，想要比较字符串类型的日期时，参考以下：

SQL语句：

?

1 2 3 4

1）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 4

1）.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 4

1）.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)

本文来自：http://www.itdos.com/CSharp/20150408/0127321.html 转载请保留此链接，谢谢！