无法修复'The object cannot be deleted because it was not found in the ObjectStateManager.'

Question

当我尝试使用LINQ从数据库中删除对象时，我得到以下错误。

The object cannot be deleted because it was not found in the ObjectStateManager.

注意:当我尝试直接从数据库中运行查询时，对象将被删除。

我得到错误的代码:

 public void deleteStorage(CommonLayer.TblNewsStorage storageToDelete)
    {
        using(DBTicketSystemEntities e = new DBTicketSystemEntities())
        {
            e.TblNewsStorage.DeleteObject(storageToDelete);
            e.SaveChanges();
        }
    }

堆栈跟踪:

    [InvalidOperationException: The object cannot be deleted because it was not found in the ObjectStateManager.]
   System.Data.Objects.ObjectContext.DeleteObject(Object entity, EntitySet expectedEntitySet) +3061568
   System.Data.Objects.ObjectSet`1.DeleteObject(TEntity entity) +18
   DataLayer.DAStorage.deleteStorage(TblNewsStorage storageToDelete) in C:UsersEricDesktopDevelopmentLibrary NewsLibraryNewsDataLayerDAStorage.cs:38
   BusinessLayer.Storage.deleteStorage(String id) in C:UsersEricDesktopDevelopmentLibrary NewsLibraryNewsBusinessLayerStorage.cs:43
   NewsLibrary.Controllers.StorageController.Delete(TblNewsStorage storage) in C:UsersEricDesktopDevelopmentLibrary NewsLibraryNewsNewsLibraryControllersStorageController.cs:61
   lambda_method(Closure , ControllerBase , Object[] ) +180
   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +208
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
   System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +28
   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +48
   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +57
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +223
   System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +48
   System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +24
   System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +102
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +43
   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +14
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +57
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +47
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +25
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +47
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9688704
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

Answer 1

尝试发送您想要删除的对象的ID，然后在您的上下文中查询它，而不是发送整个对象:

    public void deleteStorage(int ID)
{
    using(DBTicketSystemEntities e = new DBTicketSystemEntities())
    {
      //Like That
        var selectedItem = e.TblNewsStorage.Where( t => t.ID == ID).FirstOrDefault(); 
        e.TblNewsStorage.DeleteObject(selectedItem);
        e.SaveChanges();
    }
}

Answer 2

尝试下面的代码:-

e.TblNewsStorage(storageToDelete).State = System.Data.EntityState.Deleted;
e.SaveChanges();

或

 e.TblNewsStorage.Attach(storageToDelete);
 e.TblNewsStorage.Remove(storageToDelete);
 e.SaveChanges();