Devart Forums

Code: Select all

CREATE TABLE MYMODEL.TESTIDS (
   ID NUMBER(20) NOT NULL,
   NAME VARCHAR2(6 CHAR) NULL,
   CONSTRAINT PK_TESTIDS PRIMARY KEY (ID)
);   

Code: Select all

var idlist = new List<decimal>();
 decimal startId = 12345678901234567890M;  //(20digits)
 for (decimal i = 0; i < 1200; i++)
    idlist.Add(startId + i);

using ( DbContext ctx = MyModel.GetNewContext())
 {
    var resultq = ctx.Set<TESTIDS>().Where(x => idlist.Contains(x.ID));
    var result = resultq.ToList();
 }

Code: Select all

SELECT 
"Extent1".ID,
"Extent1".NAME
FROM TACTICAL.TESTIDS "Extent1"
WHERE ("Extent1".ID IN (12345678901234567890)) OR ("Extent1".ID IN (12345678901234568402))