C# 构建Mongodb过滤条件

1

2

3

4

5

FilterDefinition<Test> filterDefinition = filterDefinitionBuilder.And(

                    filterDefinitionBuilder.Eq(r => r.a, 11),

                    filterDefinitionBuilder.Eq(r => r.b, 22),

                    filterDefinitionBuilder.ElemMatch(r => r.clist,

                        r => riqi == '2020-10-2'));

1

2

3

4

5

6

7

8

FilterDefinitionBuilder<BsonDocument> filterDefinitionBuilder = new FilterDefinitionBuilder<BsonDocument>();

                FieldDefinition<BsonDocument> fieldDefinition = "clist";

                FilterDefinitionBuilder<BsonDocument> filterDefinitionZiBuilder = new FilterDefinitionBuilder<BsonDocument>();

                FilterDefinition<BsonDocument> filterDefinition = filterDefinitionBuilder.And(

                    filterDefinitionBuilder.Eq("a", 11),

                    filterDefinitionBuilder.Eq("b", 22),

                    filterDefinitionBuilder.ElemMatch(fieldDefinition, filterDefinitionZiBuilder.Eq("riqi", "2020-10-2")));

1

FilterDefinition<BsonDocument> filter = @"{""a"":11,""b"":22,""clist"": { ""$elemMatch"": { ""riqi"": ""2020-10-2""} } }";