Dot net Interview Question and Answers

There are two ways to get the ID of the last inserted record.
@Identity()
@Scope_Identity()

EX:
String  Squlquery = “insert into tablename(categoryname) values (@categoryname);”  + “Select  Scope_Identity()”;

So use ExecuteScalar to get the ID of the last inserted Record.

Int getLastID = (int) cmd.ExecuteScalar();