How to get original values of an entity in Entity Framework?

entity-framework-4 entity
JatSing picture JatSing · Nov 15, 2011 · Viewed 27k times · Source

In EF 4.0, if I understand it right, there are two type of values in Entity : current values and original values.
We can set original values by calling ApplyOriginalValues(TEntity) method but how to get original values ?

Answer

Leonel Sanches da Silva picture Leonel Sanches da Silva · Jul 11, 2013

@Eranga answer is outdated for EF 5. For some reason, EF 5 doesn't work fine when getting original values using an statement like this:

var originalValues = context.Entry(myEntity).OriginalValues;

My working solution uses AsNoTracking() method from DbSet, like the example below:

var originalEntity = context.MyEntities.AsNoTracking().FirstOrDefault(me => me.MyEntityID == myEntity.MyEntityID);

Related questions

How to update only one field using Entity Framework?

Here's the table Users UserId UserName Password EmailAddress and the code.. public void ChangePassword(int userId, string password){ //code to update the password.. }

Read More
Entity Framework 6 Error Unable to load the specified metadata resource

I'm using Entity Framework 6 and "model first" in my solution, I separated my "Data Model" classes into another project, so that I can add reference to the "Data Model" classes without exposing my "Data Model Contexts" and connections. I don't …

Read More
How to upgrade from Entity Framework 4.3 to EF 5

Currently we are working on the EF 4.3 . We would like to upgrade it to EF5. I have google the upgrade process steps, but I did not get any result. Please help me..! Thanks.. :)

Read More