c# - 带有 MongoDB .NET 驱动程序的 Azure DocumentDB : how to set id manually?

Question

我想更新插入 json 文档，如下代码；

string CollectionName = "Collection";

MongoClientSettings settings = MongoClientSettings.FromUrl(
  new MongoUrl(MongoDbConnectionString)
);
settings.SslSettings =
  new SslSettings() { EnabledSslProtocols = SslProtocols.Tls12 };
var mongoClient = new MongoClient(settings);
var db = mongoClient.GetDatabase(MongoDbDatabaseName);

var collection = db.GetCollection<BsonDocument>(CollectionName);

// id that I want to set.
var id = Guid.NewGuid().ToString();
var _id = Guid.NewGuid().ToString();

JObject jObject = new JObject(
    new JProperty("id", id), // Id test 1
    new JProperty("_id", _id), // Id test 2
    new JProperty("property1", "value1"),
    new JProperty("property2", "value2"));

BsonDocument newDoc = BsonDocument.Parse(jObject.ToString());

// upsert reference: http://stackoverflow.com/q/7240028/361100
var result = collection.ReplaceOne(
    filter: new BsonDocument("id", jObject["id"].Value<string>()),
    options: new UpdateOptions { IsUpsert = true },
    replacement: newDoc);

id是我想手动设置的值，但结果如下；

{
  "$id": "0106669b-9670-4547-a2a3-f7ea800fac0d", // Id test 1
  "_id": "9eb71b3e-83be-4dd9-b037-269d59cbe5e4", // Id test 2
  "id": "9a0a4b90-5be7-44b7-af05-e3bbe08dc25e", // system generated
  "property1": "value1",
  "property2": "value2",
  "_rid": "I2ECAKbBewAEAAAAAAAAAA==",
  "_self": "dbs/I2ECAA==/colls/I2ECAKbBewA=/docs/I2ECAKbBewAEAAAAAAAAAA==/",
  "_etag": "\"0000d277-0000-0000-0000-590c557a0000\"",
  "_attachments": "attachments/",
  "_ts": 1493980531
}

我的id值被放置在$id属性中，这不是我所期望的，文档中的属性id是由系统生成的.

注意我测试了 id 和 _id，但它们都没有设置为 DocumentDB "id"。

DocumentDB .NET 库允许我自己设置 id(如果我只输入属性名称 id)。如何使用 MongoDB .NET 驱动程序做到这一点？

Answer 1

在 MongoDB 中，文档的 id 是“_id”而不是“id”。为了获得预期的行为，您需要添加一个名称==“_id”的新 JProperty。

JObject jObject = new JObject(
    new JProperty("_id", id),
    new JProperty("id", id),
    new JProperty("property1", "value1"),
    new JProperty("property2", "value2"));

https://docs.mongodb.com/manual/reference/method/db.collection.insert/#insert-a-document-specifying-an-id-field