Devart Forums

Code: Select all

 var zzz = ctx.MACSKAs.AsNoTracking()
    .Select(
        e => new
        {
            e.VWMACSKAVALIDITY.MCSVALIDFROM,
            e.ZEBRA.NAME                     
        }
    ).Take(5).ToList();

Code: Select all

SELECT 
"Limit1".C1,
"Limit1".MCSVALIDFROM,
"Limit1".NAME
FROM ( SELECT 
	"Extent2".MCSVALIDFROM,
	"Extent3".NAME,
	1 AS C1
	FROM   IPREF.MACSKA "Extent1"
	LEFT OUTER JOIN IPREF.VW_MACSKA_VALIDITY "Extent2" ON "Extent1".MACSKAID = "Extent2".MACSKAID
	INNER JOIN IPREF.ZEBRA "Extent3" ON "Extent1".ZEBRAID = "Extent3".ZEBRAID
	WHERE  ROWNUM <= 5
)  "Limit1"

Code: Select all

  ctx.MACSKAs.AsNoTracking()
                    .Select(
                        e=>new
                        {                            
                            e.ZEBRA.NAME,
                            e.VWMACSKAVALIDITY.MCSVALIDFROM,
                        }
                    ).Take(5).ToList();

Code: Select all

SELECT 
"Limit1".C1,
"Limit1".NAME,
"Limit1".MCSVALIDFROM
FROM ( SELECT 
	"Extent3".NAME,
	"Extent4".MCSVALIDFROM,
	1 AS C1
	FROM    IPREF.MACSKA "Extent1"
	LEFT OUTER JOIN IPREF.VW_MACSKA_VALIDITY "Extent2" ON "Extent1".MACSKAID = "Extent2".MACSKAID
	INNER JOIN IPREF.ZEBRA "Extent3" ON "Extent1".ZEBRAID = "Extent3".ZEBRAID
	LEFT OUTER JOIN IPREF.VW_MACSKA_VALIDITY "Extent4" ON "Extent1".MACSKAID = "Extent4".MACSKAID
	WHERE  ROWNUM <= 5
)  "Limit1"