dapper-rainbow-mysql
dapper-rainbow-mysql copied to clipboard
an error of method:Page<T>
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?
i have check on my side cannot reproduce the problem. can you provide minimal test case to reproduce the issue