In the process of creating a web service backend for a large web application for Diamler I've come across a few patterns that allow me to provide functionality without bloating my codebase. As the application is largely data driven one of my favorite patterns involves using the SqlProgrammabilityProvider and optional stored procedure parameters. The problem to solve Imagine we have an automobile resource that we want to be able to get by id or do some sort of querying to retrieve a list of them. GET ap[...]