|
sql = $"SELECT * FROM {name} WHERE {key.Name} = @id"; |
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.
Dapper.Contrib/src/Dapper.Contrib/SqlMapperExtensions.Async.cs
Line 33 in cf24f6b
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.