19
public class ScheduledEvent : Event
{
public DateTimeOffset StartDateTime { get; set; }
}
StartDateTime = 5/27/2013 2:09:00 AM +00:00 representing 05/26/2013 07:09 PM PST
What's recorded in 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
]
}
]
I realize that StartDateTime is stored as Ticks in MongoDB.
var dateMarker = DateTimeOffset.UtcNow;
var nextDay = dateMarker.AddDays(1);
This query does not work:
var today = EventRepoistory
.All()
.Where(z => z.StartDateTime >= dateMarker
&& z.StartDateTime < nextDay)
.OrderByDescending(z => z.StartDateTime)
.ToList();
I have added a query display to the Mongo C# driver which shows the following query:
{ "$query" : { "StartDateTime" : { "$gte" : [NumberLong("635052168609734070"), 0], &quo