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?
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();
}