Get Record ID in Entity Framework after insert

Question

0.00/5 (No votes)

See more:

Hi
I realize this must be a relatively simple thing to do, but I'm not getting what I'm looking for with Google.

I need to get the record ID of the record I just saved using the Entity Framework. With SQL queries we used "Select @@IDENTITY as 'Identity';"

If anyone can help it would be greatly appreciated.

I'm working with ASP.NET C# 3.5 SP1

Thanks

Posted 13-Sep-10 21:56pm

NeCroFire

Updated 13-Sep-10 22:30pm

v2

Add a Solution

5 solutions

Solution 4

Actually, EF does populate the just inserted entity with its new ID. I have tested it using the EF provider for SQL Server 2008 and .NET 4.

Posted 18-Jul-11 23:20pm

Natsiavas Pantelis

Solution 6

this my code where I can save
db.ValueDocument.add(objValueDocument);
db.SaveChanges();
then
immediately i can get the value by using following code
db.ValueDocument.Local[0].ValueDocumentID;

Posted 29-Jun-12 0:13am

bajirao chavan

Solution 5

have a look and you will find what u want

http://blogs.msdn.com/b/adonet/archive/2008/03/26/stored-procedure-mapping.aspx[^]

Posted 27-May-12 20:01pm

Member 3523191

Updated 27-May-12 20:02pm

v2

Solution 1

There is no such direct method to get the generated Identiy key value after the insert.

Once the Record is saved, u can create another method like SELECT Top 1 from table order by dtimecre desc

I have searched for the same criteria mentioned by u. but dint get any proper solution. so need to follow the traditional method.

hope this helps.

Posted 13-Sep-10 23:13pm

mohangbits

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NeCroFire · Accepted Answer · 2010-09-20T22:27:00

Solution 2

"EF automatically populates your business objects with the db-generated values after your call to SaveChanges()."

Example:

MIDL

//create a new Client object
Client c = new Client();
c.Name = "Test";
//save to db
context.AddToClients(c);
context.SaveChanges();

//EF will populate your original object with the generated values
Debug.WriteLine( " Client ID is " + c.ClientID );

Posted 20-Sep-10 22:27pm

NeCroFire

Comments

Vatsal_Desai 26-Mar-11 9:17am

I am using the same method to get auto generated identity. It's working fine with MS Sql but not working with MySql.

Any Idea???