Learn how to use table-valued parameters (TVPs) in T-SQL stored procedures, their advantages and limitations, and how to handle complex scenarios with TVPs.

In an earlier column, I suggested that one way to speed up your application was to reduce the trips you make to your database, specifically by avoiding calling a stored procedure multiple times.To ...

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.

The same SQL file should be parsed by application and provided to generated class' constructor as Map<String, String>. To parse plain sql file typed-queries-common library (parser sources, javadocs) ...