Hi,
You have the parameters incorrectly mapped, they are in alphabetical order and not in the original order of the SP.
Example:
Create PROCEDURE [dbo].[usp_DTMSDroneAddEdit]
@ID_DTMS nvarchar(50) -- cast de id to nvarchar from origin
,@DroneModel nvarchar(120)
,@DroneManufacturer nvarchar(120)
,@DroneSerialNumber nvarchar(80)
,@TrackID nvarchar(50)
,@DroneType nvarchar(50)
,@ExtraHTML nvarchar(4000)
AS
BEGIN
Declare @returntable as table( ID_DTMS nvarchar(50) -- cast de id to nvarchar from origin
,DroneModel nvarchar(120)
,DroneManufacturer nvarchar(120)
,DroneSerialNumber nvarchar(80)
,TrackID nvarchar(50)
,DroneType nvarchar(50)
,ExtraHTML nvarchar(4000))
insert into @returntable values( @ID_DTMS ,@DroneModel,@DroneManufacturer,@DroneSerialNumber,@TrackID,@DroneType,@ExtraHTML)
select ID_DTMS ,DroneModel ,DroneManufacturer,DroneSerialNumber,TrackID,DroneType,ExtraHTML from @returntable
END
Response: {"@odata.context":"http://localhost:5000/odata/Hub/$metadata#UspDtmsDroneAddEdits","value":[{"ID_DTMS":"1","DroneModel":"XPTo","DroneManufacturer":"teste123","DroneSerialNumber":"Fixed-Wings","TrackID":"1111","DroneType":"9","ExtraHTML":"1234567890"}]}
Auto-Generated Class:
...
[HttpGet]
[EnableQuery(MaxExpansionDepth=10,MaxNodeCount=1000)]
[ODataRoute("UspDtmsDroneAddEditsFunc(DroneManufacturer={DroneManufacturer},DroneModel={DroneModel},DroneSerialNumber={DroneSerialNumber},DroneType={DroneType},ExtraHTML={ExtraHTML},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] string ID_DTMS, [FromODataUri] string TrackID)
{
this.OnUspDtmsDroneAddEditsDefaultParams(ref DroneManufacturer, ref DroneModel, ref DroneSerialNumber, ref DroneType, ref ExtraHTML, ref ID_DTMS, ref TrackID);
var items = this.context.UspDtmsDroneAddEdits.AsNoTracking().FromSql("EXEC [dbo].[usp_DTMSDroneAddEdit] {0}, {1}, {2}, {3}, {4}, {5}, {6}", DroneManufacturer, DroneModel, DroneSerialNumber, DroneType, ExtraHTML, ID_DTMS, TrackID);
this.OnUspDtmsDroneAddEditsInvoke(ref items);
return Ok(items);
}
...
Error: EXEC [dbo].[usp_DTMSDroneAddEdit] {0}, {1}, {2}, {3}, {4}, {5}, {6}", DroneManufacturer, DroneModel, DroneSerialNumber, DroneType, ExtraHTML, ID_DTMS, TrackID
