Getting the ID of inserted item [duplicate]

Question

So I have a query as such:

cmd.CommandText = @"INSERT INTO [dbo].[bill](bruto, waiterid, reversalid, number, ddate, tableid, total, printed, posplace, guestid, numberofguests, closedtime, methodofpaymentid, realdate) " +
                    "VALUES (@bruto, @waiterid, 0, 0, @ddate, 1, @total, 'True', 0, 0, 0, @closedtime, @methodofpaymentid, @realtime) " +
                    "SELECT id";
//+ lines of cmd.Parameter.AddWithValue(...,...);

But once I try to execute the query with:

int newId = Convert.ToInt64(cmd.ExecuteScalar());

I get that id is not identified (even though it Does exist).

If I try changing the SELECT to [dbo].[bill].id, I get the error

The multi-part identifier "dbo.bill.id" could not be bound.

I also tried making it SELECT MAX(id) (as this is the closest thing to a scalar), but yet again, I get the unidentified error.

Thanks for reading.

Answer 1

You can use the

SELECT SCOPE_IDENTITY()

just after your insert query and it will give you the identity of the last insert row. Check the MSDN for details on SCOPE_IDENTITY().

Returns the last identity value inserted into an identity column in the same scope.