Create and access an Azure SQL Database

In this screencast we'll create an Azure SQL database and connect to it via ADO.NET using a DataReader.

This main focus here is to show you how to create a database in Azure and how you can manage it much in the same way you would manage a SQL database on premise.

We'll create the database, a server to host it, configure the IP addresses allowed to connect to it, then in SQL management studio we'll run a script to create some tables and populate them with some data. Then we'll create a simple console application which uses ADO.NET DataReader to retrieve data from the database.

In subsequent screen-casts we'll access the database using in other ways, such as LINQ to SQL and the Entity Framework which will allow us to compare and contrast some of the new different data access capabilities we have available to us today.

Download the project code here.