dapper-rainbow-mysql icon indicating copy to clipboard operation
dapper-rainbow-mysql copied to clipboard

an error of method:Page<T>

Open hhq365 opened this issue 7 years ago • 1 comments

when i use the method by sql with "order by" .. there will be throw an exception... to debug the source.. then i have to change the code line of Page.cs:

var sqlCount = string.Format ("{0} COUNT({1}) {2}", sql.Substring (0, g.Index), count, sql.Substring (g.Index + g.Length));

to be this:

var sqlCount = string.Format ("{0} COUNT({1}) from ({2}) as {3} ", sql.Substring (0, g.Index), count, sql, new Guid().ToString());

can you update this?

hhq365 avatar May 17 '17 02:05 hhq365

i have check on my side cannot reproduce the problem. can you provide minimal test case to reproduce the issue

antonheryanto avatar Aug 27 '17 16:08 antonheryanto