public JsonResult GetDate()
{
OAEntities oa = new OAEntities();
List <Users> ulist = oa.Users.ToList();
return(Json(ulist, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 保证EF上下文实例是线程内唯一。
/// </summary>
/// <returns></returns>
public static DbContext CreateDbContext()
{
DbContext dbContext = (DbContext)CallContext.GetData("dbContext");
if (dbContext == null)
{
dbContext = new OAEntities();
CallContext.SetData("dbContext", dbContext);
}
return dbContext;
}
public static DbContext CreateDbContext()
{
DbContext dbContext = (DbContext)CallContext.GetData("dbContext");
if (dbContext == null)
{
dbContext = new OAEntities();
CallContext.SetData("dbContext", dbContext);
}
return(dbContext);
}
public static DbContext CreateDbContext()
{
//HTTPContext 中实现 是由CallContext 所以 直接使用CallContext
DbContext dbContext = (DbContext)CallContext.GetData("dbContext");
if (dbContext == null)
{
dbContext = new OAEntities();
CallContext.SetData("dbContext", dbContext);
}
return(dbContext);
}
/// <summary>
/// 创建 EF上下文 对象，在线程中共享 一个 上下文对象
/// </summary>
/// <returns></returns>
public DbContext GetDbContext()
{
////从当前线程中 获取 EF上下文对象
var dbContext = CallContext.GetData(typeof(DBContextFactory).Name) as DbContext;
if (dbContext == null)
{
dbContext = new OAEntities();
CallContext.SetData(typeof(DBContextFactory).Name, dbContext);
}
return(dbContext);
}
public void Delete(int ID)
{
OAEntities enty = new OAEntities();
var user = enty.Users.Where(a => a.Id == ID).FirstOrDefault();
enty.Entry(user).State = System.Data.EntityState.Deleted;
int row = enty.SaveChanges();
Response.Write(row);
Response.End();
}
/// <summary>
/// 获取线程内唯一的dbContext对象
/// </summary>
/// <returns></returns>
public DbContext GetDbContext()
{
// 首先先线程上下文中查看是否有已存在的DBContext
// 如果有那么直接返回这个，如果没有就新建
DbContext DB = CallContext.GetData("DBContext") as OAEntities;
if (DB == null)
{
DB = new OAEntities();
CallContext.SetData("DBContext", DB);
}
return(DB);
}
