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.