Dapper.Contrib icon indicating copy to clipboard operation
Dapper.Contrib copied to clipboard

Snowflake query parameters syntax is not supported

Open afilatov-st opened this issue 2 years ago • 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'.

afilatov-st avatar Feb 22 '23 04:02 afilatov-st