MongoDB e C Sharp: tutorial de operações CRUD

1
using MongoDB.Driver;

1
MongoClient dbClient = new MongoClient(<<YOUR ATLAS CONNECTION STRING>>);
2
3
var dbList = dbClient.ListDatabases().ToList();
4
5
Console.WriteLine("The list of databases on this server is: ");
6
foreach (var db in dbList)
7
{
8
    Console.WriteLine(db);
9
}

1
The list of databases on this server is:
2
{ "name" : "sample_airbnb", "sizeOnDisk" : 57466880.0, "empty" : false }
3
{ "name" : "sample_geospatial", "sizeOnDisk" : 1384448.0, "empty" : false }
4
{ "name" : "sample_mflix", "sizeOnDisk" : 45084672.0, "empty" : false }
5
{ "name" : "sample_supplies", "sizeOnDisk" : 1347584.0, "empty" : false }
6
{ "name" : "sample_training", "sizeOnDisk" : 73191424.0, "empty" : false }
7
{ "name" : "sample_weatherdata", "sizeOnDisk" : 4427776.0, "empty" : false }
8
{ "name" : "admin", "sizeOnDisk" : 245760.0, "empty" : false }
9
{ "name" : "local", "sizeOnDisk" : 1919799296.0, "empty" : false }

1
using System;
2
using MongoDB.Driver;
3
4
namespace test
5
{
6
    class Program
7
    {
8
        static void Main(string[] args)
9
        {
10
            MongoClient dbClient = new MongoClient(<<YOUR ATLAS CONNECTION STRING>>);
11
12
            var dbList = dbClient.ListDatabases().ToList();
13
14
            Console.WriteLine("The list of databases on this server is: ");
15
            foreach (var db in dbList)
16
            {
17
                Console.WriteLine(db);
18
            }
19
        }
20
    }
21
}

1
{
2
  "_id":{"$oid":"56d5f7eb604eb380b0d8d8ce"},
3
  "student_id":{"$numberDouble":"0"},
4
  "scores":[
5
    {"type":"exam","score":{"$numberDouble":"78.40446309504266"}},
6
    {"type":"quiz","score":{"$numberDouble":"73.36224783231339"}},
7
    {"type":"homework","score":{"$numberDouble":"46.980982486720535"}},
8
    {"type":"homework","score":{"$numberDouble":"76.67556138656222"}}
9
  ],
10
  "class_id":{"$numberDouble":"339"}
11
}

1
using System;
2
using MongoDB.Bson;
3
using MongoDB.Driver;
4
5
namespace MongoDBCRUDExample
6
{
7
    class Program
8
    {
9
        static void Main(string[] args)
10
        {
11
            MongoClient dbClient = new MongoClient(<<YOUR ATLAS CONNECTION STRING>>);
12
13
    var database = dbClient.GetDatabase("sample_training");
14
            var collection = database.GetCollection<BsonDocument>("grades");
15
16
        }
17
    }
18
}

1
var document = new BsonDocument
2
            {
3
                { "student_id", 10000 },
4
                { "scores", new BsonArray
5
                    {
6
                    new BsonDocument{ {"type", "exam"}, {"score", 88.12334193287023 } },
7
                    new BsonDocument{ {"type", "quiz"}, {"score", 74.92381029342834 } },
8
                    new BsonDocument{ {"type", "homework"}, {"score", 89.97929384290324 } },
9
                    new BsonDocument{ {"type", "homework"}, {"score", 82.12931030513218 } }
10
                    }
11
                },
12
                { "class_id", 480}
13
            };

1
collection.InsertOne(document);

1
await collection.InsertOneAsync(document);

1
var firstDocument = collection.Find(new BsonDocument()).FirstOrDefault();
2
Console.WriteLine(firstDocument.ToString());

1
{ "_id" : ObjectId("56d5f7eb604eb380b0d8d8ce"),
2
"student_id" : 0.0,
3
"scores" : [
4
{ "type" : "exam", "score" : 78.404463095042658 },
5
{ "type" : "quiz", "score" : 73.362247832313386 },
6
{ "type" : "homework", "score" : 46.980982486720535 },
7
{ "type" : "homework", "score" : 76.675561386562222 }
8
],
9
"class_id" : 339.0 }

1
var filter = Builders<BsonDocument>.Filter.Eq("student_id", 10000);

1
var studentDocument = collection.Find(filter).FirstOrDefault();
2
Console.WriteLine(studentDocument.ToString());

1
{ "_id" : ObjectId("5d88f88cec6103751b8a0d7f"),
2
"student_id" : 10000,
3
"scores" : [
4
{ "type" : "exam", "score" : 88.123341932870233 },
5
{ "type" : "quiz", "score" : 74.923810293428346 },
6
{ "type" : "homework", "score" : 89.979293842903246 },
7
{ "type" : "homework", "score" : 82.129310305132179 }
8
],
9
"class_id" : 480 }

1
var documents = collection.Find(new BsonDocument()).ToList();

1
var highExamScoreFilter = Builders<BsonDocument>.Filter.ElemMatch<BsonValue>(
2
"scores", new BsonDocument { { "type", "exam" },
3
{ "score", new BsonDocument { { "$gte", 95 } } }
4
});
5
var highExamScores = collection.Find(highExamScoreFilter).ToList();

1
var cursor = collection.Find(highExamScoreFilter).ToCursor();
2
foreach (var document in cursor.ToEnumerable())
3
{
4
     Console.WriteLine(document);
5
}

1
await collection.Find(highExamScoreFilter).ForEachAsync(document => Console.WriteLine(document));

1
var sort = Builders<BsonDocument>.Sort.Descending("student_id");
2
3
var highestScores = collection.Find(highExamScoreFilter).Sort(sort);

1
var highestScore = collection.Find(highExamScoreFilter).Sort(sort).First();
2
3
Console.WriteLine(highestScore);

1
var document = new BsonDocument
2
            {
3
                { "student_id", 10000 },
4
                { "scores", new BsonArray
5
                    {
6
                    new BsonDocument{ {"type", "exam"}, {"score", 88.12334193287023 } },
7
                    new BsonDocument{ {"type", "quiz"}, {"score", 74.92381029342834 } },
8
                    new BsonDocument{ {"type", "homework"}, {"score", 89.97929384290324 } },
9
                    new BsonDocument{ {"type", "homework"}, {"score", 82.12931030513218 } }
10
                    }
11
                },
12
                { "class_id", 480}
13
            };

1
var filter = Builders<BsonDocument>.Filter.Eq("student_id", 10000)

1
var update = Builders<BsonDocument>.Update.Set("class_id", 483);

1
collection.UpdateOne(filter, update);

1
var arrayFilter = Builders<BsonDocument>.Filter.Eq("student_id", 10000) & Builders<BsonDocument>
2
                  .Filter.Eq("scores.type", "quiz");

1
var arrayUpdate = Builders<BsonDocument>.Update.Set("scores.$.score", 84.92381029342834);

1
collection.UpdateOne(arrayFilter , arrayUpdate);

1
{
2
    { "student_id", 10000 },
3
    { "scores", new BsonArray
4
        {
5
        new BsonDocument{ {"type", "exam"}, {"score", 88.12334193287023 } },
6
        new BsonDocument{ {"type", "quiz"}, {"score", 84.92381029342834 } },
7
        new BsonDocument{ {"type", "homework"}, {"score", 89.97929384290324 } },
8
        new BsonDocument{ {"type", "homework"}, {"score", 82.12931030513218 } }
9
        }
10
    },
11
    { "class_id", 483}
12
};

1
var deleteFilter = Builders<BsonDocument>.Filter.Eq("student_id", 10000);

1
collection.DeleteOne(deleteFilter);

1
var deleteLowExamFilter = Builders<BsonDocument>.Filter.ElemMatch<BsonValue>("scores",
2
     new BsonDocument { { "type", "exam" }, {"score", new BsonDocument { { "$lt", 60 }}}
3
});

1
collection.DeleteMany(deleteLowExamFilter);