[Allikas] ef kasutab System.Data.Entity.DbFunctions.DiffDays, et pärida andmeid käesoleva päeva ja eilse kohta

linq/ef raamistik Lambda avaldis, kus päring tänaseks kuupäevaks
http://www.itsvse.com/thread-3093-1-1.html
(Allikas: Arhitekt)

VALIMA
    [GroupBy1]. [A1] AS [C1]
    FROM ( SELECT
        COUNT_BIG(1) KUI [A1]
        FROM [dbo]. [ITSVSE] AS [Ulatus1]
        KUS 0 = (DATEDIFF (päev, [Extent1].[ CreateTime], SysDateTime()))
    ) AS [GroupBy1]

VALIMA
    [GroupBy1]. [A1] AS [C1]
    FROM ( SELECT
        COUNT_BIG(1) KUI [A1]
        FROM [dbo]. [ITSVSE] AS [Ulatus1]
        KUS 1 = (DATEDIFF (päev, [Extent1].[ CreateTime], SysDateTime()))
    ) AS [GroupBy1]