How to find an identity of the last inserted row in Entity Framework?

.net, entity-framework

Solution

Entity Framework will automatically load the last inserted id to populate the primary key column of the inserted entity:

var customer = new Customer { Name = "Steven" };

context.AddObject(customer);

context.SaveChanges();

var id = customer.Id;

Note that the `Id` property only gets populated after calling `SaveChanges()` in case the `StoreGeneratedPattern` attribute is set to "Identity" or "Computed" for the auto-incremented ID column in the Storage part of the model.

Problem

I am inserting data in multiple tables. I need to know the last inserted (auto-incremented) ID in the table. I need to use it as a Foriegn Key in some other table. In short I need alternative of `@@Identity` in T-Sql.

Original source