MongoDB使用

MongoDB使用

• 部署服务

www.mongodb.com官网下载，安装后找到目录

–dpbath 指定数据库存放路径 –install 安装服务 –logpaht 指定日志路径 –host指定主机地址 –port 指定端口，默认27017

::不装直接cmd窗口运行服务，差别就是一个--install，
mongod.exe --dbpath c:/mongodb/Data --logpath c:/MongoDb/Log/a.log
::安装服务
mongod.exe --dbpath c:/mongodb/Data --install --logpath c:/MongoDb/Log/a.log

 

客户的连接

mongo.exe 192.168.1.100/demodb

 

=====================================================================================

• C Sharp Part

直接NetGut添加驱动

ConnectionString

<add name="MongoServerSettings" connectionString="mongodb://192.168.1.100/27017"/>

 

main cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MongoDB.Bson;
using MongoDB.Driver.Linq;
using MongoDB.Driver;
namespace MongoDbDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            //获取连接字符串
            string connStr = ConfigurationManager.ConnectionStrings["MongoServerSettings"].ConnectionString;
            //创建client
            MongoClient client = new MongoClient(connStr);
            //获取数据库，如果没有，会自动创建
            IMongoDatabase db = client.GetDatabase("DemoDb");
            //指定集合名字
            var collectionName = typeof(Customer).Name;
            //获取集合，如果没有，自动创建
            var collection = db.GetCollection<Customer>(collectionName);
            //删除collection
            //db.DropCollection("UserInfo");
            //清空collection数据
            //collection.DeleteMany(c => true);
            #region 添加实体
            //for (int i = 0; i < 100; i++)
            //{//创建实体
            //    Customer cus = new Customer();
            //    cus.CusId = i;
            //    cus.Name = "custom" + i;
            //    cus.Subtime = DateTime.Now;
            //    cus.Orders = new List<Order>
            //    {
            //        new Order(){Content = "order",OrderId = i},
            //        new Order(){Content = "order2",OrderId = i}
            //    };
            //    cus.Demo = "ddd";
            //    //加入到集合里
            //    collection.InsertOne(cus);
            //}
            //Console.WriteLine(collection.Count(c => c.CusId > 50));
            #endregion
            #region 查询
            //查询全部
            //var data = collection.Find(c => true).ToList();
            //foreach (var cus in data)
            //{
            //    Console.WriteLine(cus.Id + "------" + cus.CusId + "------" + cus.Name);
            //}
            //查询CusId大于10
            //var data2 = collection.Find(new FilterDefinitionBuilder<Customer>().Gt(c => c.CusId, 10));
            //var data2 = collection.Find(c => c.CusId > 10).ToList();
            //foreach (var cus in data2)
            //{
            //    Console.WriteLine(cus.Id + "------" + cus.CusId + "------" + cus.Name);
            //}
            #endregion
            #region 查询 Linq
            var temp = collection.AsQueryable();
            var data3 = from cus in temp
                        where cus.CusId > 10 && cus.CusId < 50
                        select cus.Name;
            foreach (string s in data3)
            {
                Console.WriteLine(s);
            }
            #endregion
            Console.ReadKey();
        }
    }
}

 

customer.cs

using System;
using System.Collections.Generic;
namespace MongoDbDemo
{
    public class Customer:BaseEntity
    {
        public string Name { get; set; }
        public int CusId { get; set; }
        public DateTime Subtime { get; set; }
        public List<Order> Orders { get; set; }
        public string Demo { get; set; }
    }
    public class Order
    {
        public int OrderId { get; set; }
        public string Content { get; set; }
    }
}  

 

BaseEntity.cs

namespace MongoDbDemo
{
    public class BaseEntity
    {
        public object Id { get; set; }
    }
}