How to get JSON data from sql server 2016 and send it as it is (using IHttpActionResult) to client by web API

Viewed 10105

After Sql server 2016 we can select data direct as JSON by this statement:

SELECT Top (10) * from  Products FOR JSON AUTO

So we no longer need to assign them to objects and convert them to JSON into code. I think we can reduce the complexity of the process and get better performance. I use web API 2 and I want to receive and direct send it to cleint . Is this any new function or method works with SqlCommand to do this? Cloud you help me please?

1 Answers
Related