Get newly added data in result

[sleepinzombie]

I am using a Stored Procedure to add a new data from my Express app to the database. The creation of the new entity is successfully inserted but I need the newly added entity to the database in the response.

Is there a way I can achieve this? Currently the response I get is as follows:

{
   recordsets: [],
   recordset: undefined,
   output: {},
   rowsAffected: [
     0, 1, 1, 1, 1,
     1, 1, 1, 1, 1,
     1, 1
   ],
   returnValue: 0
 }

[sleepinzombie]

I am thinking that I will need to add a SELECT statement in my stored procedure using SCOPE_IDENTITY to get the newly inserted record.

But is there any other option?

[dhensby]

The library supports the OUTPUT clause in SQL so nothing special needs to be done for this to work in the library.

You'll need to write an SP/query that outputs the data you need.