使用And and Or子句在c#中创建Mongodb查询

using MongoDB.Driver;

// 创建MongoDB客户端
var client = new MongoClient("mongodb://localhost:27017");

// 获取数据库
var database = client.GetDatabase("mydatabase");

// 获取集合
var collection = database.GetCollection<BsonDocument>("mycollection");

// 创建查询条件
var filterBuilder = Builders<BsonDocument>.Filter;
var filter = filterBuilder.And(
    filterBuilder.Eq("field1", value1),
    filterBuilder.Or(
        filterBuilder.Eq("field2", value2),
        filterBuilder.Eq("field3", value3)
    )
);

// 执行查询
var result = collection.Find(filter).ToList();