Book Image

ASP.NET Core MVC 2.0 Cookbook

By : Jason De Oliveira, Engin Polat, Stephane Belkheraz
Book Image

ASP.NET Core MVC 2.0 Cookbook

By: Jason De Oliveira, Engin Polat, Stephane Belkheraz

Overview of this book

The ASP.NET Core 2.0 Framework has been designed to meet all the needs of today’s web developers. It provides better control, support for test-driven development, and cleaner code. Moreover, it’s lightweight and allows you to run apps on Windows, OSX and Linux, making it the most popular web framework with modern day developers. This book takes a unique approach to web development, using real-world examples to guide you through problems with ASP.NET Core 2.0 web applications. It covers Visual Studio 2017- and ASP.NET Core 2.0-specifc changes and provides general MVC development recipes. It explores setting up .NET Core, Visual Studio 2017, Node.js modules, and NuGet. Next, it shows you how to work with Inversion of Control data pattern and caching. We explore everyday ASP.NET Core MVC 2.0 patterns and go beyond it into troubleshooting. Finally, we lead you through migrating, hosting, and deploying your code. By the end of the book, you’ll not only have explored every aspect of ASP.NET Core MVC 2.0, you’ll also have a reference you can keep coming back to whenever you need to get the job done.
Table of Contents (26 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Accessing data with SQL Azure


In this recipe, we will access data from a SQL Server hosted on Azure. We talk about a SQL Server Service on Azure, not a virtual machine.

Getting ready

We will connect to our Azure subscription to subscribe to a SQL Azure database.

After creating a SQL Server, we will create a database on this SQL Server. We will create a table and add data to it from Visual Studio 2017. Finally, we will create a web page that consumes our data from our newly created Azure database that we created using SQL.

To do that, we need Visual Studio 2017, with SQL Data Tools installed, and an Azure subscription.

How to do it...

  1. First, we will connect to our Azure subscription.
  2. Next, we will create a SQL Server named dbcookbook:
  1. We select Browse | SQL Servers:
  1. We click on Add, and we fill the SQL Server form to give the server name, admin login, password, subscription, resource group, and location.
  2. To create the server, we click on the Create button at the bottom:

Clicking on the Refresh button...