mongodb高效的访问速度,用来快速存取数据再合适不过了,缓存神马的,可以用这个的
另外,有的时候,如果仅仅存储几条数据,单独去建立一张表代价太大,这个时候,不妨试试这个
先发一个mongodb数据访问帮助类
public class MongdbHelper : IDisposable
{
public MongoServer Server { get; private set; }
public MongoDB.Driver.MongoDatabase Database { get; private set; }
public MongoCollection DataSet { get; set; }
public MongdbHelper( string dbName, string tableName)
{
Server = MongoServer.Create("mongodb://localhost/?socketTimeoutMS=2400000");
Database = Server.GetDatabase(dbName);
DataSet = Database.GetCollection(tableName);
}
public MongdbHelper(string connectionString, string dbName, string tableName)
{
Server = MongoServer.Create(connectionString);
Database = Server.GetDatabase(dbName);
DataSet = Database.GetCollection(tableName);
}
public void Dispose()
{
Server.Disconnect();
}
public static List GetOnColumn(string dbName, string tableName, string column, Func convert)
{
try
{
using (MongdbHelper db = new MongdbHelper(dbName, tableName))
{
List results = new List();
var r = db.DataSet.FindAll();
r.SetFields(column);
foreach (var c in r)
{
results.Add(convert(c[column]));
}
return results;
}
}
catch
{
return null;
}
}
public static bool IsExist(string dbName, string tableName, string column, object value)
{
try
{
using (MongdbHelper db = new MongdbHelper(dbName, tableName))
{
IMongoQuery query = new QueryDocument() { { column, value.ToString() } };
var results = db.DataSet.FindOne(query);
return results != null;
}
}
catch
{
return false;
}
}
}
再来看具体的实现:
原理:将对象通过序列化操作后以二进制的方式存储到mongodb中
存实现:
///
/// 存储数据
///
///
///
///
public static void Set(string key, T value)
{
try
{
using (MongdbHelper db = new MongdbHelper(DefaultDbName, DefaultTableName))
{
IMongoQuery query = new QueryDocument()
{
{"Key",key}
};
var document = db.DataSet.FindOne(query);
if (document != null)
{
document["Value"] = SerializeHelper.BinarySerialize(value);
document["Type"] = value.GetType().Name;
document["Date"] = DateTime.Now.ToString();
}
else
{
IDictionary newDict = new Dictionary();
newDict.Add("Value", SerializeHelper.BinarySerialize(value));
newDict.Add("Key", key);
newDict.Add("Type", value.GetType().Name);
newDict.Add("Date", DateTime.Now.ToString());
document = new BsonDocument(newDict);
}
db.DataSet.Save(document);
}
}
catch (Exception ex)
{
throw new Exception("保存数据出错", ex);
}
}