dynamically ExecuteStoreQuery

Question

Hi

I using entity framework, in my Web UI i need to run the query and stored procedure dynamically. I try to use the ctx.ExecuteStoreQuery<T>.  When i give TElement correctly it retun the result correctly. In my case i need dynamically. How i handle this.

Answer 1

Hi ArunPrakash82;

You could create a generic method and call it with the correct parameters. For example 

// Generic method
static public List<T> GetResults<T>(T element, ObjectContext ctx, string cmd)
{
    // List of T elements to be returned.
    List<T> results = null;

    // Execute the query
    results = ctx.ExecuteStoreQuery<T>(cmd, null).ToList();

    // Return the results
    return results;
}

To execute this method you would do something like this.

// Create the ObjectContext
var ctx = new MyEntities();

string cmd = @"Select * FROM MyTable1s";
var resultList = GetResults(new MyTable1(), ctx, cmd);

cmd = @"Select * FROM MyTable2s";
var resultList2 = GetResults(new MyTable2(), ctx, cmd);

cmd = @"Select * FROM MyTable3s";
var resultList3 = GetResults(new MyTable3(), ctx, cmd);

  

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

Hi Fernando,

The generic method is okay. But in my situation i didn't know what table i used in the UI layer. 

Answer 3

  

When you are about to execute the, ExecuteStoreQuery, you will know what table you will be using, it is in the SQL Select string statement.

  

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 4

It doesn't return proper type unless I indicate explicitly as T. If I call GetResult<MyTable1>(new MyTable(), ctx, cmd) it return me result type MyTable1. If I call GetResult(new MyTable(), ctx, cmd) it returns object and I cannot do anything after that. The question is: how can I pass variable of type Type as T?