Using SqlCommandProvider with custom timeout

Question

I am a big fan of SqlCommandProvider type provider but I am constantly hitting timeout problems with a bit more resource demanding queries. I set connection timeout in connection string to some bigger value but this still doesn't help me with my queries timing out since that is only for the connection part not for command timeout.

One solution would be to use AsSqlCommand set CommandTimeout and execute reader but that somewhat kills the point of using the SqlCommandProvider.

Any idea how can I set the timeout in constructor / execute?

Vasily Kirichenko · Accepted Answer · 2014-12-25 14:17:32Z

4

Timeout support was implemented recently, see https://github.com/fsprojects/FSharp.Data.SqlClient/blob/master/src/SqlClient.Tests/TypeProviderTest.fs#L119

answered Dec 25, 2014 at 14:17

Vasily Kirichenko

6715 silver badges13 bronze badges

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

1 Comment

Nafis Islam Over a year ago

new link: github.com/fsprojects/FSharp.Data.SqlClient/blob/…

Collectives™ on Stack Overflow

Using SqlCommandProvider with custom timeout

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related