ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker

by

[Update]
Because L2E is used you need to save all the linked objects first before you can save the main object. Which makes sense otherwise you would create (in my example) an artist without it’s contact object. This isn’t allowed by the database design.
[/Update]

Here’s my implementation which worked.

[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Create([Bind(Exclude = "Id")] Artist artist, [Bind(Prefix = "Contact")] Contact contact, [Bind(Prefix = "Country")] Country country, [Bind(Prefix = "ContactRelationship")] ContactRelationship contactRelationship)
{
    ViewData["Countries"] = new SelectList(new CountryService(_msw).ListCountries().OrderBy(c => c.Name), "ID", "Name");
    ViewData["ContactRelationships"] = new SelectList(new ContactRelationshipService(_msw).ListContactRelationships().OrderBy(c => c.ID), "ID", "Description");

    country = _countryService.GetCountryById(country.ID);
    contact.Country = country;
    contactRelationship = _contactRelationshipService.GetContactRelationship(contactRelationship.ID);
    contact.ContactRelationship = contactRelationship;
    if(_contactService.CreateContact(contact)){
        artist.Contact = contact;
        if (_service.CreateArtist(artist))
            return RedirectToAction("Index");        
    }
    return View("Create");
}

And then in my ContactRepository : 

public Contact CreateContact(Contact contact)
{
    _entities.AddToContact(contact); //no longer throws the exception
    _entities.SaveChanges();
    return contact ;
}

I also found on this website that it is best to keep the same context throughout the application so I’m now using a special Data class for this:

Rick Strahl and Samuel Maecham have taught me that you should keep your datacontext per user per request. Which means putting it in the HttpContext for web applications.
Read all about it here 

public class Data
{
    public static MyDBEntities MyDBEntities
    {
        get
        {
            if (HttpContext.Current != null && HttpContext.Current["myDBEntities"] == null)
            {
                HttpContext.Current["myDBEntities"] = new MyDBEntities ();
            }
            return HttpContext.Current["myDBEntities"] as MyDBEntities;
        }
        set { 
            if(HttpContext.Current != null)
                HttpContext.Current["myDBEntities"] = value; 
        }
    }
}

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. Entity Framework with NOLOCK
  3. Encrypt password in App.config
  4. DbArithmeticExpression arguments must have a numeric common type
  5. SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session
  6. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  7. Entity Framework – Include Multiple Levels of Properties
  8. Making Entity Class Closed for Changes
  9. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  10. Recursive Hierarchy – Recursive Query using Linq
  11. Filter/Search using Multiple Fields – ASP.NET MVC
  12. How to do a Bulk Insert — Linq to Entities
  13. EF Data Context – Async/Await & Multithreading
  14. How should I multiple insert multiple records?
  15. The operation cannot be completed because the DbContext has been disposed using MVC 4
  16. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  17. Max return value if empty query
  18. Working with SQL views in Entity Framework Core
  19. Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?
  20. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  21. Should Entity Framework Context be Put into Using Statement?
  22. Use both AddDbContextFactory() and AddDbContext() extension methods in the same project
  23. How to use String property as primary key in Entity Framework
  24. How to get efficient Sql Server deadlock handling in C# with ADO?
  25. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  26. Adding a custom query backed Navigation Property to ODataConventionModelBuilder
  27. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq
  28. How to remove child one to many related records in EF code first database?
  29. How do you Sort a DataTable given column and direction?
  30. Migrations in Entity Framework in a collaborative environment

Leave a Comment