The query building for Get/GetAsync do simple string formatting to include the property name for the primary key of the table instead of formatting the escaped column name.
For example, a property named Key with the ExplicitKeyAttribute should work but fails because KEY is a reserved SQL keyword. The column name should be included as WHERE [Key] = @id instead.
https://github.com/DapperLib/Dapper.Contrib/blob/cf24f6bdc577b1e071c3764ddfb2cf3382531405/src/Dapper.Contrib/SqlMapperExtensions.Async.cs#L33
The query building for
Get/GetAsyncdo simple string formatting to include the property name for the primary key of the table instead of formatting the escaped column name.For example, a property named
Keywith theExplicitKeyAttributeshould work but fails becauseKEYis a reserved SQL keyword. The column name should be included asWHERE [Key] = @idinstead.