Make a query using Entity Framework and Stored Procedures

Question

I have the procRetornaCliente process that receives the following parameters: Id, areaAtuacao, City. Mapping it on EDMX, I got a Complex Type (procRetornaClienteModel) with all fields mapped, but do not know how to make a query using the Entity Framework, I have already researched and every site makes a different example. My structure is as follows:

using (DataBaseAdmin db = new DataBaseAdmin())
{
    int id = Session["_id"];
    String areaAtuacao = Session["_areaAtuacao"].ToString();
    String Cidade = Session["_Cidade"].ToString();
}

Answer 1

Have you ever tried something like this?

using (DataBaseAdmin db = new DataBaseAdmin())
{
    int id = Session["_id"];
    String areaAtuacao = Session["_areaAtuacao"].ToString();
    String Cidade = Session["_Cidade"].ToString();

    //retornar da procedure
    var object = db.procRetornaClienteModel(id);

    //manipular e salvar
    var cliente; // coloque aqui código pra transformar seu retorno em uma entidade cliente.
    cliente.AreaAtuacao = areaAtuacao;
    cliente.Cidade = Cidade;
    db.SaveChanges();
}

For a better answer it is necessary to have more information about what exactly your project does, what its entities are, etc. But I hope I have helped.