Set CommandTimeout on PagedQuery
Closed this issue · 2 comments
I see that you have provided a solution for Query< T > method in Issue#36. However, I would like to use that in batch oriented query resultsets. How can I accomplish that?
I am trying the following with no luck:
db.WithSql(sql).Apply(cmd=>cmd.CommandTimeout = 200);
PagedResult< myClass > rez = db.PagedQuery(skip, take, sql);
This still times out after default 30 seconds. I believe, I should be able to get that going if I would be able to do the following:
db.WithSql(sql).Apply(cmd=>cmd.CommandTimeout = 200).PagedQuery< myClass >(skip, take);
but this is not available in SqlFu ver. 2.3.5.0
Do you plan on providing that functionality for SqlFu?
Do you have something I can use as a work around?
It won't work since PagedQuery executes 2 queries and you can't share settings between helpers. The only workaround is to rewrite (copy/paste) the helper to accept a timeout.
Coolio, I will do that. It is only one time use application so I do not need to maintain SqlFu with that change being present. Thanks!!