I want to create an entity with the same values of existing entity for a table in my database.
CarEntity car = db.Cars.Single(c => c.ID == 2);
//This line throws error, I want to create new car from existing one.
car.ID = 5;
Lets say, I want to create new car from an existing car, the table has over 20 columns, only few columns and primary key change, how can i do that, i get an error "Change of identity not supported" when i try to create a new entity from an existing one.