I have used Runner REST API support very successfully for multiple projects. While I have consumed existing REST APIs with the support, my focus has actually been on Creation of REST APIs. The generated services have been high peforming, error free, and they scaled well.
I came up with an obstacle recently. I need to create an INSERT operation that would write a record. We always code our access layer as SQL Server Stored Procedures, and then we invoke those procs from our apps.
We started with a stored proc to do the INSERT.
----------------------------------------------------------------------------------------------------------
-- INSERT a record into the customers table.
-- For demonstration purposes.
----------------------------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[usp_InsertCustomer]
-- Add the parameters for the stored procedure here
-- Input Parameters
@first_name nvarchar(50) = NULL,
@last_name nvarchar(50) = NULL
AS
BEGIN
DECLARE @result_code int
DECLARE @result_message nvarchar(250)
DECLARE @cust_id int
SET NOCOUNT ON;
----------------------------------------------------------------------------------------------------------
-- Perform the recorod INSERT
----------------------------------------------------------------------------------------------------------
INSERT INTO [dbo].[customers]
(
[first_name]
,[last_name]
)
VALUES
(
@first_name,
@last_name
)
----------------------------------------------------------------------------------------------------------
-- Check the status of the INSERT
----------------------------------------------------------------------------------------------------------
SET @result_code = @@ERROR;
IF (@result_code <> 0)
BEGIN
SET @result_message = 'Failure'
END
ELSE
BEGIN
-- Return the id of the new appointment record
SET @cust_id = SCOPE_IDENTITY()
SET @result_message = 'Success'
END
-- Return results
SELECT @result_code as N'result_code',
@result_message as N'result_message',
@cust_id as N'cust_id'
END
