Question
I need to increase the timeout on this stored procedure's execution to 90 secs (default is 30).
using (var conn = db.GetOpenConnection())
{
data = conn.Query<DataPoint>(
@"dbo.sp_xxxxxxxx",
parameters,
commandType:CommandType.StoredProcedure
).ToList();
}
Can you suggest how to do it?
Popular Answer
It looks like, you are using Dapper. You can pass commandTimeout: 90 as parameter to query method to overwrite default setting.
using (var conn = db.GetOpenConnection())
{
data = conn.Query<DataPoint>(
@"dbo.sp_xxxxxxxx", parameters,
commandType:CommandType.StoredProcedure, commandTimeout: 90).ToList();
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow