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));
}
