File ManufacturerService,cs
Function   public List<Manufacturer> GetAllManufacturers(bool showHidden)


var query = from m in _context.Manufacturers
                        orderby m.Name,m.DisplayOrder
                        where (showHidden || m.Published) &&
                        !m.Deleted


Bye