filter data between a date range MongoDB with C#

Question

Hi I am working on a function where I have to get the data in a file according to the ID and the Start and End date.

This is what I wrote so far.

In controller

[HttpGet]
[Route("searchLogs")]
public async Task SearchLogs([FromBody] List logs)
{
    var response = await logProvider.SearchLogs(logs);
    return Ok(response);
}

In model class

public class Logs
{
    public DateTime Date{get; set;}
    public string Id {get; set;}
}

Can someone help me?

user_7834019 · Answer

db is type of IMongoDbContext

startDate and endDate is DateTime

 var q =  db.GetCollection().Find(x => x.Date >= startDate.Date &&  x.Date <= endDate.date).ToList();

filter data between a date range MongoDB with C#

1 Answers