MongoDB のクエリ - .NET SDK

public partial class Plant : IRealmObject
{
    [BsonElement("_id")]
    public ObjectId Id { get; set; } = ObjectId.GenerateNewId();
    [BsonElement("name")]
    public string? Name { get; set; }
    [BsonElement("sunlight")]
    [BsonRepresentation(BsonType.String)]
    public string? Sunlight { get; set; }
    [BsonElement("color")]
    [BsonRepresentation(BsonType.String)]
    public string? Color { get; set; }
    [BsonElement("type")]
    [BsonRepresentation(BsonType.String)]
    public string? Type { get; set; }
    [BsonElement("_partition")]
    public string? Partition { get; set; }
}
public enum Sunlight
{
    Full,
    Partial
}
public enum PlantColor
{
    White,
    Green,
    Yellow,
    Purple
}
public enum PlantType
{
    Perennial,
    Annual
}

var plant = new Plant
{
    Name = "Venus Flytrap",
    Sunlight = Sunlight.Full.ToString(),
    Color = PlantColor.White.ToString(),
    Type = PlantType.Perennial.ToString(),
    Partition = "Store 42"
};
var insertResult = await plantsCollection.InsertOneAsync(plant);
var newId = insertResult.InsertedId;

var sweetBasil = new Plant
{
    Name = "Sweet Basil",
    Sunlight = Sunlight.Partial.ToString(),
    Color = PlantColor.Green.ToString(),
    Type = PlantType.Annual.ToString(),
    Partition = "Store 42"
};
var thaiBasil = new Plant
{
    Name = "Thai Basil",
    Sunlight = Sunlight.Partial.ToString(),
    Color = PlantColor.Green.ToString(),
    Type = PlantType.Perennial.ToString(),
    Partition = "Store 42"
};
var helianthus = new Plant
{
    Name = "Helianthus",
    Sunlight = Sunlight.Full.ToString(),
    Color = PlantColor.Yellow.ToString(),
    Type = PlantType.Annual.ToString(),
    Partition = "Store 42"
};
var petunia = new Plant
{
    Name = "Petunia",
    Sunlight = Sunlight.Full.ToString(),
    Color = PlantColor.Purple.ToString(),
    Type = PlantType.Annual.ToString(),
    Partition = "Store 47"
};
var listofPlants = new List<Plant>
{
    sweetBasil,
    thaiBasil,
    helianthus,
    petunia
};
var insertResult = await plantsCollection.InsertManyAsync(listofPlants);
var newIds = insertResult.InsertedIds;

var petunia = await plantsCollection.FindOneAsync(
   new { name = "Petunia" },
   null);

var allPerennials = await plantsCollection.FindAsync(
    new { type = PlantType.Perennial.ToString() },
    new { name = 1 });

var allPlants = await plantsCollection.CountAsync();

var updateResult = await plantsCollection.UpdateOneAsync(
    new { name = "Petunia" },
    new BsonDocument("$set", new BsonDocument("sunlight", Sunlight.Partial.ToString()))
    );

var filter = new { _partition = "Store 47" };
var updateDoc = new BsonDocument("$set",
    new BsonDocument("_partition", "Area 51"));
var updateResult = await plantsCollection.UpdateManyAsync(
    filter, updateDoc);

var filter = new BsonDocument()
    .Add("name", "Pothos")
    .Add("type", PlantType.Perennial.ToString())
    .Add("sunlight", Sunlight.Full.ToString());
var updateResult = await plantsCollection.UpdateOneAsync(
    filter,
    new BsonDocument("$set", new BsonDocument("_partition", "Store 42")),
    upsert: true);
/* The upsert will create the following object:
{
   "name": "pothos",
   "sunlight": "full",
   "type": "perennial",
   "_partition": "Store 42"
}
*/

var filter = new BsonDocument("name", "Thai Basil");
var deleteResult = await plantsCollection.DeleteOneAsync(filter);

var filter = new BsonDocument("type", PlantType.Annual);
var deleteResult = await plantsCollection.DeleteManyAsync(filter);

var groupStage =
    new BsonDocument("$group",
        new BsonDocument
        {
            { "_id", "$type" },
            { "count", new BsonDocument("$sum", 1) }
        });
var sortStage = new BsonDocument("$sort",
    new BsonDocument("_id", 1));
var aggResult = await plantsCollection.AggregateAsync(groupStage, sortStage);
foreach (var item in aggResult)
{
    var id = item["_id"];
    var count = item["count"];
    Console.WriteLine($"Plant type: {id}; count: {count}");
}

var groupStep = BsonDocument.Parse(@"
  {
    $group: {
      _id: '$type', 
      count: {
        $sum: 1
      }
    }
  }
");
var sortStep = BsonDocument.Parse("{$sort: { _id: 1}}");
aggResult = await plantsCollection.AggregateAsync(groupStep, sortStep);
foreach (var item in aggResult)
{
    var id = item["_id"];
    var count = item["count"];
    Console.WriteLine($"Id: {id}, Count: {count}");
}

var matchStage = new BsonDocument("$match",
        new BsonDocument("type",
            new BsonDocument("$eq",
                PlantType.Perennial)));
// Alternate approach using BsonDocument.Parse(...)
matchStage = BsonDocument.Parse(@"{
  $match: {
    type: { $eq: '" + PlantType.Perennial + @"' }
  }}");
var sortStage = BsonDocument.Parse("{$sort: { _id: 1}}");
var aggResult = await plantsCollection.AggregateAsync<Plant>(matchStage, sortStage);
foreach (var plant in aggResult)
{
    Console.WriteLine($"Plant Name: {plant.Name}, Color: {plant.Color}");
}

var projectStage = new BsonDocument("$project",
    new BsonDocument
    {
        { "_id", 0 },
        { "_partition", 1 },
        { "type", 1 },
        { "name", 1 },
        { "storeNumber",
            new BsonDocument("$arrayElemAt",
                new BsonArray {
                    new BsonDocument("$split",
                    new BsonArray
                    {
                        "$_partition",
                        " "
                    }), 1 }) }
    });
var sortStage = BsonDocument.Parse("{$sort: { storeNumber: 1}}");
var aggResult = await plantsCollection.AggregateAsync(projectStage, sortStage);
foreach (var item in aggResult)
{
    Console.WriteLine($"{item["name"]} is in store #{item["storeNumber"]}.");
}

projectStage = BsonDocument.Parse(@"
    {
      _id:0,
      _partition: 1,
      type: 1,
      name: 1,
      storeNumber: {
        $arrayElemAt: [
          { $split:[
            '$_partition', ' '
            ]
          }, 1 ]
      }
    }");