如何将SQL IN转换为LINQ [英] how to convert SQL IN to LINQ

问题描述

如何将此转换为LINQ？

How to conver this to LINQ?

SET @APPLED_STATUS      =1
    SET @RECOMMENDED_STATUS =2
    SET @APPROVED_STATUS    =3
    SET @NOTCANCELLED_STATUS=7
    SET @SPLREQUESTED_STATUS = 9
    SET @HRAREQUESTED_STATUS = 12


LR.LeaveStatus_Id IN (@APPLED_STATUS,@RECOMMENDED_STATUS,@APPROVED_STATUS,@NOTCANCELLED_STATUS,@SPLREQUESTED_STATUS,@HRAREQUESTED_STATUS)

我试过这个：

I have tried this:

int APPLED_STATUS   =1;
int RECOMMENDED_STATUS  =2;
int APPROVED_STATUS =3;
int NOTCANCELLED_STATUS=7;
int SPLREQUESTED_STATUS = 9;
int HRAREQUESTED_STATUS = 12;{APPLED_STATUS,RECOMMENDED_STATUS,APPROVED_STATUS,NOTCANCELLED_STATUS,SPLREQUESTED_STATUS,HRAREQUESTED_STATUS}.Contains(LR.LeaveStatus_Id)

但是这个没有工作..

But this is not working..

推荐答案

如果我得到你想要做的事情



来自这个样本SQL

If I get what you are trying to do

from this sample SQL

SELECT *
FROM sampleTable
WHERE id IN (1,2,3,4,7,9)

进入LINQ

into LINQ

 int[] flags = new int[] {1,2,3,4,7,9};
 list<int> data =new list<int>() {1,2,3,4,5,6,7,8,9,0};

 var results = from val in data where flags.Contains(val) == true select val;
</int></int>

如果我错了，请扩展您的问题以便我们提供帮助。

If I am wrong please expand on your question so that we can help.

To将SQL转换为LINQ，你可以使用工具Linqer：

http://sqltolinq.com/ [ ^ ]

To convert SQL to LINQ, you can use the tool Linqer:
http://sqltolinq.com/[^]

这篇关于如何将SQL IN转换为LINQ的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！