public T Add(T entity)
{
_dbContext.Set <T>().Add(entity);
_dbContext.SaveChanges();
return(entity);
}
public JsonResult Insert()
{
Category entity = new Category
{
Name = "Harry Cheng",
Time = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"),
Guid = Guid.NewGuid().ToString("N"),
};
dbContext.Set <Category>().Add(entity);
dbContext.SaveChanges();
return(Json(entity));
}
/// <summary>
///
/// </summary>
/// <param name="entities"></param>
/// <param name="isSave">isSave 无效</param>
/// <returns></returns>
public static OpResult AddRange(List <TEntity> entities, bool isSave = true)
{
var op = new OpResult();
SqliteTrap.PushAction <TEntity>(new Action <IEnumerable <TEntity> >((o1) =>
{
try
{
using (var context = new SqliteDbContext())
{
try
{
context.Set <TEntity>().AddRange(o1.ToList());
context.SaveChanges();
}
catch { }
finally
{
//One of the following two is enough
context.Database.Connection.Close();
context.Database.Connection.Dispose(); //THIS OR
ContextFactory.GetCurrentContext <SqliteDbContext>(true);
}
}
}
catch (Exception ex)
{
File.AppendAllText("Log.txt", ex.Message + "|" + ex.StackTrace, Encoding.UTF8);
// Log.WriteError(ex);
}
}), entities);
op.Successed = true;
return(op);
}
public List <T> Read()
{
return(db.Set <T>().ToList());
}