Using SqlCommandProvider with a custom timeout

Question

I am a big fan of the type provider SqlCommandProvider, but I constantly run into timeout problems with more complex resource requests. I set the connection timeout in the connection string to some larger value, but it still does not help me with the timings of the requests, since this is only for part of the connection, and not for the command timeout.

One solution would be to use AsSqlCommandset CommandTimeoutand do the reading, but this somewhat kills the point of use SqlCommandProvider.

Any idea how to set a timeout in the constructor / execute?

Answer 1

- , . https://github.com/fsprojects/FSharp.Data.SqlClient/blob/master/src/SqlClient.Tests/TypeProviderTest.fs#L119