Dapper.Contrib
Dapper.Contrib copied to clipboard
Snowflake query parameters syntax is not supported
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'.