Entity Framework Update - The context is not currently tracking the entity

entity-framework-4 objectcontext
JMon picture JMon · Dec 17, 2011 · Viewed 9.3k times · Source

I am trying to update an entity but I am getting the following error:

The context is not currently tracking the entity.

My DB table consists of the following fields:

fixturedate, leagueID (FK), Team A (FK), Team B (FK).

My code is as follows:

public void UpdateFixture(Fixture validFixture)
{
    Fixture fixture = new Fixture();
    fixture = entities.Fixtures.Where(f => f.fixtureId == validFixture.fixtureId).FirstOrDefault();

    League league = new League();
    league.LeagueId = validFixture.leagueId;
    fixture.League = leagueActions.GetLeague(league);

    fixture.Team1 = teamActions.GetTeam(validFixture.teamA);
    fixture.Team2 = teamActions.GetTeam(validFixture.teamB);

    entities.UpdateObject(validFixture);
    entities.SaveChanges();
}

When I do entities.AttachTo("Fixtures", validFixture); I get the following error:

The context is already tracking a different entity with the same resource Uri.

What do I need to do to update the fixture entity?

Answer

Darko Kenda picture Darko Kenda · Dec 17, 2011

Why the validFixture is not tracked is not clear from your code, however you are selecting a Fixture entity with the same ID as the validFixture instance, which means it is now tracking that entity via the "fixture" instance.

Basically this means that you can update the entity via the "fixture" instance directly. Try just removing the line with the call to the UpdateObject method.

Related questions

How to create Entity Framework ObjectContext?

I have many DBs in one SQL server. I placed connectionString as template(look at Initial Catalog={0}) into web.config. <add name="ent" connectionString="metadata=res://*/ent.csdl|res://*/ent.ssdl|res://*/ent.msl;provider=System.Data.SqlClient;provider …

Read More
Validation failed for one or more entities. See 'EntityValidationErrors' property for more details

I am having this error when seeding my database with code first approach. Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. To be honest I don't know how to check the content of the validation …

Read More
There is already an open DataReader associated with this Command which must be closed first

I have this query and I get the error in this function: var accounts = from account in context.Accounts from guranteer in account.Gurantors select new AccountsReport { CreditRegistryId = account.CreditRegistryId, AccountNumber = account.AccountNo, DateOpened = account.DateOpened, }; return accounts.AsEnumerable() .Select((…

Read More