C# MongoClient.GetCollection方法代码示例

 public void Any(KnockPostV1 request)
 {
     var db = new MongoClient().GetDatabase("test");
     var collection = db.GetCollection<Potato>("KnockKnock");
     collection.FindOneAndReplace(Builders<Potato>.Filter.Eq(k => k.Id, request.Knock.Id), new Potato(request.Knock),
         new FindOneAndReplaceOptions<Potato, Potato>() { IsUpsert = true });
 }

        public void Aggregate_with_query()
        {
            var startDate = GetStartDate();
            var endDate = GetEndDate();

            var duration = new TimeSpan(endDate.Ticks - startDate.Ticks);
            var maxCount = duration.TotalMinutes / delta.TotalMinutes;

            var stopWatch = new Stopwatch();
            var dataBase = new MongoClient("mongodb://localhost").GetServer().GetDatabase("MapReduce");
            var sessions = dataBase.GetCollection<Session>("Sessions");

            stopWatch.Start();
            var statistic = new List<StatisticItem>();

            for (int i = 0; i < maxCount; i++)
            {
                var startStroke = startDate.AddMinutes(delta.Minutes * i);
                var endStroke = startStroke.AddMinutes(delta.Minutes);
                statistic.Add(this.GetStatisticItem(startStroke, endStroke, sessions));
            }
            stopWatch.Stop();
            foreach (var statItem in statistic)
            {
                Trace.WriteLine(statItem.DateTime + " " + statItem.Count);
            }
            Trace.WriteLine("Aggregation: " + stopWatch.ElapsedTicks);
        }

        public void Aggregate_with_map_reduce()
        {
            var dataBase = new MongoClient("mongodb://localhost").GetServer().GetDatabase("MapReduce");
            var sessions = dataBase.GetCollection<Session>("Sessions");

            BsonJavaScript map = new BsonJavaScript(Scipts.map);
            BsonJavaScript reduce = new BsonJavaScript(Scipts.reduce);
            var result = sessions.MapReduce(map, reduce);
        }

        public RequestResponsePairQueryService(IConfig config)
        {
            var url = MongoUrl.Create(config.ProxyDbConnectionString);
            var db = new MongoClient(url)
                .GetServer()
                .GetDatabase(url.DatabaseName);

            _collection = db.GetCollection<RequestResponsePair>();
        }

		public MongoDBRevisionStorage(string connectionString)
		{
			ConnectionString = connectionString;

			var mongoUrl = MongoUrl.Create(connectionString);
			var database = new MongoClient(mongoUrl).GetDatabase(mongoUrl.DatabaseName);

			_revisions = database.GetCollection<RevisionModel>("revisions");
		}

        public UseCaseQueryService(IConfig config)
        {
            var url = MongoUrl.Create(config.ProxyDbConnectionString);
            var db = new MongoClient(url)
                .GetServer()
                .GetDatabase(url.DatabaseName);

            _collection = db.GetCollection<UseCase>();
        }

        public UseCaseUpdateTask(IConfig config, IDataList<UseCase> useCases)
        {
            var url = new MongoUrl(config.ProxyDbConnectionString);
            var db = new MongoClient(url)
                .GetServer()
                .GetDatabase(url.DatabaseName);

            _collection = db.GetCollection<UseCase>("UseCase");
            _useCases = useCases;
        }

		public MongoDBUserStorage(string connectionString)
		{
			ConnectionString = connectionString;

			var mongoUrl = MongoUrl.Create(connectionString);
			var database = new MongoClient(mongoUrl).GetDatabase(mongoUrl.DatabaseName);

			_users = database.GetCollection<UserModel>("users");

			Task.Run(() => SetUp()).Wait();
		}

        public void Aggregate()
        {
            var dataBase = new MongoClient("mongodb://localhost").GetServer().GetDatabase("MapReduce");
            var collection = dataBase.GetCollection<Session>("Sessions");

            var match = GetMatchOperator(GetStartDate(), GetEndDate());
            var project = GetProjectOperator(GetStartDate());

            var pipeline = new[] { match, project };
            var result = collection.Aggregate(pipeline);
            var matching = result.ResultDocuments.Count();
        }

        public static void AddMessage(string username, string text)
        {
            MongoDatabase db = new MongoClient("mongodb://daniel:[email protected]:61548/chat-db")
                .GetServer()
                .GetDatabase("chat-db");

            var messagesCollection = db.GetCollection<Message>("messages");

            var message = new Message { Date = DateTime.Now, Username = username, Text = text };

            messagesCollection.Insert(message);
        }

        public static async Task mainAsync()
        {
            var db = new MongoClient().GetDatabase("school");
            var collection = db.GetCollection<BsonDocument>("students");
            var list = await collection.Find(new BsonDocument()).ToListAsync();
            var newList = new List<BsonDocument>();

            list.ForEach(data => newList.Add(dropScore(data)));

            await db.DropCollectionAsync("students");
            await db.CreateCollectionAsync("students");
            await collection.InsertManyAsync(newList);
        }

        static async Task MainAsync() 
        {
            var database = new MongoClient().GetDatabase("students");
            var collection = database.GetCollection<BsonDocument>("grades");

            List<BsonDocument> listStudents = await collection.Find(new BsonDocument("type", "homework")).ToListAsync();
            
            listStudents.GroupBy(data => data["student_id"]).Select(data => new { student_id = data.Key, score = data.Min(x => x["score"]) }).ToList().ForEach(student =>
            {
                Console.WriteLine(student + " score removed.");
                collection.DeleteOneAsync(new BsonDocument("student_id", student.student_id).Add("score", student.score).Add("type", "homework"));
            });
        }

        public TableFiller(DbSettings configuration)
        {
            Configurations = configuration.collections.Configurations;
            Counters = configuration.collections.Counters;

            ConnectionString = configuration.connectionstring;
            DatabaseName = configuration.database;

            Database = new MongoClient(ConnectionString).GetServer().GetDatabase(DatabaseName);

            var configJson = Database.GetCollection(Configurations).FindOne().ToJson();
            Config = JsonConvert.DeserializeObject<Configurations>(configJson);
        }

        public static void PrintAllMessages()
        {
            MongoDatabase db = new MongoClient("mongodb://daniel:[email protected]:61548/chat-db")
                .GetServer()
                .GetDatabase("chat-db");

            var messagesCollection = db.GetCollection<Message>("messages");

            var messages = messagesCollection.FindAll();

            foreach (var message in messages)
            {
                Console.WriteLine("Message:\n User:{0}\n Text: {1}", message.Username, message.Text);
                Console.WriteLine();
            }
        }

    static void Main()
    {
        var db = new MongoClient(Connections.Default.MongoCloud).GetServer().GetDatabase("mongochat");
        var messages = db.GetCollection<BsonDocument>("Messages");

        Console.Write("Username: ");
        string username = Console.ReadLine();

        while (true)
        {
            Console.Write("> ");
            string input = Console.ReadLine();

            if (!string.IsNullOrWhiteSpace(input))
                messages.Insert(
                    new BsonDocument { { "Author", username }, { "Text", input }, { "Time", DateTime.Now } });

            var formattedMessages = messages
                .FindAll()
                .Select(m => string.Format("[{0}] {1}: {2}", m["Time"].ToLocalTime(), m["Author"], m["Text"]));

            Console.WriteLine(string.Join(Environment.NewLine, formattedMessages));
        }
    }