在Mongodb C＃Driver中聚合$ substr

作者: 庸人自扰1
发布时间: 2025-03-01 11:21:21 (8天前)
转自：

2 条回复

0#
回复此人
部落用户 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 您是否尝试过使用流畅的C＃语法来创建聚合管道？ </p> <pre> <code> var client = new MongoClient(); var database = client.GetDatabase("test"); var collection = database.GetCollection<Central>("dbCENTRAL"); var filter = Builders<Central>.Filter.Eq(x => x.PartnerId, "2021") & Builders<Central>.Filter.Gte(x => x.DATAINST, "2018-01-01 00:00:00") & Builders<Central>.Filter.Lte(x => x.DATAINST, "2019-03-12 23:59:59"); var listAsync = await collection.Aggregate() .Match(filter) .Group(central => central.DATAINST.Substring(0, 10), g => new { Id = g.Key, Count = g.Count()}) .ToListAsync(); </code> </pre> </DIV>

编辑

登录后才能参与评论