public async Task <IEnumerable <Member> > GetAsync() { const string sql = @"SELECT * FROM [experian].[dbo].[Members]"; using (var connection = _connectionFactory.CreateLocalConnection()) { return(await connection.QueryAsync <Member>(sql)); } }