Dynamic Attributes of an Entity Model

Navigation
3

I have a procedure that returns a number of dynamic columns , because this procedure uses the Pivot , then the question arises: How to create a Entity Model for this procedure? Example: 

public class SProcedure_EF6Context : DbContext
{    
    public SProcedure_EF6Context() : base("name=SProcedure_EF6Context")
    {
    }

    public DbSet<Medico> Medicos { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        // Criar as Stored Procedures
        modelBuilder.Entity<Medico>().MapToStoredProcedures();
    }
}
    
asked by anonymous 18.05.2017 / 01:51

1 answer

2

.MapToStoredProcedures() is one thing. Mapping a stored procedure with dynamic return is another.

We use .MapToStoredProcedures() when we want the Entity Framework not to generate SQL, but to generate stored procedures and call them in persistence operations. This is common when the database would have known performance issues, such as too large tables and intense data volume, in which it is worthwhile to commit devices from the database itself to optimize operations.

In your case, what you want is to get a dynamic return from a stored procedure using the Entity Framework. In advance I already say that this is not possible unless you take the column relation of a return and generate an object at runtime. It is not very practical and implementation is insane.

So, to solve, you'll need a scheme that expects a dynamic return. ADO.NET is an option. Dapper too . I will make a suggestion in this answer and then you decide the best way forward.

ADO.NET 

SqlDataReader reader = null;
using (SqlCommand cmd = new SqlCommand("MinhaProcedure", contexto.Database.Connection) 
{
    cmd.CommandType = System.Data.CommandType.StoredProcedure;
    reader = cmd.ExecuteReader();
}

Dapper 

IEnumerable<dynamic> resultados = db.Database.Connection.Query("MinhaProcedure", new { Param1 = 1, Param2 = "2" }, commandType: CommandType.StoredProcedure)
    
18.05.2017 / 18:06
Shape size other than programmed Generate random random string in NodeJS