Ángel.G • 7/16/2019

Dapper | Avoid parentheses in SQL statement when using IN clause

This technical blog post details a common error when using the Dapper ORM with SQL IN clauses and collection parameters. The author explains that passing a collection (e.g., an array) as a parameter and writing `IN (@values)` causes Dapper to generate invalid SQL with double parentheses. The correct solution is to write the query as `IN @values` without parentheses, letting Dapper handle the proper syntax.

0 comments

#sql #orm #Dapper