开发者

Timeout exception in ExecuteStoreQuery function of LINQ to ENTITY

I have an MVC application in this i am using ExecuteStoreQuery to execute the dynamical query for LINQ to entity.

I am getting timeout exeption for large number of recods about 12000 but working fine for small number.

But the same query if i execute by writing the LINQ it is working fine.

I have also added default command timeout=600000 in the connection string but is taking too long to execute the query about 20 to 25 min.

What can i do to execute the query faster as the same result is appearing faster using the LINQ query.

I want to use the ExecuteStoreQuery as my table name is created dynamically. eg: "select * from "+tablename;开发者_开发技巧 Then using the entity model and ExecuteStoreQuery executing the above query and then reading the records.

But taking too long for large number of records.

So,how can i get the large records using ExecuteStoreQuery with faster execution speed.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜