EntityFramework SQLQuery Dynamic Type at Runtime

Question

Im just wondering if there is a way to run a string based SQL query against the dbContext and inspect the objects coming back to give the object a type at runtime. i.e. I will not know the structure of the SQL string being executed until runtime.

Is this possible?

code example:

My_DataProvidor.DB.Database.SqlQuery<MyDynamicType>("SELECT * FROM CUSTOMER").ToList();

OR

My_DataProvidor.DB.Database.SqlQuery(MyDynamicType,"SELECT * FROM CUSTOMER").ToList();

Thanks

Matt · Accepted Answer · 2012-10-02 21:51:55Z

1

Found the answer. Using a micro-ORM framework like Dapper or massive.

answered Oct 2, 2012 at 21:51

Matt

2,91311 gold badges58 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EntityFramework SQLQuery Dynamic Type at Runtime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related