public async Task <OrderEntity> GetById(long id) { var query = "SELECT * FROM product WHERE id = @id"; var param = new { @id = id }; var result = await DbQueryAsync <dynamic>(query, param); return(OrderEntityMapper.MapToProductEntities(result).FirstOrDefault()); }
public async Task <IEnumerable <OrderEntity> > GetAll() { var query = $"SELECT * FROM product"; if (pageSize != null) { query += $"{Environment.NewLine} LIMIT {pageSize}"; if (pageNumber != null) { query += $" OFFSET {pageSize * pageNumber}"; } } var result = await DbQueryAsync <dynamic>(query); return(OrderEntityMapper.MapToProductEntities(result)); }