Ensure parameter false positives are detected
Closed this issue · 0 comments
mgravell commented
See DapperLib/Dapper#1914 and DapperLib/Dapper#1971
In analyzer mode (not in generator mode), we should be able to detect the following queries as problematic, i.e. the true parameters are not the same as Dapper is going to assume:
select 'this ? looks like OLE DB'
and
select 'this ?looks? like pseudo-positional
The problem here is that the runtime SQL parser in Dapper detects both of these as meaning the wrong thing; they aren't parameters. Our existing parameter handler in TSQL should be able to detect this.