public async Task UpdateEstado(string connection) { var date = DateExtensions.GetDate(); using (var cn = new SqlConnection(connection)) { cn.Open(); DynamicParameters parameter = new DynamicParameters(); parameter.Add("@TodayDate", date, DbType.DateTime, ParameterDirection.Input); var result = await cn.ExecuteAsync("[UPDATE_ESTADO_EN_ESPERA_JOB]", parameter, null, null, CommandType.StoredProcedure); } }