Adjusting CommandTimeout in Dapper.NET?

c# .net timeout dapper
sh-beta picture sh-beta · Jan 9, 2012 · Viewed 50.9k times · Source

I'm trying to run SQL backups through a stored procedure through Dapper (the rest of my app uses Dapper so I'd prefer to keep this portion running through it as well). It works just fine until the CommandTimeout kicks in.

using (var c = SqlConnection(connstring))
{
    c.Open();
    var p = new DynamicParameters();
    // fill out p

    c.Execute("xp_backup_database", p, commandType: CommandType.StoredProcedure);
}

The only CommandTimeout setting I know of is in SqlCommand. Is there a way to set this via Dapper?

Answer

jzacharuk picture jzacharuk · Jan 9, 2012

Yes, there are multiple versions of the Execute function. One (or more) of them contains the commandTimeout parameters:

public static int Execute(this IDbConnection cnn, string sql, 
                dynamic param = null, IDbTransaction transaction = null, 
                            int? commandTimeout = null, CommandType? commandType = null)

Taken from SqlMapper.cs

Related questions

"A timeout was reached while waiting for the service to connect" error after rebooting

I have a custom-written Windows service that I run on a number of Hyper-V VMs. The VMs get rebooted a couple times an hour as part of some automated tests being run. The service is set to automatic start and …

Read More
How to add a Timeout to Console.ReadLine()?

I have a console app in which I want to give the user x seconds to respond to the prompt. If no input is made after a certain period of time, program logic should continue. We assume a timeout means …

Read More
RestSharp Timeout not working

I have a restsharp client and request set up like this: var request = new RestRequest(); request.Method = Method.POST; request.AddParameter("application/json", jsonBody, ParameterType.RequestBody); request.OnBeforeDeserialization = resp => { resp.ContentType = "application/json"; }; request.Timeout = -1; request.ReadWriteTimeout = -1; …

Read More