Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) QueryExpression or Lin...

QueryExpression or Linq for the SQL

(0) Share

Report

Posted on by Community Member Microsoft Employee

I would like to convert this SQL to QueryExpression or LINQ. Can someone help with this.

SELECT billedchg, cMaster.name as cpt_code, cCode.name, pricing_factor
       FROM cMaster
       JOIN fSchedule on cMaster.feeschedule_id = fSchedule.id
       JOIN CarFSchedule ON CarFSchedule.feeschedule_id = fSchedule.id
       JOIN Car on Car.id = CarFSchedule.carrier_id
       JOIN cCode ON cMaster.cpt_id = cCode.id AND cMaster.name = cCode.name
       WHERE ISNULL(cMaster.deleted,0) <> 1
       AND '?' between cMaster.effective_date AND ISNULL(cMaster.expire_date, '9000-01-01')
       AND Car.id = '?' AND cCode.name in ({$codeString})
       AND cMaster.support <> 'no'
       order by billedchg desc

Thanks in advance,

Pranav

*This post is locked for comments