Accessing SQL Azure Using ADO.NET

2 thoughts on “Accessing SQL Azure Using ADO.NET”

1. I am not able to connect to SQL Azure.

   Here is what my code is:

   using (SqlConnection conn = new SqlConnection("Server=ufh1cinawq.database.windows.net;Database=MASTER;User ID=vksingh24;Password=xxx;Trusted_Connection=False"))
   {
   using (SqlCommand command = conn.CreateCommand())
   {
   conn.Open();

   // Create a table
   command.CommandText = "CREATE TABLE Vikash(Col1 int primary key, Col2 varchar(20))";
   command.ExecuteNonQuery();

   // Insert sample records
   command.CommandText = "INSERT INTO Vikash(col1, col2) values (1, 'Vikash Kumar Singh'), (2, 'Kumar Saurabh'), (3, 'RockStar')";
   int rowsAdded = command.ExecuteNonQuery();

   // Query the table and print the results
   command.CommandText = "SELECT * FROM Vikash";

   using (SqlDataReader reader = command.ExecuteReader())
   {
   // Loop over the results
   while (reader.Read())
   {
   MessageBox.Show(reader["Col1"].ToString().Trim());
   MessageBox.Show(reader["Col2"].ToString().Trim());
   }
   reader.Close();
   }

   conn.Close();
   }
   }

   I also check the firewall setting. Please help me to connect to SQL Azure.

2. Hi,

   You need to properly configure the Firewall settings from within the SQL Azure – Server Administration web page.

   To this end you can add a new Firewall rule, give it a name you like, and in the IP range include your public IP (the "Add Firewall Rule" dialog displays your public IP).

   Then wait for a few minutes and try again.

   I have also noticed that in the connection string you are using the "master" database and then you are trying to create a new table in it. Note that you cannot create a table in the master database as it is a system database. You can create a new database instead and work with it.

   Hope this helps!

   Cheers,
   Artemakis

Comments are closed.