How to map the results of a previous store to an entity using Entity Framework?

Question

Personal talk. I’m doing a project with MVC 4 and EF6.

I’d like to call in a proc and her results populate an entity. But my entity is not a bank table, so I did not use Dbset on it. What happens is that this proc makes Join of some tables. I’m doing everything by code, because the bank already existed and there’s a lot I won’t use.

This is my entity

public class Dados
{
    public string dtAnoMes { get; set; }
    public string valor{ get; set; }
    public string valorTotal { get; set; }
    public string dif { get; set; }

    public Dados()
    { }

    public IList<Dados> RecuperaValores(string data)
    {
        using (var context = new ContextoBanco())
        {
            var dtInicio = new SqlParameter("@Value1", data);
            var dtFim = new SqlParameter("@Value2", data);

            var result = context.Database.SqlQuery<Dados>("SP_RECUPERA_VALORES @Value1, @Value2", dtInicio , dtFim ).ToList();


            return result.ToList();
        }
    }

}

My proc returns four columns: YEAR/MONTH, VALUE, VALOR_TOTAL, DIFFERENCE.

wanted to somehow say that the column YEAR/MES equals the entity’s dtANoMes property and so by diants. The code to execute proc is working fine. only this map is missing. Does anyone know how to do it?

Thank you very much!

UPDATED

I was able to solve it by updating my Entity Framework to version 6, and using Maptostoredprocedures. But I’m still looking for an Annotation that envelops my property with the return column of proc, just by perfumery same.

Answer 1

You can map a Dbset to a storedprocedure in context

public DbSet<Dados> Dados { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
     modelBuilder.Entity<Dados>().MapToStoredProcedures();
}

I will leave as reference this file of Renato Haddad in MSDN talking about Stored Procedures in EF: https://msdn.microsoft.com/pt-br/library/dn720414.aspx