mjasri

mjasri

  • NA
  • 147
  • 0

Convert this to linq

Jul 29 2020 10:02 AM
Please could you guide me to convert this query to linq
 
 
SELECT hold.*
FROM
[dbo].[wcm_holder] hold
join
[wcm_fields_description] holddetails
on hold.id=holddetails.treeno_id
where
hold.ManagemntID in ( select distinct ManagemntID from [dbo].[wcm_holder] h join [dbo].[Allowed Access] a on h.ParentID=a.allowedTo where privilageID=10 )
and holddetails.fielddescription like '%Apple%'
 

Answers (2)