How do I connect with Azure SQL Database

Connecting to an Azure SQL Database using C# requires the use of the ADO.NET library. Below is a simple example demonstrating how to establish a connection and execute a SQL query.

using System; using System.Data.SqlClient; class Program { static void Main() { string connectionString = "Server=tcp:your_server.database.windows.net,1433;Initial Catalog=your_database;User ID=your_username;Password=your_password;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); Console.WriteLine("Connection successful!"); // Example of running a simple query string query = "SELECT TOP 10 * FROM your_table"; SqlCommand command = new SqlCommand(query, connection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader[0].ToString()); } } } } }

Azure SQL Database C# ADO.NET SQL connection connection string execute query

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?