Change the CommandTimeout to a WebMatrix Database query

0

Someone knows how to increase the CommandTimeout in a query by using the class Database from WebMatrix, internally creates a sqlCommand object with a default time of 30 seconds.

My code is similar to the following:

var db = Database.Open("Bdd1");
var result = db.Query("SELECT x, y,z FROM FuncionQueTarda");

The function takes little more than 1 minute, and it obtains information from several databases and joins them in one result.

Thanks for your help.

    
asked by AlejandroMedina 13.06.2018 в 19:22
source

0 answers