Devart Forums

Code: Select all

decimal i = entity.TblTest.OrderByDescending(ir => ir.StampStart)
                .ThenByDescending(ir => ir.Amount)
                .First(ir => ir.TblTestHead.OIDTestHead == OIDTestHead                  
                     && ir.StampStart <= transDate
                     && ir.Amount <= amount).Amount;

Code: Select all

SELECT 
"Limit1"."C1",
"Limit1"."StampStart",
"Limit1"."Amount",
"Limit1"."OIDTestHead"
FROM ( SELECT 
	"Extent1"."OIDTest",
	"Extent1"."StampStart",
	"Extent1"."Amount",
	1 AS "C1"
	FROM public."TblTest" AS "Extent1"
	WHERE (("Extent1"."OIDTestHead" = 1) AND ("Extent1"."StampStart" <= '2010-12-17')) AND (( CAST("Extent1"."Amount" AS numeric)) <= 12299.18)
	LIMIT 1 
)  AS "Limit1"

Code: Select all

SELECT 
"Limit1"."C1",
"Limit1"."StampStart",
"Limit1"."Amount",
"Limit1"."OIDTestHead"
FROM ( SELECT 
	"Extent1"."OIDTest",
	"Extent1"."StampStart",
	"Extent1"."Amount",
	1 AS "C1"
	FROM public."TblTest" AS "Extent1"
	WHERE (("Extent1"."OIDTestHead" = 1) AND ("Extent1"."StampStart" <= '2010-12-17')) AND (( CAST("Extent1"."Amount" AS numeric)) <= 12299.18)
	order by "Extent1"."StampStart" desc, "Extent1"."Amount" desc
	LIMIT 1 
)  AS "Limit1"

Code: Select all

                decimal i = entity.Depts.OrderByDescending(ir => ir.Deptno)
                .ThenByDescending(ir => ir.Loc)
                .First(ir => ir.Dname == "a"
                     && ir.Deptno <= 100).Deptno;

Code: Select all

SELECT 
"Extent1".deptno,
"Extent1".dname,
"Extent1".loc
FROM public.dept AS "Extent1"
WHERE ("Extent1".dname = 'a') AND ("Extent1".deptno <= 100)
ORDER BY "Extent1".deptno DESC, "Extent1".loc DESC
LIMIT 1