EF +仓库ObjectContext MVC 3应用程序中的ASP.NET处理

Question

因此，当我试图通过一个The ObjectContext instance has been disposed and can no longer be used for operations that require a connection. ActionFilterAttribute中的存储库访问ObjectContext时，我会得到一个OnActionExecuting错误。

我的ActionFilterAttribute检查是否存在HTTP。如果它存在，它会用数据库验证它，刷新它的过期，然后将它添加到Controller ViewData集合中，以便ActionResult's可以访问它。如果它不存在，那么它会将用户重定向到登录页面。

过滤器的一半工作是因为当一个HTTP确实存在，并且它试图从数据库中获取具体的对象时，它会与上面的错误消息一起崩溃。

由于有很多层已经就位，我将继续将代码发布到所有这些层，VerifyCookieAttribute.cs、CookieRepository.cs和Repository_1.cs。最后，尽管这可能没有任何区别，但是错误发生在Repository_1.cs的Repository_1.cs方法中。

依赖项注入由NINOTE2.2.1.0实现。当前启用了延迟加载，但这两种设置都会产生相同的错误。

不管怎么说，我希望你能给我一些指导，让我知道我在哪里出了问题。提前感谢您的帮助！

//  VerifyCookieAttribute.cs
[AttributeUsage(AttributeTargets.Class, AllowMultiple = false, Inherited = true)]
internal class VerifyCookieAttribute : ActionFilterAttribute {
    [Inject]
    public CookieRepository Repository { private get; set; }

    private HttpRequestBase Request = null;
    private HttpResponseBase Response = null;

    private readonly bool Administration = false;
    private readonly bool Customers = false;

    private readonly string[] ExcludedPaths = new string[2] {
        "/Administration",
        "/Customers"
    };

    public VerifyCookieAttribute(
        bool Administration,
                    bool Customers) {
    this.Administration = Administration;
    this.Customers = Customers;
}

    public override void OnActionExecuting(
        ActionExecutingContext ActionExecutingContext) {
        this.Request = ActionExecutingContext.HttpContext.Request;

        if (!this.ExcludedPaths.Contains(this.Request.Url.AbsolutePath)) {
            this.Response = ActionExecutingContext.HttpContext.Response;

            if (this.Exists()) {
                Cookie Cookie = this.Get();

                this.Refresh(Cookie);

                ActionExecutingContext.Controller.ViewData.Add("Cookie", Cookie);

                if (this.Administration) {
                    ActionExecutingContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new {
                        area = "Administration",
                        controller = "Administration",
                        action = "Dashboard"
                    }));
                } else if (this.Customers) {
                    //  Do Nothing
                };
            } else if (!this.Exists() && !this.Response.IsRequestBeingRedirected) {
                if (this.Administration) {
                    ActionExecutingContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new {
                        area = "Administration",
                        controller = "Administration",
                        action = "Default"
                    }));
                } else if (this.Customers) {
                    ActionExecutingContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new {
                        area = "Customers",
                        controller = "Customers",
                        action = "Default"
                    }));
                };
            };
        };
    }

    private bool Exists() {
        string Token = this.GetHttpCookieToken();

        return (!String.IsNullOrEmpty(Token) && (Token.Length == 256));
    }

    private Cookie Get() {
        string Token = this.GetHttpCookieToken();

        Cookie Cookie = this.Repository.SelectSingle(
            c =>
                (c.Token == Token));

        return (Cookie);
    }

    private string GetHttpCookieToken() {
        if (this.Request.Cookies["NWP"] != null) {
            return this.Request.Cookies["NWP"]["Token"];
        };

        return (string.Empty);
    }

    private void Refresh(
        Cookie Cookie) {
        if (Cookie.RefreshStamp <= DateTime.Now.AddHours(1)) {
            this.Repository.RefreshCookie(Cookie.CookieId);

            this.SetHttpCookie(Cookie);
        };
    }

    private void SetHttpCookie(
        Cookie Cookie) {
        this.Response.Cookies["NWP"]["Token"] = Cookie.Token;
        this.Response.Cookies["NWP"].Expires = Cookie.RefreshStamp.AddHours(1);
    }
}

//   CookieRepository.cs
public sealed class CookieRepository : Repository<Cookie> {
    [Inject]
    public CookieRepository(
        Entities Entities)
        : base(Entities, true) {
    }

    public void RefreshCookie(
        int CookieId) {
        this.Entities.ExecuteFunction("RefreshCookie", new ObjectParameter("CookieId", CookieId));
    }
}

//  Repository`1.cs
public class Repository<TEntity> : IRepository<TEntity> where TEntity : class {
    protected readonly Entities Entities = null;

    private readonly IObjectSet<TEntity> EntitySet = null;

    [Inject]
    public Repository(
        Entities Entities)
        : this(Entities, true) {
    }

    [Inject]
    public Repository(
        Entities Entities,
        bool CreateEntitySet) {
        this.Entities = Entities;

        if (CreateEntitySet) {
            this.EntitySet = this.Entities.CreateObjectSet<TEntity>();
        };
    }

    public virtual void Delete(
        TEntity TEntity) {
        this.EntitySet.DeleteObject(TEntity);
    }

    public virtual void Insert(
        TEntity TEntity) {
        this.EntitySet.AddObject(TEntity);
    }

    public virtual IQueryable<TEntity> Select() {
        return this.EntitySet;
    }

    public virtual IQueryable<TEntity> Select(
        Expression<Func<TEntity, bool>> Selector) {
        return this.EntitySet.Where(Selector);
    }

    public virtual bool SelectAny(
        Expression<Func<TEntity, bool>> Selector) {
        return this.EntitySet.Any(Selector);
    }

    public virtual IList<TEntity> SelectList() {
        return this.EntitySet.ToList();
    }

    public virtual IList<TEntity> SelectList(
        Expression<Func<TEntity, bool>> Selector) {
        return this.EntitySet.Where(Selector).ToList();
    }

    private IList<TEntity> SelectOrderedList(
        bool Ascending,
        params Expression<Func<TEntity, IComparable>>[] Orderers) {
        IOrderedQueryable<TEntity> Queryable = null;

        foreach (Expression<Func<TEntity, IComparable>> Orderer in Orderers) {
            if (Queryable == null) {
                Queryable = (Ascending ? this.EntitySet.OrderBy(Orderer) : this.EntitySet.OrderByDescending(Orderer));
            } else {
                Queryable = (Ascending ? Queryable.ThenBy(Orderer) : Queryable.ThenByDescending(Orderer));
            };
        };

        return (Queryable.ToList());
    }

    public virtual IList<TEntity> SelectOrderedList(
        params Expression<Func<TEntity, IComparable>>[] Orderers) {
        return this.SelectOrderedList(true, Orderers);
    }

    public virtual IList<TEntity> SelectOrderedDescendingList(
        params Expression<Func<TEntity, IComparable>>[] Orderers) {
        return this.SelectOrderedList(false, Orderers);
    }

    public virtual TEntity SelectSingle(
        Expression<Func<TEntity, bool>> Selector) {
        return this.EntitySet.Single(Selector);
    }

    public virtual void Update() {
        this.Entities.SaveChanges();
    }

    public virtual IEnumerable<TEntity> Where(
        Expression<Func<TEntity, bool>> Selector) {
        return this.EntitySet.Where(Selector);
    }
}

更新

下面是@jfar请求的堆栈跟踪：

`System.Data.Objects.ObjectContext.EnsureConnection() +8550458    System.Data.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) +46    System.Data.Objects.ObjectQuery1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +44    System.Linq.Enumerable.Single(IEnumerable1 source) +184    System.Data.Objects.ELinq.ObjectQueryProvider.b_`_`3(IEnumerable1 sequence) +41    System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable1 query, Expression queryRoot) +59    System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +150    System.Linq.Queryable.Single(IQueryable1 source, Expression1 predicate) +300    {WITHHELD}.Repositories.Repository1.SelectSingle(Expression1 Selector) in C:\Projects{WITHHELD}{WITHHELD}\Repositories\Repository1.cs:98    VerifyCookieAttribute.Get() in C:\Projects\{WITHHELD}\{WITHHELD}\Attributes\VerifyCookieAttribute.cs:100    VerifyCookieAttribute.OnActionExecuting(ActionExecutingContext ActionExecutingContext) in C:\Projects\{WITHHELD}\{WITHHELD}\Attributes\VerifyCookieAttribute.cs:55    System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +47    System.Web.Mvc.<>c`_`_DisplayClass17.b_`_`14() +19    System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +263    System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19    System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +263    System.Web.Mvc.<>c`_`_DisplayClass17.b_`_`14() +19    System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +263    System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19    System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList1 filters, ActionDescriptor actionDescriptor, IDictionary2 parameters) +191    System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +343    System.Web.Mvc.Controller.ExecuteCore() +116    System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +97    System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10    System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +37    System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21    System.Web.Mvc.Async.<>c__DisplayClass81.b`_`_7(IAsyncResult` _`) +12    System.Web.Mvc.Async.WrappedAsyncResult&grave;1.End() +62    System.Web.Mvc.<>c`_`_DisplayClasse.b_`_`d() +50    System.Web.Mvc.SecurityUtil.b`_`_0(Action f) +7    System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +22    System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +60    System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8862381    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184`

Answer 1

我想您使用的是mvc 3。

在以前的ASP.NET MVC版本中，除了少数情况外，每个请求都创建操作过滤器。这种行为从来就不是一个有保证的行为，而仅仅是一个实现细节，过滤器的契约就是将它们视为无状态的。在ASP.NET MVC 3中，过滤器被更积极地缓存。因此，任何不正确地存储实例状态的自定义操作筛选器都可能被破坏。

这意味着属性是而不是为每个请求创建的，因此任何InRequestScope注入都不能工作。您需要在每个请求上注入IServiceProvider并获取存储库，或者手动创建新的上下文。