A Roslyn-based analyzer for SQL related stuff in .NET
Rule\Library | Dapper | ADO.NET | Entity Framework |
---|---|---|---|
SQL001: SQL type is not specified | ✔️ | ||
SQL002: SQL parameters mismatch | ✔️ | ✔️ | |
SQL003: Using 'Query' method is not optimal here | ✔️ | ||
SQL004: Using 'QueryMultiple' method is not optimal here | ✔️ | ||
SQL005: Using 'SaveChanges' method in a loop can affect performance | ✔️ |