How to get the primary key of an object after it is saved with DbContext

Question

Given this out of context snippet of my code:

var calibration = new Calibration
{
    CalibrationType = SelectedTest.TestTypeId
    ,Expiration = expirationDate
    ,LastSaved = DateTime.Now
    ,StatusTypeId = 1
    ,TechnicianId = SelectedTechnician.Id
    ,Phases = BuildCalibrationPhases()
};

db.Calibrations.Add(calibration);
db.SaveChanges();

Is there a way with Entity Framework to get the primary key that was chosen(seeded) for the calibration object after db.SaveChanges(); completes?

In other words how can I get the primary key for this object after it is committed?

Answer 1

Reload the entry in the context:

db.Entry(calibration).Reload();

Then you can access the newly created PK

Answer 2

Also, You can get from Calibration.PrimaryKeyProperty after db.SaveChanges();

Means,

var calibration = new Calibration
{
    CalibrationType = SelectedTest.TestTypeId
    ,Expiration = expirationDate
    ,LastSaved = DateTime.Now
    ,StatusTypeId = 1
    ,TechnicianId = SelectedTechnician.Id
    ,Phases = BuildCalibrationPhases()
};

db.Calibrations.Add(calibration);
db.SaveChanges();



int value = Calibration.PrimaryKeyProperty;