[C#]SQL to Linq 변환 - "IN"절 사용

SQL to Linq - "IN"절 사용

(SQL to Linq Convert - SQL “IN” clause)

 

Linq에서 SQL의 IN 쿼리(IN 절)은

 

아래와 같이 사용하면 됩니다.

 

public class ITEM
{
    public int SEQ { get; set; }
    public string ITEM_EVENT { get; set; }
    
    public ITEM(int seq, string itemEvent)
    {
        this.SEQ = seq;
        this.ITEM_EVENT = itemEvent;
    }
}

var eventList = new List<ITEM>();
eventList.Add(new ITEM(1, "01"));
eventList.Add(new ITEM(2, "02"));
eventList.Add(new ITEM(3, "01"));
eventList.Add(new ITEM(4, "03"));
eventList.Add(new ITEM(5, "02"));
eventList.Add(new ITEM(6, "04"));
eventList.Add(new ITEM(7, "05"));
eventList.Add(new ITEM(8, "06"));
eventList.Add(new ITEM(9, "01"));

/*
* 
* same expression
* WHERE IN ("01", "02", "03")
*
*/

string[] getEventList = { "01", "02", "03" };

var myEventList = 
( from list in eventList 
  where getEventList.Contains(list.ITEM_EVENT) 
  select list
).ToList();