Using SQL Azure Firewall API

As we learnt from Chapters 2, SQL Azure Services and Chapter 3, Working with SQL Azure Databases from Visual Studio 2008, SQL Azure Firewall is the main line of defense and mandatory for SQL Azure. The firewall is defined by a name, a start IP Address, and an End IP Address. These are stored in the master database of the SQL Server in the table sys.firewall_rules. In order to retrieve the firewall rules we need to connect to SQL Azure and retrieve the columns of the table sys.firewall_rules. These can be retrieved programmatically as shown in this Program.cs file of a C# console project:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace GetFirewallRules
{
class Program
{
static void Main(string[] args)
{
String conStr="Data Source=<your server name>.database.windows.net;Initial Catalog=master;User ID=<your usrename>;Password=<your password>";
SqlConnection conn = new...