And for those who prefer that approach, and SQL Server version 2014 and lower where JSON is not supported, the framework supports building JSON in the service layer, plus you...

Casing is very important, and throughout the api the case depends on the object type. For JSON the mapping is camelCase, or in this case orderId vs ORDER_ID. ...

Can you email the full trace on the error you are receiving?

I'll be happy to help you through it.

alan.h.hyneman@gmail.com

Sql server is cheep compared to the cost of building software.

Compare writing a stored procedure vs

a) Write the query

b) Write the endpoint

c) Write the object at the endpoint

d) Create the...

I built the tools for the way we work, Stack overflow built dapper for the way they work. Entity framework is out there and no one would dispute the usefulness...

No problem SS, by the way, the nugget package is done, be sure to follow the instructions in the read me.

Part 4 is in the publish queue.

Its really about the TEAM thing here. As an SQL developer I try to make things as easy as possible for the callers of routines, and the annotations help...

It will work for other version, however the serialization would be limited to single entities. The full docs are included in the git project but basically you would call...

Thank You lulian.

I thought that since it made sense for me, and streamlined my code, that others might benefit.

For even more fun why not output into a memory optimized udt and do some additional processing with it, get some metrics around performance differences between outputting to temp vs...