C# Mongodb 多个对象数组文档的笛卡尔积

# 利用C#和MongoDB实现多个对象数组文档的笛卡尔积

csharp
using MongoDB.Driver;
using System;
using System.Collections.Generic;
class Program
{
    static void Main()
    {
        // 连接到MongoDB数据库
        var client = new MongoClient("mongodb://localhost:27017");
        var database = client.GetDatabase("YourDatabaseName");
        // 获取要进行笛卡尔积的集合
        var collection1 = database.GetCollection("Collection1");
        var collection2 = database.GetCollection("Collection2");
        // 执行笛卡尔积
        var cartesianProduct = CartesianProduct(collection1, collection2);
        // 输出结果
        foreach (var document in cartesianProduct)
        {
            Console.WriteLine(document.ToJson());
        }
    }
    static IEnumerable CartesianProduct(IMongoCollection collection1, IMongoCollection collection2)
    {
        var query = from doc1 in collection1.AsQueryable()
                    from doc2 in collection2.AsQueryable()
                    select new BsonDocument { { "result", new BsonArray { doc1, doc2 } } };
        return query.ToList();
    }
}

csharp
var client = new MongoClient("mongodb://localhost:27017");
var database = client.GetDatabase("YourDatabaseName");

csharp
var collection1 = database.GetCollection("Collection1");
var collection2 = database.GetCollection("Collection2");

csharp
var cartesianProduct = CartesianProduct(collection1, collection2);

csharp
foreach (var document in cartesianProduct)
{
    Console.WriteLine(document.ToJson());
}