[Source] ef uses System.Data.Entity.DbFunctions.DiffDays to query the data for the current day and yesterday

linq/ef framework Lambda expression where query for today's date
http://www.itsvse.com/thread-3093-1-1.html
(Source: Architect)

SELECT
    [GroupBy1]. [A1] AS [C1]
    FROM ( SELECT
        COUNT_BIG(1) AS [A1]
        FROM [dbo]. [ITSVSE] AS [Extent1]
        WHERE 0 = (DATEDIFF (day, [Extent1].[ CreateTime], SysDateTime()))
    )  AS [GroupBy1]

SELECT
    [GroupBy1]. [A1] AS [C1]
    FROM ( SELECT
        COUNT_BIG(1) AS [A1]
        FROM [dbo]. [ITSVSE] AS [Extent1]
        WHERE 1 = (DATEDIFF (day, [Extent1].[ CreateTime], SysDateTime()))
    )  AS [GroupBy1]