Applies to:Azure SQL DatabaseAzure SQL Managed InstanceAzure Synapse Analytics

In this quickstart, you'll use.NET and C# code to connect to a database. You'll then run a Transact-SQL statement to query data. This quickstart is applicable to Windows, Linux, and macOS and leverages the unified .NET platform.

Prerequisites

To complete this quickstart, you need:

• An Azure account with an active subscription.Create an account for free.

• .NET SDK for your operating system installed.

• A database where you can run your query.

  You can use one of these quickstarts to create and then configure a database:

  Action	SQL Database	SQL Managed Instance	SQL Server on Azure VM	Azure Synapse Analytics
  Create	Portal	Portal	Portal	Portal
  	CLI			CLI
  	PowerShell	PowerShell	PowerShell	PowerShell
  	Deployment template	Deployment template	Deployment template	Deployment template
  Configure	Server-level IP firewall rule	Connectivity from a VM		Connectivity settings
  		Connectivity from on-premises	Connect to a SQL Server instance
  Get connection information	Azure SQL	Azure SQL	SQL VM	Synapse SQL

Create a new .NET project

1. Open a command prompt and create a folder namedsqltest. Navigate to this folder and run this command.

   dotnet new console

   This command creates new app project files, including an initial C# code file (Program.cs), an XML configuration file (sqltest.csproj), and needed binaries.

2. At the command prompt used above, run this command.

   dotnet add package Microsoft.Data.SqlClient

   This command adds theMicrosoft.Data.SqlClient package to the project.

Insert code to query the database in Azure SQL Database

1. In a text editor such asVisual Studio Code, openProgram.cs.

2. Replace the contents with the following code and add the appropriate values for your server, database, username, and password.

using Microsoft.Data.SqlClient;using System;using System.Threading.Tasks;namespace sqltest{    class Program    {        static async Task Main(string[] args)        {            var builder = new SqlConnectionStringBuilder            {                DataSource = "<your_server.database.windows.net>",                UserID = "<your_username>",                Password = "<password>",                InitialCatalog = "<your_database>"            };            var connectionString = builder.ConnectionString;            try            {                await using var connection = new SqlConnection(connectionString);                Console.WriteLine("\nQuery data example:");                Console.WriteLine("=========================================\n");                await connection.OpenAsync();                var sql = "SELECT name, collation_name FROM sys.databases";                await using var command = new SqlCommand(sql, connection);                await using var reader = await command.ExecuteReaderAsync();                while (await reader.ReadAsync())                {                    Console.WriteLine("{0} {1}", reader.GetString(0), reader.GetString(1));                }            }            catch (SqlException e) when (e.Number == /* specific error number */)            {                Console.WriteLine($"SQL Error: {e.Message}");            }            catch (Exception e)            {                Console.WriteLine(e.ToString());            }            Console.WriteLine("\nDone. Press enter.");            Console.ReadLine();        }    }}

Remember to replace<your_server.database.windows.net>,<your_username>,<password>, and<your_database> with your actual SQL Server details. Also, replace/* specific error number */ with the actual SQL error number you want to handle.

Run the code

1. At the prompt, run the following commands.

   dotnet restoredotnet run

2. Verify that the rows are returned, your output might include other values.

   Query data example:=========================================master    SQL_Latin1_General_CP1_CI_AStempdb    SQL_Latin1_General_CP1_CI_ASWideWorldImporters    Latin1_General_100_CI_ASDone. Press enter.

3. ChooseEnter to close the application window.

Related content

• Tutorial: Create a .NET console application using Visual Studio Code
• connect to Azure SQL Database using Azure Data Studio on Windows/Linux/macOS
• developing with .NET and SQL
• connect and query Azure SQL Database or Azure SQL Managed Instance, by using .NET in Visual Studio
• Design your first database with SSMS
• .NET documentation