如何在LINQ中使用分区？

I'm confused about how to change this query to LINQ

我对如何将此查询更改为LINQ感到困惑

  select 
     CONTENT
  from
     (    
        select 
           CONTENT,
           CAM_ID,
           max(CAM_ID) over (partition by DOCUMENT_ID) MAX_ID
        from    
           T_CAM_REVISION
        where 
           DOCUMENT_ID = '101'
     )
  where     
     CAM_ID = MAX_ID

so I can get a single value of content.

所以我可以获得单一的内容价值。

1 个解决方案

#1

There is no way to do max(...) over (...) in LINQ. Here is an equivalent query:

在LINQ中没有办法在(...)上执行max(...)。这是一个等效的查询:

var maxCamID =
    context.T_CAM_REVISION
    .Where(rev => rev.DOCUMENT_ID == "101")
    .Max(rev => rev.CAM_ID);

var query =
    from rev in context.T_CAM_REVISION
    where rev.CAM_ID == maxCamID
    where rev.DOCUMENT_ID == "101"
    select rev.CONTENT;

If you want only a single result:

如果您只想要一个结果:

var result =
    context.T_CAM_REVISION
    .First(rev => rev.CAM_ID == maxCamID
               && rev.DOCUMENT_ID == "101")
    .CONTENT;

#1