Get the Last inserted Id value form database...

Santhosh

Hi,

How to get the Last inserted Id value form database using entity framework webAPI .

that has id as primary key and is a identity

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hi,

You can do like this.

using (var context = new MyContext())

 context.MyEntities.AddObject(myNewObject);

 context.SaveChanges();

 int id = myNewObject.Id; // Your Identity column ID

Hope this will help you.

Harshal Patil9y ago
if primary key is there then you can select max function to get lsat inserted value

int lastid = entity.tblLocations.Max(p => p.id);

OR

var datainsert = new Customer() { Name = "Steven" };
context.AddObject(customer);
context.SaveChanges();
var id = customer.Id;
0
Santhosh9y ago
using this we can get last inserted record/field from database

[HttpGet]
[Route("api/Controller name")]
public HttpResponseMessage Get()
{
using (LocationDbEntity entity = new LocationDbEntity())
{
entity.Database.Connection.Open();
var max = entity.tblLocations.GroupBy(r => r.tid).OrderByDescending(g => g.Key).First().First();
return Request.CreateResponse(HttpStatusCode.OK, max);
}
}
0
Santhosh9y ago
I am using webApi Entity Framework..
In that HttpGet Method it will diaplay all the entities from database.
But I want to get the last inserted Entity all the fields from Database
0
kamal9y ago
I believe EF should update your entity object with the identity

Example

var entity = new Entity_Table { item1 = val1, item2 = val2 };
dbcontext.Entity_Tables.Add(entity);
dbcontext.SaveChanges();
int newId = entity.ID;
0