Преобразование SQL-запроса в C# entity framework querry

---

Hi Guys,
I know how to write query in sql since i am a db developer but not in entity framework c# can any one help me in converting it :
USE ITSRMMPRDDBConfig
GO

DECLARE @INMemberID BIGINT=1,@InSiteID BIGINT=1

SELECT RM.RegID,RM.ResourceName,RM.ResFriendlyName,
CASE WHEN RM.RegType='DPMA' THEN 'Desktop'
      WHEN RM.RegType='MSMA' THEN 'Server' END ResourceType
FROM Regidattributeslv V WITH (NOLOCK)
INNER JOIN RegMain RM WITH(NOLOCK) ON V.RegID=RM.RegId                  
INNER JOIN MstID MV WITH (NOLOCK)ON MV.Regid = V.RegId  
INNER JOIN MstDatDeviceID MD WITH (NOLOCK) ON MD.OrderID=MV.OrderID
INNER JOIN MstRMMOrderDetails_App APP WITH(NOLOCK) ON APP.OrderID=MD.OrderID AND APP.MemberID=V.MEMBERID
WHERE V.MemberId = @INMemberID  and V.SITEID= @InSiteID
AND MV.status ='SUCCESS' AND MD.Status='SUCCESS' AND APP.Status<>4
ORDER BY RM.ResourceName

Что я уже пробовал:

попробовал написать запрос на sql в качестве разработчика БД. но понятия не имею, как написать его в entity framework

---