public async Task <IEnumerable <User> > GetAllAsync() { string query = "SELECT * FROM users;"; await _connection.OpenAsync(); var users = await _connection.ExecuteReaderAsync <User>(query); _connection.Close(); return(users); }