1.环境:
windows7
vs2010
2.下载驱动程序
https://github.com/mongodb/mongo-csharp-driver/downloads
我下载的是最新的版本 CSharpDriver-1.7.0.4714.zip
解压后,将压缩包中的两个dll文件添加到vs工程中
MongoDB.Bson.dll
MongoDB.Driver.dll
3.首先创建对应的实体类
using MongoDB.Bson;
namespace CodeFactory.mongo
{
class PersonEntity
{
public ObjectId _id { get; set; }
public string name { get; set; }
public int age { get; set; }
}
}
4.启动mongodb服务
5.连接信息
//连接信息
string conn = "mongodb://localhost";
string database = "test";
string collection = "user";
MongoServer mongodb = MongoServer.Create(conn); // 连接数据库
MongoDatabase mongoDataBase = mongodb.GetDatabase(database); // 选择数据库名
MongoCollection mongoCollection = mongoDataBase.GetCollection(collection); // 选择集合,相当于表
mongodb.Connect();
6.添加数据
PersonEntity person = new PersonEntity();
person.name = "jack6";
person.age = 26;
mongoCollection.Insert(person);
MessageBox.Show("添加成功!");
7.查询
7.1全部查询
string msg = string.Empty;
// 全部查询
MongoCursor<PersonEntity> mc = mongoCollection.FindAllAs<PersonEntity>();
foreach (PersonEntity person in mc)
{
msg += "_id:" + person._id.ToString() + " name:" + person.name.ToString() + " age:" + person.age.ToString() + "\n";
}
MessageBox.Show(msg);
7.2单条件查询
msg = "";
// 单条件查询
QueryDocument query = new QueryDocument("name", "jack6");
mc = mongoCollection.FindAs<PersonEntity>(query);
foreach (PersonEntity person in mc)
{
msg += "_id:" + person._id.ToString() + " name:" + person.name.ToString() + " age:" + person.age.ToString() + "\n";
}
MessageBox.Show(msg);
7.3多条件查询
msg = "";
// 多条件查询
QueryDocument query = new QueryDocument
{
{"name", "jack6"},
{"age", 26}
};
mc = mongoCollection.FindAs<PersonEntity>(query);
foreach (PersonEntity person in mc)
{
msg += "_id:" + person._id.ToString() + " name:" + person.name.ToString() + " age:" + person.age.ToString() + "\n";
}
MessageBox.Show(msg);
8.更新数据
// 多条件查询
QueryDocument query = new QueryDocument
{
{"name", "jack6"},
{"age", 26}
};
// 修改一个值
//var update = new UpdateDocument {
// { "$set", new BsonDocument("age", 30) }
//};
// 修改多个值
var update = new UpdateDocument {
{ "$set", new BsonDocument{
{"name", "jack7"},
{"age", 31}
} }
};
mongoCollection.Update(query, update);
MessageBox.Show("修改成功!");
9.删除数据
// QueryDocument query = new QueryDocument("name", "jack7");
// 多条件查询
QueryDocument query = new QueryDocument
{
{"name", "jack7"},
{"age", 31}
};
mongoCollection.Remove(query);
MessageBox.Show("删除成功!");
以上