Entity Framework Multiple Object Contexts

by

@Danny Varod is right. You should use one ObjectContext for the whole workflow. Moreover because your workflow seems as one logical feature containing multiple windows it should probably also use single presenter. Then you would follow recommended approach: single context per presenter. You can call SaveChanges multiple times so it should not break your logic.

The source of this issue is well known problem with deficiency of dynamic proxies generated on top of POCO entities combined with Fixup methods generated by POCO T4 template. These proxies still hold reference to the context when you dispose it. Because of that they think that they are still attached to the context and they can’t be attached to another context. The only way how to force them to release the reference to the context is manual detaching. In the same time once you detach an entity from the context it is removed from related attached entities because you can’t have mix of attached and detached entities in the same graph.

The issue actually not occures in the code you call:

itemFromA.RelatedProperty = itemFromB;

but in the reverse operation triggered by Fixup method:

itemFromB.RelatedAs.Add(itemFromA);

I think the ways to solve this are:

  • Don’t do this and use single context for whole unit of work – that is the supposed usage.
  • Remove reverse navigation property so that Fixup method doesn’t trigger that code.
  • Don’t use POCO T4 template with Fixup methods or modify T4 template to not generate them.
  • Turn off lazy loading and proxy creation for these operations. That will remove dynamic proxies from your POCOs and because of that they will be independent on the context.

To turn off proxy creation and lazy loading use:

var context = new MyContext();
context.ContextOptions.ProxyCreationEnabled = false;

You can actually try to write custom method to detach the whole object graph but as you said it was asked 500 times and I haven’t seen working solution yet – except the serialization and deserialization to the new object graph.

More Related Contents:

  1. Entity Framework/Linq EXpression converting from string to int
  2. Internal .NET Framework Data Provider error 1025
  3. Entity Framework Code Only error: the model backing the context has changed since the database was created
  4. Entity Framework 4: How to find the primary key?
  5. Change db table name in EF4 (entity framework 4)
  6. Repository Pattern, POCO, and Business Entities
  7. VB Net Class in C# [closed]
  8. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  9. Entity Framework 4 – AddObject vs Attach
  10. The cast to value type ‘Int32’ failed because the materialized value is null
  11. Making Entity Class Closed for Changes
  12. EF Including Other Entities (Generic Repository pattern)
  13. Filter/Search using Multiple Fields – ASP.NET MVC
  14. EF Data Context – Async/Await & Multithreading
  15. Why would try/finally rather than a “using” statement help avoid a race condition?
  16. Retrieve an object from entityframework without ONE field
  17. Finding the reason for DBUpdateException
  18. DbContext discard changes without disposing
  19. EF4 Code First: how to add a relationship without adding a navigation property
  20. Max return value if empty query
  21. Group by with multiple columns using lambda
  22. Entities VS Domain Models VS View Models
  23. How to do an “in” query in entity framework?
  24. Parallel doesnt work with Entity Framework
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. View Models and dependency injection
  28. How to force LINQ Sum() to return 0 while source collection is empty
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment