3
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?
Hugo posts his class
Pessoa
and also post your Storedprocedure!– novic