Execute SQL Server stored procedure in ODC.

To integrate and consume the library for executing SQL Server stored procedures in ODC, you can follow the detailed steps below:

Refer the SPExecute library and use the action ExecuteStoredProcedure into your logic flow or in any action.

It requires three input parameters :

1. SQL Server connection string

2. Stored Procedure name

3. Input parameter of DicKeyValuePair list

DicKeyValuePair structure exists in the library use it to create the collection of DicKeyValuePair list.

If no input parameter is required send the empty list of type DicKeyValuePair.

Output parameter :

Response output parameter is of type SPResponse structure contains Status, ErrorMessage and Result.

Input parameter example:

1. connectionString = "Server=your_server_name;Database=your_database_name;User Id=your_username;Password=your_password;";

2. storedProcedureName = "spINSERT_dbo_Categories"

3. inputParameterList = DictionaryItem.Key:"CatergorName" and DictionaryItem.Value:"XYZ Category"

Output Response example:

Status = "Success"

ErrorMessage = ""

Result = "{ \"Id\":\"12\" }" (Result is in json format)

Note: Connection string you can use from site property just make a note it should be site secured & deserialize the Result json.