java mongodb tolist_MongoDb c＃driver按字段值查找数组中的项目

这是一个从数组中返回单个复杂项的示例(使用MongoDB.Driver v2.5.0)：

Simple Data Model

public class Zoo

{

public List Animals { get; set; }

}

public class Animal

{

public string Name { get; set; }

}

Option 1 (Aggregation)

public Animal FindAnimalInZoo(string animalName)

{

var zooWithAnimalFilter = Builders.Filter

.ElemMatch(z => z.Animals, a => a.Name == animalName);

return _db.GetCollection("zoos").Aggregate()

.Match(zooWithAnimalFilter)

.Project(

Builders.Projection.Expression(z =>

z.Animals.FirstOrDefault(a => a.Name == animalName)))

.FirstOrDefault(); // or .ToList() to return multiple

}

Option 2 (Filter & Linq) 这对我来说慢了大约5倍

public Animal FindAnimalInZoo(string animalName)

{

// Same as above

var zooWithAnimalFilter = Builders.Filter

.ElemMatch(z => z.Animals, a => a.Name == animalName);

var zooWithAnimal = _db.GetCollection("zoos")

.Find(zooWithAnimalFilter)

.FirstOrDefault();

return zooWithAnimal.Animals.FirstOrDefault(a => a.Name == animalName);

}