Setting CommandTimeout in Dapper.NET?

Question

I'm trying to start SQL backup through a stored procedure through Dapper (the rest of my application uses Dapper, so I would prefer this part to work through it as well). It works fine until CommandTimeout appears.

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 parameter that I know of is in SqlCommand. Is there any way to install this through Dapper?

Answer 1

Yes, there are several versions of the Execute function. One (or more) of them contains 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

Answer 2

An example from the original question with the accepted answer is added if someone wants it. (Timeout set to 60 seconds):

 using (var c = SqlConnection(connstring)) { c.Open(); var p = new DynamicParameters(); // fill out p c.Execute("xp_backup_database", p, commandTimeout: 60, commandType: CommandType.StoredProcedure); }