How to remove _v and _t from mongo document

Question

I have searched all over and no solution works. Here is how I am inserting data:

string value = db.StringGet("test");
string cleaned = value.Replace("u'", "'").Replace("\"", "");
var jsonDoc = Newtonsoft.Json.JsonConvert.SerializeObject(cleaned);
Dictionary<string, string> dict = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<string, string>>(jsonDoc);
values.Add(dict);

_collection.InsertMany(values.Select(x => x.ToBsonDocument()));

Here is how the data looks in the database

{ 
    "_id" : ObjectId("5aaabf7ac03af44892673031"), 
    "_t" : "MongoDB.Bson.BsonDocument, MongoDB.Bson", 
    "_v" : {
        "profile" : "myprofile", 
        "source" : "thesource", 
        "hostname" : "myhost", 
        "pgm" : "mypgm"
    }
}

I dont want the data formatted like this in mongo. The reason my is because I have several clients accessing the db. I would rather have the data formatted like this:

{ 
    "_id" : ObjectId("5aaabf7ac03af44892673031"), 
    "profile" : "myprofile", 
    "source" : "thesource", 
    "hostname" : "myhost", 
    "pgm" : "mypgm"
}

Maybe you can post complete reproducable example (which can be copy-pasted), because I was not able to reproduce this with similar code. — Evk, Mar 16 '18 at 05:21

score 1 · Answer 1 · answered Aug 28 '19 at 15:25

In our team we solved it by serializing and deserializing the object, making it an ExpandoObject. Try something like this:

    JsonSerializer DynamicDataJsonSerializer;
    DynamicDataJsonSerializer = JsonSerializer.Create(JsonConverterSetup.GetTransparentSerializerSettings());

    MyClass dataToSaveToMogo;
    var dataToSaveToMogoAsDynamic = DynamicDataJsonSerializer.Deserialize<ExpandoObject>(DynamicDataJsonSerializer.Serialize(dataToSaveToMogo));

then save dataToSaveToMogoAsDynamic.

Hope it helps

You haven't mentioned where JsonConverterSetup.GetTransparentSerializerSettings() is coming from! — Amir Hajiha, Jun 28 '23 at 12:38

score 0 · Answer 2 · answered Nov 16 '20 at 13:07

You will need to call the Remove property of the BsonDocument class and specify "_t" as parameter to be able to remove the "_t" key. Same goes with "_v"

        MyClass item = new MyClass();
        var returnDocument = new BsonDocument(item.ToBsonDocument());
        returnDocument.Remove("_t");
        collection.InsertOne(returnDocument);

score 0 · Answer 3 · answered Jan 31 '22 at 09:33

This solution works 100%.

                var bsonDocument = new BsonDocument(userActivityDoc.ToBsonDocument());
                if (bsonDocument.TryGetValue("AdditionalData", out BsonValue additionalData))
                {
                    additionalData.ToBsonDocument().Remove("_t");
                }
                
                await _genericRepository.AddOneAsync(BsonSerializer.Deserialize<UserActivityDoc>(bsonDocument));

score 0 · Answer 4 · answered Jun 11 '22 at 14:17

the finally solution for remove "_t" from all nested values:

 if (bsonDocument.TryGetValue("AdditionalData", out var additionalData) && !additionalData.IsBsonNull)
                    {
                        RemoveAllTObject(additionalData.ToBsonDocument());
                        //additionalData.ToBsonDocument().Remove("_t");
                    }

private void RemoveAllTObject(BsonDocument bsonDocument)
        {
            bsonDocument.Remove("_t");
            foreach (var bsonElement in bsonDocument)
            {
                if (!bsonElement.Value.IsBsonNull)
                {
                    if (bsonElement.Value.GetType() == typeof(BsonArray))
                    {
                        foreach (var bsonValue in bsonElement.Value.AsBsonArray)
                        {
                            if (bsonValue.GetType() == typeof(BsonDocument))
                                RemoveAllTObject(bsonValue.AsBsonDocument);
                        }
                    }

                    if (bsonElement.Value.GetType() == typeof(BsonDocument))
                    {
                        var bDocument = bsonElement.Value.AsBsonDocument;
                        if (bsonDocument.IsBsonNull)
                            continue;
                        if (bDocument.ElementCount > 0)
                        {
                            RemoveAllTObject(bDocument);
                        }
                    }
                }
            }
        }

How to remove _v and _t from mongo document

4 Answers4

Linked