how to access the data from SQL Server which is in JSON format using ASP.NET WEB API controller
I have created a stored procedure in SQL Server which returns in json format ALTER PROCEDURE [dbo].[GetAllRoles] AS BEGIN SELECT * FROM dbo.roles FOR JSON PATH; END Output of this stored procedure: [ { "role_id": 101, "role_description": "Trainee" }, {…