var marketDetails = from detail in _marketDetailRepository.GetAll().Where(s => s.MarketNo == no && s.IsDeleted == false)
join specification in _productSpecificationRepository.GetAll().Where(t => t.IsDeleted == false)
on detail.SpecificationNo equals specification.SpecificationNo
join productType in _productTypeRepository.GetAll().Where(t => t.IsDeleted == false)
on specification.Type equals productType.TypeNo
join unit in _measuringUnitRepository.GetAll().Where(t => t.IsDeleted == false)
on specification.UnitNo equals unit.UnitNo
select new MarketDetailDto
{
Id = detail.Id,
SpecificationNo = specification.SpecificationNo,
SpecificationName = specification.SpecificationName,
Specification = specification.Specification,
Price = specification.PurchasePrice,
Type = productType.TypeName,
Unit = unit.UnitName,
Number = detail.Number,
};