MongoDb Query using C# for date time

Question

I am working on MongoDb using C# drivers. I want query the mongoDb database to find out the row which has EventDate is greater than 13 months from todays date.

my MongoDb has structure something similar to below:

EventDate is of datatype : DateTime

{
   "_id" : ObjectId("525239e3e9374f1c3ce4123b"),
   "RowId" : 41133552,
   "EventDate" : ISODate("2013-08-19T00:00:28Z"),
   "Product" : "supporttool",
   "Language" : "en",
   "GUID" : "67cd73d4-36bc-4c9f-9a4c-144b38d4e928",
}

Please can anyone help me out to get the MongoCollection for data with event date older than 13 months.

mnemosyn · Accepted Answer · 2013-10-07 08:28:15Z

4

There's more than one way to it, but this would be the one with LINQ extension method syntax:

MongoDatabase db = YourMongoDatabaseObject;
var cursor = db.GetCollection<YourClass>("yourClass").Find(
   Query<YourClass>.LT(p => p.EventDate, DateTime.UtcNow.AddMonths(-13));

This will return a cursor to all documents in the "yourClass" collection that have an an EventDate less than 13 months ago and will deserialize them as instances of YourClass.

answered Oct 7, 2013 at 8:28

mnemosyn

46.4k6 gold badges80 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

AMIT SHELKE Over a year ago

Thanks for the query. I am trying to delete those record which I got in above query. PLEASE CAN UPDATE YOUR ANSWER.

mnemosyn Over a year ago

to remove records, just change Find to Remove

MA9H Over a year ago

could you explain to me what the 'p' is?? I'm still new to mongo and linq

mnemosyn Over a year ago

@M009: Yes, but not in a comment to a one year old question. Please create a new question for it.

Peter O. · Accepted Answer · 2014-08-13 21:01:39Z

0

DateTime.UtcNow.AddMonths(-13) is a good example and works perfect.

edited Aug 13, 2014 at 21:01

Peter O.

33.1k14 gold badges86 silver badges97 bronze badges

answered Aug 13, 2014 at 20:24

Bids

32 bronze badges

Collectives™ on Stack Overflow

MongoDb Query using C# for date time

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related