ADO.Net with Microsoft Data Fabric Sql Endpoint

using Microsoft.Data.SqlClient;

 

// Use your own server, database, and user ID.

// Connetion string - user ID is not provided and is asked interactively.

string ConnectionString = @"Data Source=*******.datawarehouse.pbidedicated.windows.net; Initial Catalog=database;User ID=userid; Connect Timeout=30;Encrypt=True;TrustServerCertificate=False; Authentication=Active Directory Interactive;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";

using (SqlConnection conn = new SqlConnection(ConnectionString))

{

       conn.Open();

       Console.WriteLine("ConnectionString2 succeeded.");

       using (var cmd = new SqlCommand("SELECT @@Version", conn))

       {

            Console.WriteLine("select @@version");

            var result = cmd.ExecuteScalar();

            Console.WriteLine(result.ToString());

       }

}

Console.ReadKey();