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'.
In Snowflake, query parameters do not start with
@.They either start with
:or are anonymous (?).Dapper supports it (there is even
Dapper.SqlMapper.Settings.UseIncrementalPseudoPositionalParameterNamessetting).However, Dapper.Contribs'
Get()method has@hardcoded, which causes Snowflake error likeSQL compilation error: syntax error line 1 at position 45 unexpected '@id'.