- MapId:
BsonClassMap.RegisterClassMap<NetWorth>(cm =>
{
cm.AutoMap()
cm.MapIdField(n => n.TradingDay)
})
- Find
var b = Builders<NetWorth>.Filter
var filter = b.Gte("_id", begin) & b.Lte("_id", end)
var sort = Builders<NetWorth>.Sort.Ascending("_id")
vt = col.Find(filter).Sort(sort).ToList()
- Projection
var b = Builders<NetWorth>.Filter
var filter = b.Gte("_id", begin) & b.Lte("_id", end)
var sort = Builders<NetWorth>.Sort.Ascending("_id")
var p = Builders<NetWorth>.Projection.Include("_id")
vtBsonDocument = col.Find(filter).Project(p).Sort(sort).ToList()
vtId = col.Find(filter).Project(x=>x._id).Sort(sort).Limit(1).ToList()