将SQL查询转换为C＃实体框架querry [英] Convert SQL query to C# entity framework querry

问题描述

嗨大家好，
我知道 如何在中写入 / span> sql因为我是db开发人员，但   实体框架c＃可以任何一个帮助我 转换它：
  USE  ITSRMMPRDDBConfig 
  GO  
 
  DECLARE   @ INMemberID  BIGINT = 1， @ InSiteID  BIGINT = 1 
 
  SELECT  RM.RegID，RM.ResourceName，RM.ResFriendlyName，
  CASE   WHEN  RM.RegType = '  DPMA' 那么 '  D. esktop' 
  WHEN  RM.RegType = '  MSMA'  THEN  ' 服务器'  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  和 V.SITEID =  @ InSiteID  
  AND  MV.status = ' 成功' 和 MD.Status = '  SUCCESS'  AND  APP.Stat我们<> 4 
  ORDER   BY  RM.ResourceName 

< br $> b $ b

我尝试过：



尝试在sql中写入查询db开发人员。但不知道如何在实体框架中编写它

解决方案

Linq（EF）查询的语法与sql非常相似。



我建议从这里开始：

实体框架简介 [ ^ ]

LINQ to Entities [ ^ ]

LINQ to Entities中的查询 [ ^ ]

101 LINQ Samp C＃中的文件 [ ^ ]

Linq - 101个样本 - lambda样式 [ ^ ]



试试吧！

当你遇到困难时，回到这里并简要描述你的问题。

只需在背景上使用linq



实体框架查询和查找实体 [ ^ ]

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

What I have tried:

tried to write query in sql as a db developer. but have no idea how to write it in entity framework

解决方案

A syntax of Linq (EF) query is very similar to sql.

I'd suggest to start here:
Introduction to Entity Framework[^]
LINQ to Entities[^]
Queries in LINQ to Entities[^]
101 LINQ Samples in C#[^]
Linq - 101 samples - lambda style[^]

Try!
When you get stuck, come back here and shortly describe your issue.

just use linq on context

Entity Framework Querying and Finding Entities[^]

这篇关于将SQL查询转换为C＃实体框架querry的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！