Devart Forums

Code: Select all

var prodIDs=GetIDsbyName(prodname).ToList;
var query = from Prod in ctx.G_PRODUCT
                        .Include("G_OLDPRODUCT.G_PROD")
                        where prodIDs.Contains(Prod.PROD_ID)  -- here is a list with numeric items resulted from the subquery
                        && Prod.AKTIV_FLAG == Constants.Yes
                        select pr;

Code: Select all

var query = from Prod in ctx.G_PRODUCT
                        .Include("G_OLDPRODUCT.G_PROD")
                        where
 ctx.Database.SqlQuery<long>
                        (@"SELECT PROD_ID FROM G_PRODUCT
                        CONNECT BY PRIOR PROD_ID = PROD_PROD_ID
                        START WITH PROD_ID = (
                       SELECT PROD_ID FROM G_PRODUCT WHERE PROD_TR_ID = :trId AND AKTIV_FLAG = 'J' AND ROWNUM <= 1))", new OracleParameter("triId", (long)Old.Id)).ToList().Contains(Prod.PROD_ID)
                        && Prod.AKTIV_FLAG == Constants.Yes
                        select pr;