public class ScheduledEvent : Event
{
public DateTimeOffset StartDateTime { get; set; }
}
StartDateTime = 5/27/2013 2:09:00 AM +00:00 表示 05/26/2013 07:09 PM PST。
MongoDB中记录的内容为:
db.ScheduledEvent.find().toArray()[
{
"_id": BinData(3, "ZE2p31dh00qb6kglsgHgAA=="),
"Title": "Today 26th at 7:09pm",
"Length": "00:00:00",
"MoreInformation": "http://1.com",
"Speakers": [{
"_id": BinData(3, "ndzESsQGukmYGmMgKK0EqQ=="),
"Name": "Mathias Brandewinder"
}
],
"Location": {
"_id": BinData(3, "AAAAAAAAAAAAAAAAAAAAAA=="),
"Name": "Somwhere "
},
"Organizers": [{
"_id": BinData(3, "AAAAAAAAAAAAAAAAAAAAAA=="),
"Name": null
}],
"CreatedOn": [
NumberLong("635052144104050898"),
0
],
"StartDateTime": [
NumberLong("635052173400000000"),
0
]
}
]
我意识到在MongoDB中StartDateTime被存储为Ticks。
var dateMarker = DateTimeOffset.UtcNow;
var nextDay = dateMarker.AddDays(1);
这个查询不起作用:
var today = EventRepoistory
.All()
.Where(z => z.StartDateTime >= dateMarker
&& z.StartDateTime < nextDay)
.OrderByDescending(z => z.StartDateTime)
.ToList();
我已经在Mongo C#驱动程序中添加了一个查询显示器,显示以下查询:
{ "$query" : { "StartDateTime" : { "$gte" : [NumberLong("635052168609734070"), 0], "$lt" : [NumberLong("635053032609734070"), 0] } }, "$orderby" : { "StartDateTime" : -1 } }
下限 = 6350521 68609734070
服务器 = 6350521 73400000000
上限 = 6350530 32609734070
问题: 为什么这个 MongoDB 查询不返回任何结果?
db.ScheduledEvent.find({
"$query": {
"StartDateTime": {
"$gte": [NumberLong("635052168609734070"), 0],
"$lt": [NumberLong("635053032609734070"), 0]
}
},
"$orderby": {
"StartDateTime": -1
}
})
我研究了这个话题,发现了这个解决方案:MongoDB和DateTimeOffset类型
但是LINQ提供程序是否正在执行其应该执行的操作?
我还尝试过以下代码:
db.ScheduledEvent.find({
"StartDateTime": {
"$gte": [NumberLong("1"), 0]
}
})
但它没有返回任何结果。