Could someone guide me about this. I'm using EntityFramwork4 , I wish to obtain the ID from the last row of the table. Could someone getting experience by using this let me know , how do i obtain the last id from the database table.
Relational databases don't have any intrinsic order. There's no such factor as "the final row." Even when there have been, multiuser concurrency will make this meaningless.
Max(id) most likely does not solve your problem because of concurrency. Consider you have not told us exactly what the real problem you are attempting to solve is, it's difficult to be certain.