Delete api not working, do not delete. Stored Procedure in the database is working

Question

This is the API

public class DeleteCidade
    {
        BancoContext banco = new BancoContext(); 
        public void deleteCidade(int id)
        {
            banco.Database.SqlQuery<Cidade>("exec sp_del_cidade", new SqlParameter("@id", id));
        }          
    }

My cobtroller

[RoutePrefix("api/[controller]")]
    public class DeleteCidadeController : ApiController
    {
        DeleteCidade deleta = new DeleteCidade();

        [AcceptVerbs("Delete")]
        public void deleteCidade(int id)
        {
            deleta.deleteCidade(id);
        }
    }

as I call it in the Postman

http://localhost:55080/api/DeleteCidade/27

My SP

ALTER PROCEDURE [dbo].[sp_del_cidade] @id int
AS
BEGIN
  SET NOCOUNT ON
    delete from cidade
    where id = @id
END

when running by API(Postman) do not delete. No error, but do not delete.

The database is sql server. When Proc is run by Sql Server, it works fine.

Answer 1

Has two problems, i) the command SqlQuery is to return entities, in case you are trying to execute an action. ii) is not being informed the variable after the `Procedure.

change to:

banco.Database.ExecuteSqlCommand("exec sp_del_cidade @id", new SqlParameter("@id", id));