SQLKata嵌套查询-如何在c#中使用sqlkata for sqlserver来编写查询代码？

Question

如何在c#中使用sqlkata for sqlserver为下面的查询编写代码？

SELECT [t0].Region
FROM ((select * from [dbo].Demo_ReportData )) AS [t0]
GROUP BY [t0].Region
ORDER BY [t0].Region ASC
offset 0 rows fetch next 50 rows only;

Answer 1

要使用offset fetch语法，必须在SqlServerCompiler上将UseLegacyPagination设置为false。

var compiler = new SqlServerCompiler { UseLegacyPagination = false };

var innerQuery = new Query("Demo_ReportData");
var query = new Query().From(innerQuery.As("t0"))
    .GroupBy("Region")
    .OrderBy("Region")
    .Take(50);

var result = compiler.Compile(query);
var sql = result.Sql;
var bindings = result.Bindings;