MongoDB学习（一）

MongoDB是NoSql中一直使用比较广泛的数据库，闲来无事，学习学习

至于如何安装，配置MongoDB的环境请查看：http://cn.docs.mongodb.org/manual/installation/，里面基本的CRUD也详细介绍了，仔细看看

我是安装了Window7 64位使用的版本。

由于我使用C#，所以还得去下个MongoDB的C#下的驱动，请查看：http://www.mongodb.org/display/DOCS/CSharp+Language+Center

安装好驱动后，把里面的MongoDB.Driver.dll，MongoDB.BSon.dll引用到工程中，这样就万事具备了，开始开工了

简单的插入和查询数据：

 class Person
    {
        public ObjectId _id;//BsonType.ObjectId//这个对应了 MongoDB.Bson.ObjectId 对目前的 mongdb 来说必须要有这个
        public int Uid;
        public string Name;
        public string PassWord;

    }
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "mongodb://localhost";

            string databasename = "myDatabase";

            string collectionName = "myCollection";

            MongoClient client = new MongoClient(connectionString);

            MongoServer server = client.GetServer();

            MongoDatabase database = server.GetDatabase("test");

           // MongoCollection<Entity> collection = database.GetCollection<Entity>("entities");

            //Entity entity = new Entity { Name = "Tom" };
            //collection.Insert(entity);
            //var id = entity.Id;
            //Console.WriteLine(id);

            //var query = Query.EQ("_id", id);
            //entity = collection.FindOne(query);

            //entity.Name = "Dick";
            //collection.Save(entity);

            //var update = Update.Set("Name", "Harry");
            //collection.Update(query, update);

            //entity = collection.FindOne(query);
            //Console.WriteLine(entity.Name);

            //collection.Remove(query);

            MongoCollection mongoCollection = database.GetCollection("demo");
            //先插入数据
            MongoInsert(server, mongoCollection);

            //再查下数据，我暂时屏蔽了，等插入之后，就将插入那句给屏蔽，查询的这句放开
          //  MongoSelect(mongoCollection);
            Console.ReadKey();
            
        }

        private static void MongoSelect(MongoCollection mongoCollection)
        {
            //更新字段名称，由于我在插入时，把第一行的Password的名字写错了，跟后面两行不同，就改下名称
            var queryName = Query.EQ("Uid", 123);
            var updateName = Update.Rename("Password", "PassWord");
            mongoCollection.Update(queryName, updateName);

            /*---------------------------------------------
            * sql : SELECT * FROM table 
            *---------------------------------------------
            */
            MongoCursor<Person> p = mongoCollection.FindAllAs<Person>();   //第一种读取的方式
            foreach (var i in p)
            {

                Console.WriteLine("_id:{0}", i._id);
                Console.WriteLine(i.Uid + "\\" + i.Name + "\\" + i.PassWord);
            }

            /*---------------------------------------------
            * sql : SELECT * FROM table WHERE Uid > 10 AND Uid < 20
            *---------------------------------------------
            */
            QueryDocument query = new QueryDocument();
            BsonDocument b = new BsonDocument();
            b.Add("$gt", 100);
            b.Add("$lt", 124);
            query.Add("Uid", b);
            MongoCursor<Person> m = mongoCollection.FindAs<Person>(query);

            foreach (BsonDocument book in mongoCollection.FindAs<BsonDocument>(query))   //第二种读取的方式
            {
               Console.WriteLine(book.ToString());
               Console.WriteLine("_id:{0}", book["_id"].AsObjectId);
               Console.WriteLine(book["Uid"].AsInt32 + "\\" + book["Name"].AsString + "\\" + book["PassWord"].AsString);
            }
           
           /*-----------------------------------------------
           * sql : SELECT COUNT(*) FROM table WHERE Uid > 10 AND Uid < 20
           *-----------------------------------------------
           */
            long c = mongoCollection.Count(query);

            /*-----------------------------------------------
           * sql : SELECT Name FROM table WHERE Uid > 10 AND Uid < 20
           *-----------------------------------------------
           */
            FieldsDocument f = new FieldsDocument();
            f.Add("Name", 1);
            MongoCursor<Person> mc = mongoCollection.FindAs<Person>(query).SetFields(f);

            /*-----------------------------------------------
          * sql : SELECT * FROM table ORDER BY Uid DESC LIMIT 10,10
          *-----------------------------------------------
          */
            SortByDocument s = new SortByDocument();
            s.Add("Uid", -1); //-1=DESC
            MongoCursor<Person> ms = mongoCollection.FindAllAs<Person>().SetSortOrder(s).SetSkip(10).SetLimit(10);
        }

        private static void MongoInsert(MongoServer server, MongoCollection mongoCollection)
        {
           //普通插入
            server.Connect();
            var o = new { Uid = 123, Name = "xixiNormal", Password = "111111" };
            mongoCollection.Insert(o);

            //对象插入
            Person p = new Person { Uid = 124, Name = "xixiObject", PassWord = "222222" };
            mongoCollection.Insert(p);

            //BsonDocument插入
            BsonDocument b = new BsonDocument();
            b.Add("Uid", 125);
            b.Add("Name", "xixiBson");
            b.Add("PassWord", "333333");
            mongoCollection.Insert(b);
        }