DotNetNext/SqlSugar

Invalid column name 'RowIndex'

Closed this issue · 0 comments

hi
我使用無實體分頁查詢,會發生Invalid column name 'RowIndex'錯誤
程式碼如下

var sql="select * from dbo.TransactionHistory with(nolock) where ModifiedDate>=@StartDate and ModifiedDate<@endDate";
var pageNumber=1;
var pageSize=100;

var dt = srcClient.SqlQueryable(sql).AddParameters(parameters)
.ToDataTablePage(pageNumber, pageSize);

謝謝