Our REST Web API service will have the following HTTP methods: We are going to build REST service on a simple Todo table that has four columns: Title, Description, Completed, and TargetDate. I will not use some complex database structure. You can easily rewrite this app in node.js or any other framework if you want. Since I'm using JSON functionalities in Azure SQL Database, my app is very lightweight so I can add some minor changes in the app to fit new framework and still the main logic of JSON/SQL transformation would be unchanged. However, the core principles apply both on ASP.NET Core applications created using. NET Core v1 was released and it should be more stable. NET Framework instead of RC2 Core, because it was more stable at the time of writing this article. NET Core.Īt the time of writing this article, I have used ASP.NET Core RC1 and then upgraded to RC2 that had some small breaking changes that required me to rewrite the app. NET Core is still under development and we might have some breaking change before RTM, so here I'm using. NET Core, if you need minimal environment, that can be used on any platform. In the latest release of ASP.NET, you can create ASP.NET Core web applications using. This REST service is built using new ASP.NET Core framework. What Kind of REST Service are we Going to Build? In this article, we will see how easily we can build ASP.NET Core Web API using Azure SQL Database and new JSON functionalities. With new built-in JSON support in Azure SQL Database, transformation between tables and JSON text becomes extremely easy. This is a good choice for web services that return database data in JSON format, or accept JSON text as parameter and insert JSON into database.
#USING POOR SQL FORMATTER IN AZURE SQL STUDIO HOW TO#
In this article, we will see how to create REST API using ASP.NET Core Web API and new JSON features in Azure SQL Database and SQL Server 2016.Īzure SQL Database and SQL Server 2016 provide built-in JSON support that enable you to easily get data from database formatted as JSON, or take JSON and load it into table.