In my case its differente:
SP parameters:
ALTER PROCEDURE [dbo].[usp_DTMSDroneAddEdit]
@ID_DTMS nvarchar(50)
, @TrackID nvarchar(50)
, @DroneManufacturer nvarchar(120)
, @ExtraHTML nvarchar(4000)
, @DroneModel nvarchar(120)
, @DroneSerialNumber nvarchar(80)
, @DroneType nvarchar(50)
, @ExtraHTMLInHex bit
Parameters retrives from Radzen:
"paths": {
"/UspDtmsDroneAddEditsFunc(DroneManufacturer='{DroneManufacturer}',DroneModel='{DroneModel}',DroneSerialNumber='{DroneSerialNumber}',DroneType='{DroneType}',ExtraHTML='{ExtraHTML}',ExtraHTMLInHex={ExtraHTMLInHex},ID_DTMS='{ID_DTMS}',TrackID='{TrackID}')": {
"get": {
"operationId": "getUspDtmsDroneAddEdits",
"parameters": [
{
"in": "path",
"name": "DroneManufacturer",
"type": "string"
},
{
"in": "path",
"name": "DroneModel",
"type": "string"
},
{
"in": "path",
"name": "DroneSerialNumber",
"type": "string"
},
{
"in": "path",
"name": "DroneType",
"type": "string"
},
{
"in": "path",
"name": "ExtraHTML",
"type": "string"
},
{
"in": "path",
"name": "ExtraHTMLInHex",
"type": "boolean"
},
{
"in": "path",
"name": "ID_DTMS",
"type": "string"
},
{
"in": "path",
"name": "TrackID",
"type": "string"
},
{
"in": "query",
"name": "$filter",
"type": "string"
},
{
"in": "query",
"name": "$top",
"type": "integer"
},
{
"in": "query",
"name": "$skip",
"type": "integer"
},
{
"in": "query",
"name": "$orderby",
"type": "string"
},
{
"in": "query",
"name": "$count",
"type": "boolean"
},
{
"in": "query",
"name": "$expand",
"type": "string"
},
{
"in": "query",
"name": "$format",
"type": "string"
},
{
"in": "query",
"name": "$select",
"type": "string"
}
],
The generated code is:
[HttpGet]
[EnableQuery(MaxExpansionDepth=10,MaxNodeCount=1000)]
[ODataRoute("UspDtmsDroneAddEditsFunc(DroneManufacturer={DroneManufacturer},DroneModel={DroneModel},DroneSerialNumber={DroneSerialNumber},DroneType={DroneType},ExtraHTML={ExtraHTML},ExtraHTMLInHex={ExtraHTMLInHex},ID_DTMS={ID_DTMS},TrackID={TrackID})")]
public IActionResult UspDtmsDroneAddEditsFunc([FromODataUri] string DroneManufacturer, [FromODataUri] string DroneModel, [FromODataUri] string DroneSerialNumber, [FromODataUri] string DroneType, [FromODataUri] string ExtraHTML, [FromODataUri] bool ExtraHTMLInHex, [FromODataUri] string ID_DTMS, [FromODataUri] string TrackID)
{
this.OnUspDtmsDroneAddEditsDefaultParams(ref DroneManufacturer, ref DroneModel, ref DroneSerialNumber, ref DroneType, ref ExtraHTML, ref ExtraHTMLInHex, ref ID_DTMS, ref TrackID);
var items = this.context.UspDtmsDroneAddEdits.AsNoTracking().FromSql("EXEC [dbo].[usp_DTMSDroneAddEdit] {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", DroneManufacturer, DroneModel, DroneSerialNumber, DroneType, ExtraHTML, ExtraHTMLInHex, ID_DTMS, TrackID);
this.OnUspDtmsDroneAddEditsInvoke(ref items);
return Ok(items);
}
