EF Execute Store Query

See more:

C#

entity-framework

Hello,

I am trying to write a visual Query using c#. Main intension behin this is to generate queries from front end and execute them using EF. Here i have a problem. I have success to generate SQL Query including joins and it is working perfect with SQL Server console too.

When i am trying to pass to Entity frame work and trying to execute with ExecuteStoreQuery it is not showing any resutls.

Here i wanted to mention that i do not know which type i do get as a result or i do not know to which table use is trying to execute. tried 3 types commented below.

EntityConnection conn = new EntityConnection(Connstring);

       conn.Open();
       PIAEntity context = new PIAEntity(conn);
       context.CommandTimeout = 6000;
       //var sequenceQueryResult = context.ExecuteStoreQuery(strQuery, null);
       //object lists = context.ExecuteStoreQuery<object>(strQuery);
       //List<PIAEntity> list = context.ExecuteStoreQuery<PIAEntity>(strQuery).ToList();
       dgvResults.DataSource = list;   

Kindly help.

Regards.