namespace ConsoleApplication
|
{
|
public class C
|
{
|
public int Id { get; set; }
|
public string S { get; set; }
|
}
|
|
public class Program
|
{
|
public static void Main()
|
{
|
var client = new MongoClient("mongodb://localhost");
|
var database = client.GetDatabase("test");
|
var collection = database.GetCollection<C>("test");
|
|
database.DropCollection("test");
|
collection.InsertOne(new C { Id = 1, S = "Tom" });
|
collection.InsertOne(new C { Id = 2, S = "tom" });
|
collection.InsertOne(new C { Id = 3, S = "Mary" });
|
|
var collation = new Collation("en_US", strength: CollationStrength.Secondary);
|
var aggregateOptions = new AggregateOptions { Collation = collation };
|
var query = collection
|
.AsQueryable(aggregateOptions)
|
.Where(x => x.S == "tom");
|
var result = query.ToList();
|
}
|
}
|
}
|