Glimpse with Dapper

BaseRepository.cs

 public abstract class BaseRepository
{
    internal static async Task<List<T>> Query<T>(string sql, object param = null)
    {
        //we use DbProviderFactories instead of SqlConnection so we can get nice results in Glimpse under SQL tab
        var factory = DbProviderFactories.GetFactory(new SqlConnection());
        using (var connection = factory.CreateConnection())
        {
            connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            var results = await connection.QueryAsync<T>(sql, param);
            return results.ToList();
        }
    }
}