Table-Valued Parameters Table-valued parameters provide an easy way to marshal multiple rows of data from a client application to SQL Server without requiring multiple round trips or special ...

If a procedure contains table-valued parameters, and the parameter is missing in the call, an empty table is passed in. Parameters can take the place only of constant expressions; they can't be used ...

To enable that, I showed how to pass a stored procedure multiple parameter values in a single call and then, inside the stored procedure, load the parameters into a table where they could be ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

PreparedStatement can be cumbersome to use because its parameters are accessed by index. A relatively simple wrapper can be written that lets you set them by name.

Basically, you can wrap multiple parameters in a single class and use this class as a parameter to your Web API controller method. Here is the updated Web API controller method.