CODEWITHSUNDEEP
c#entity-framework
WishToBePro
WishToBePro

Reputation: 183

Scope_Identity() in Entity Framework

What is the equal code in EntityFramework to this sql code?

select Scope_Identity()

I want to get the id of the last record that i have inserted to database in EF.

Upvotes: 3

Views: 11163

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364349

You must ensure that your key property is mapped with StoreGeneratedPattern.Identity (here you can find some more about this setting). This should be used as default when generating the model from MS SQL database where the key column is defined with IDENTITY. After that it is enough to call SaveChanges on the context and the key property will be automatically filled for you.

Upvotes: 3

Related Questions