SqlSugarCore（5.1.4.205）没有OuterApply这个方法，是怎么回事？如何解决？ 返回

努力 发布于2026/3/18

悬赏：0 飞吻

收藏

热忱回答（3）

• fate sta VIP0

  2026/3/18

  这个暂时没有

  0 回复
• 努力 VIP0

  2026/3/18

    var windowStart = windowEnd.AddMinutes(-5);            var bufferMinutes = 10;            var sql = @"                SELECT 
                      b.partition_id,                    b.equipment_id,                    b.bind_type,                    ISNULL(ef.forward_flow, 0) AS EndRead,                    ISNULL(sf.forward_flow, 0) AS StartRead,                    DATEDIFF(MINUTE, sf.read_date, ef.read_date) AS TimeDiff                FROM Dma_Device_Bind b WITH (NOLOCK)                OUTER APPLY (                    SELECT TOP 1 forward_flow, read_date                    FROM Gis_ReadHistoryData_Flow ef WITH (NOLOCK)                    WHERE ef.device_id = TRY_CAST(b.equipment_id AS BIGINT)                      AND ef.read_date <= @windowEnd                      AND ef.read_date >= DATEADD(MINUTE, -@buffer, @windowEnd)                    ORDER BY ef.read_date DESC                ) ef                OUTER APPLY (                    SELECT TOP 1 forward_flow, read_date                    FROM Gis_ReadHistoryData_Flow sf WITH (NOLOCK)                    WHERE sf.device_id = TRY_CAST(b.equipment_id AS BIGINT)                      AND sf.read_date <= @windowStart                      AND sf.read_date >= DATEADD(MINUTE, -@buffer, @windowStart)                    ORDER BY sf.read_date DESC                ) sf                WHERE b.partition_id = @partitionId AND b.is_deleted = 0";            var devices = await _sugarContext.Db.Ado.QueryAsync<DeviceFlowRaw>(sql, new            {                partitionId,                windowEnd,                windowStart,                buffer = bufferMinutes            });

  


  这个SQL我应该如何解决？

  0 回复
• 努力 VIP0

  2026/3/18

  @fate sta：没有其他办法了么？

  0 回复