Dapper fails calling a Stored Procedure that builds a Dynamic SQL statement
Summary A .NET REST API using Dapper fails to execute a specific Azure SQL Stored Procedure that constructs a dynamic SQL string in a single statement. The Stored Procedure works correctly when called via SSMS, OLEDB, and an older Entity Framework-based API. Splitting the string concatenation for the dynamic SQL into multiple statements resolves the … Read more