A quick tip about how to compare a datetime field in our database and to be extact only the Date part ignoring the time. Let’s say that we want to find all records that where created today: Where(@"Day(it.CreatedTime) == Day(CurrentDateTime()) AND...