问超时已过期。在使用Dapper从连接池获取连接之前已经过超时时间

EN

public async Task<List<Results>> GetDBResults(string Id, int skip, int take)
{
    var values = new DynamicParameters();
    values.Add("Id", Id);
    values.Add("Skip", skip);
    values.Add("Take", take);        
    using var connection = GetConnection(AppSettingsProvider.TryGet("ConnectionString"));
               
    try
    {
        var sw = Stopwatch.StartNew();
        //connection.Open();
        // QueryAsync is from Dapper
        var dbResult = await connection.QueryAsync<ResponseObject>("SP_name", param: values,
                         commandType: CommandType.StoredProcedure, commandTimeout: Constants.CommandTimeout);
        var result= dbResult?.ToList();
        Console.WriteLine("execution time = {0} seconds\n", sw.Elapsed.TotalSeconds);
        return result;
    }
    finally
    {
        connection.Close();                             
    }
}
       
private SqlConnection GetConnection(string connectionString)
{
    var sqlConnection = new SqlConnection(connectionString);
    return sqlConnection;
}