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 Tab ...
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) |
