Closed Grauenwolf closed 2 years ago
https://github.com/dotnet/SqlClient/pull/1041 https://docs.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlcommand.enableoptimizedparameterbinding?view=sqlclient-dotnet-standard-4.1
We probably want to default to turning this on unless we detect an Output or InputOutput parameter. In real world terms it doesn't have an effect unless there are at least 24 parameters. But we can hit that with particularly large rows.
https://github.com/dotnet/SqlClient/pull/1041 https://docs.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlcommand.enableoptimizedparameterbinding?view=sqlclient-dotnet-standard-4.1
We probably want to default to turning this on unless we detect an Output or InputOutput parameter. In real world terms it doesn't have an effect unless there are at least 24 parameters. But we can hit that with particularly large rows.