DapperLib/Dapper.Contrib

Snowflake query parameters syntax is not supported

afilatov-st opened this issue · 1 comments

In Snowflake, query parameters do not start with @.
They either start with : or are anonymous (?).
Dapper supports it (there is even Dapper.SqlMapper.Settings.UseIncrementalPseudoPositionalParameterNames setting).

However, Dapper.Contribs' Get() method has @ hardcoded, which causes Snowflake error like SQL compilation error: syntax error line 1 at position 45 unexpected '@id'.

There is a opened PR (#152) to set a custom parameter prefix.