Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Max parameters exceeded for SQL Server #55

Open
techyian opened this issue Nov 10, 2024 · 0 comments
Open

Max parameters exceeded for SQL Server #55

techyian opened this issue Nov 10, 2024 · 0 comments
Labels
question Further information is requested

Comments

@techyian
Copy link
Owner

ReportViewer.NET uses Dapper and uses parameterised queries. When a user passes more than 2100 items in a report to an IN query, it'll fail as SQL Server's max number of allowed parameters is 2100.

Do we:

a) Check passed list against available options and pass that directly to the SQL query, avoiding parameterising.
b) Keep as is and see this as a difference to what the native MS Report Viewer does

@techyian techyian added the question Further information is requested label Nov 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

1 participant