using Microsoft.Data.SqlClient;

using System.Data;

using System;

​

Console.WriteLine("started");

​

try

{

    SqlConnection connection = new SqlConnection("Server=tcp:profisee03102025163624.database.windows.net;Database=Profisee;Authentication=Active Directory Default;TrustServerCertificate=True"); // system-assigned identity

    connection.Open();

​

    //run stag sproc

    using (SqlCommand command = new SqlCommand("stg.ptest_Merge", connection))

    {

        command.CommandType = CommandType.StoredProcedure;

        command.ExecuteNonQuery();

    }

}

catch (Exception ex)

{

    var err = ex.Message;

    Console.WriteLine($"Error: {err}");

}

​

​

Console.WriteLine("stag is run");