//4c2. UpdateOne row document, nhưng thay đổi nhiều column
public string DocumentFind_UpdateOne2(int student_id= 10000, int score=85)
{
// Replace the uri string with your MongoDB deployment's connection string.
var client = new MongoClient(
"mongodb://localhost:27017/?readPreference=primary&appname=MongoDB%20Compass&directConnection=true&ssl=false"
);
string re = "";
//lấy database
var database = client.GetDatabase("HvDadabase");
//Lấy List Collection
var collection = database.GetCollection<BsonDocument>("HvCars");
//select find arrayFilter
var arrayFilter = Builders<BsonDocument>.Filter.Eq("student_id", 10000) & Builders<BsonDocument>
.Filter.Eq("scores.type", "quiz");
re = "dữ liệu trước khi update : <br/> ";
var documentList = collection.Find(arrayFilter).ToList();
foreach (var row in documentList)
{
re += row + "<br/>";
}
//nội dung sẽ update arrayUpdate
var arrayUpdate = Builders<BsonDocument>.Update.Set("scores.$.score", score);
//Update 1 row tìm thấy dầu tiên
collection.UpdateOne(arrayFilter, arrayUpdate);
re += "<br/> dữ liệu sau khi update : <br/> ";
documentList = collection.Find(arrayFilter).ToList();
foreach (var row in documentList)
{
re += row + "<br/>";
}
return re;
}
0 Nhận xét