解决SQL语句在Dapper执行超时比Query慢的问题

在语句结尾加上 Add OPTION (RECOMPILE) to the end

https://stackoverflow.com/questions/10933366/sp-executesql-is-slow-with-parameters