mongoDB安装和使用
学习网址:https://www.runoob.com/mongodb/mongodb-tutorial.html
一、安装方法
mongo服务安装地址
链接:https://pan.baidu.com/s/1_vrPtK4hrE8ekrULFn9Q8A
提取码:fv6t
mongo客户端工具:Robo 3T 1.1.1
链接:https://pan.baidu.com/s/1WAaGdK2gfdkZ29_zEi53tA
提取码:wjue
二、mongo在net中应用
1.在Nuget中引用MongoDB.dirver包
2.调用方法
private List<mongoCustomer> FindCustomer(string name)
{
return mongo.collection.Find<mongoCustomer>(a => a.Name == name).ToList<mongoCustomer>();
}
private List<mongoCustomer> SelectPageSource(string name, int pageIndex, int pageSize)
{
var filter = Builders<mongoCustomer>.Filter.Regex("Name", new BsonRegularExpression(new Regex(".*" + Regex.Escape(name) + ".*", RegexOptions.IgnoreCase)));
return mongo.collection.Find<mongoCustomer>(filter).Skip((pageIndex - 1) * pageSize).Limit(pageSize).ToList();
}
private void BatchAddSource()
{
List<mongoCustomer> customers = new List<mongoCustomer>();
for (int i = 0; i < 100000; i++)
{
customers.Add(new mongoCustomer() { Id = ObjectId.GenerateNewId(), Name = "Name_" + i, CreateTime = DateTime.Now.ToString() });
}
mongo.InsertBatch(customers);
}
private void AddSource()
{
MongoDbHelper<mongoCustomer> mongo = new MongoDbHelper<mongoCustomer>();
mongo.Insert(new mongoCustomer() { Id = ObjectId.GenerateNewId(), Name = "Name", CreateTime = DateTime.Now.ToString() });
}
3.工具类
/// <summary>
/// MongoDb帮助类
/// </summary>
public class DB
{
private static readonly string connStr = "mongodb://127.0.0.1:27017";//GlobalConfig.Settings["mongoConnStr"];
private static readonly string dbName = "runoob";//GlobalConfig.Settings["mongoDbName"];
private static IMongoDatabase db = null;
private static readonly object lockHelper = new object();
private DB() { }
public static IMongoDatabase GetDb()
{
if (db == null)
{
lock (lockHelper)
{
if (db == null)
{
var client = new MongoClient(connStr);
db = client.GetDatabase(dbName);
}
}
}
return db;
}
}
public class MongoDbHelper<T> where T : BaseEntity
{
private IMongoDatabase db = null;
public IMongoCollection<T> collection = null;
public MongoDbHelper()
{
this.db = DB.GetDb();
collection = db.GetCollection<T>(typeof(T).Name);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public T Insert(T entity)
{
var flag = ObjectId.GenerateNewId();
entity.GetType().GetProperty("Id").SetValue(entity, flag);
entity.State = "y";
entity.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
entity.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
collection.InsertOneAsync(entity);
return entity;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="id"></param>
/// <param name="field"></param>
/// <param name="value"></param>
public void Modify(string id, string field, string value)
{
var filter = Builders<T>.Filter.Eq("Id", ObjectId.Parse(id));
var updated = Builders<T>.Update.Set(field, value);
UpdateResult result = collection.UpdateOneAsync(filter, updated).Result;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity"></param>
public void Update(T entity)
{
try
{
var old = collection.Find(e => e.Id.Equals(entity.Id)).ToList().FirstOrDefault();
foreach (var prop in entity.GetType().GetProperties())
{
var newValue = prop.GetValue(entity);
var oldValue = old.GetType().GetProperty(prop.Name).GetValue(old);
if (newValue != null)
{
if (oldValue == null)
oldValue = "";
if (!newValue.ToString().Equals(oldValue.ToString()))
{
old.GetType().GetProperty(prop.Name).SetValue(old, newValue.ToString());
}
}
}
old.State = "n";
old.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var filter = Builders<T>.Filter.Eq("Id", entity.Id);
ReplaceOneResult result = collection.ReplaceOneAsync(filter, old).Result;
}
catch (Exception ex)
{
var aaa = ex.Message + ex.StackTrace;
throw;
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="entity"></param>
public void Delete(T entity)
{
var filter = Builders<T>.Filter.Eq("Id", entity.Id);
collection.DeleteOneAsync(filter);
}
/// <summary>
/// 根据id查询一条数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public T QueryOne(string id)
{
return collection.Find(a => a.Id == ObjectId.Parse(id)).ToList().FirstOrDefault();
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <returns></returns>
public List<T> QueryAll()
{
return collection.Find(a => a.State != "").ToList();
}
/// <summary>
/// 根据条件查询一条数据
/// </summary>
/// <param name="express"></param>
/// <returns></returns>
public T QueryByFirst(Expression<Func<T, bool>> express)
{
return collection.Find(express).ToList().FirstOrDefault();
}
/// <summary>
/// 批量添加
/// </summary>
/// <param name="list"></param>
public void InsertBatch(List<T> list)
{
collection.InsertManyAsync(list);
}
/// <summary>
/// 根据Id批量删除
/// </summary>
public void DeleteBatch(List<ObjectId> list)
{
var filter = Builders<T>.Filter.In("Id", list);
collection.DeleteManyAsync(filter);
}
/// <summary>
/// 未添加到索引的数据
/// </summary>
/// <returns></returns>
public List<T> QueryToLucene()
{
return collection.Find(a => a.State.Equals("y") || a.State.Equals("n")).ToList();
}
}
public class mongoCustomer : BaseEntity
{
/// <summary>
/// 名称
/// </summary>
public string Name { get; set; }
}
public abstract class BaseEntity
{
public ObjectId Id { get; set; }
public string State { get; set; }
public string CreateTime { get; set; }
public string UpdateTime { get; set; }
}