sql命令转换为linq [英] sql command convert to linq

问题描述

如何在linq中转换此SQL命令

命令是：

 选择  distinct  CLIENT_ID，FirstName，LastName，WorkOrderNumber，Invoice_No，Company，exe_name，EmailId 来自 Client_Info < span class =code-keyword>其中 workordernumber  in （ select  max（workordernumber） 来自 Client_info  group   by  Client_id）（选择 max（Invoice_No）<在中      span class =code-keyword>来自 Client_info  group   by  Client_id）订单 按公司，CLIENT_ID  ASC  

Plz帮助我..



问候，

Ankush Sharma

解决方案

我不知道具体答案，但您的查询需要更正：

  SELECT  CLIENT_ID，FirstName，LastName，MAX（WorkOrderNumber），MAX（Invoice_No），Company，exe_name，EmailId 
  FROM  Client_Info 
  GROUP   BY  CLIENT_ID，FirstName， LastName，Company，exe_name，EmailId 
  ORDER   BY 公司，CLIENT_ID  ASC  

我建议你下载101 Linq样本 [ ^ ]

How I convert This SQL Command in linq
command is:

Select  distinct CLIENT_ID,FirstName,LastName,WorkOrderNumber,Invoice_No,Company,exe_name,EmailId from Client_Info where workordernumber in(select max(workordernumber) from Client_info group by Client_id) and Invoice_No in(select max(Invoice_No) from Client_info group by Client_id) order by Company,CLIENT_ID ASC

Plz help me..

Regards,
Ankush Sharma

解决方案

I don't know the exact answer, but your query need to be corrected:

SELECT CLIENT_ID, FirstName, LastName, MAX(WorkOrderNumber), MAX(Invoice_No), Company, exe_name, EmailId
FROM Client_Info 
GROUP BY CLIENT_ID, FirstName, LastName, Company, exe_name, EmailId
ORDER BY Company, CLIENT_ID ASC

I would suggest you to download 101 Linq Samples[^]

这篇关于sql命令转换为linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！