Web API and Stored Procedures
General approach to build Web API without models, doesn't give the full web API capabilities.

E.g: 


Help: You cannot have Web API help generated automatically.
You cannot return error handling scenarios: status, message


If you don't want to create the DTOs (Models), you can use the dynamic types. JSON formatter works well with the dynamic types.