Get the Last inserted Id value form database...

Question

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

Harshal Patil · Answer

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;

Brijesh Rathor · Answer

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.

Santhosh · Answer

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); } }

Santhosh · Answer

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

kamal · Answer

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;

Get the Last inserted Id value form database...

Answers (5)