Pass Parameters to Store Procedure

Question

Follow the Search Function Code

public List<Pessoa> Buscar(string Nome)
{ 
    using(var db = new MyContext())
    {
        var Result = db.Database.SqlQuery<Pessoa>("EXEC SP_Busca_Cliente @Nome", Nome).ToList();
        return Result.ToList();
    }
}

QUESTION ---- I have tried using Sqlparameters only that returns the Error that is not passing the correct Parameter for the Stored Procedure Is there a Method to set this parameter to pass it to the Stored Procedure?

Answer 1

There is yes, the correct is this syntax (using your code as an example):

var result = context.Database.SqlQuery<Pessoa>(
    "SP_Busca_Cliente @Nome", new SqlParameter("@Nome", nome));

You do not need the "Exec" before the name of the process, just put the name of the process and the list of parameters.

Source.