Invalid column name 'RowIndex'
Closed this issue · 0 comments
ricoisme commented
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);
謝謝