public override async Task <IEnumerable <Users> > GetAllAsync() { try { var result = await _factory.GetConnection() .QueryAsync <Users, Phone, Token, Users>($"" + $"Select * From Users " + $"Inner Join Phone on Users.Id = Phone.UserId " + $"Left Join Token on Users.Id = Token.UserId " + $"", map: (users, phone, token) => { if (phone != null) { users.Phones = new List <Phone>(); } users.Phones.Add(phone); if (token != null) { users.Token = token; } return(users); }); return(result.ToList()); } catch (Exception ex) { throw ex; } }
public virtual async Task <IEnumerable <T> > GetAllAsync() { try { var result = await _factory.GetConnection().QueryAsync <T>($"Select * From { typeof(T).Name }"); return(result.ToList()); } catch (Exception ex) { throw ex; } }