var cn = new SqlConnection("Data Source=.; Initial Catalog=test; Intergrated Security=SSPI;");
cn.Open();
var cmd = new SqlCommand("begin tran; while (1=1) begin insert into t values (1); end; commit transaction;", cn);
System.Data.StatementCompletedEventHandler handler = (object o, System.Data.StatementCompletedEventArgs e) => { Console.WriteLine(e.RecordCount); };
cmd.CommandTimeout = 5;
cmd.ExecuteNonQuery();

declare @p int; while (1=1) begin set @p=1; end;

declare @p int; waitfor delay '00:00:05'; set @p = 1;

begin tran; while (1=1) begin insert into [dbo].[t] values (1); end; commit tran;

 class Program
    {
        static string cns = "Data Source=.;Initial Catalog=test; Integrated Security=SSPI;";
        static string cmds = "begin tran; while (1=1) insert into tx values (1); commit tran;";
        static void Main(string[] args)
        {
            string t = "";
            
            while (t != "0" && t != "1" && t != "2" && t != "3")
            {
                Console.WriteLine("choose provider: 0 - SqlClient; 1-MSSQLClient; 2-ODBC; 3-OLEDB;");
                t = Console.ReadLine();
            }
            
            switch (t)
            {
                case "0": runSQLNCLI(); break;
                case "1": runMSSQLClient(); break;
                case "2": runODBCClient(); break;
                case "3": runOLEDB(); break;
            }

            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
                


        }

        static void runSQLNCLI()
        {
            using var cn = new System.Data.SqlClient.SqlConnection(cns);
            using var cmd = new System.Data.SqlClient.SqlCommand(cmds, cn) { CommandTimeout = 5 };
            try
            {
                cn.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }

        static void runMSSQLClient()
        {
            using var cn = new Microsoft.Data.SqlClient.SqlConnection(cns);
            using var cmd = new Microsoft.Data.SqlClient.SqlCommand(cmds, cn) { CommandTimeout = 5 };
            try
            {
                cn.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }

        static void runODBCClient()
        {
            using var cn = new System.Data.Odbc.OdbcConnection("Driver={SQL Server};Server=(local);Trusted_Connection=Yes;Database=test;");

            using var cmd = new System.Data.Odbc.OdbcCommand(cmds, cn) { CommandTimeout = 5 };
            try
            {
                cn.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }

        static void runOLEDB()
        {
            var cn = new System.Data.OleDb.OleDbConnection("Provider=SQLOLEDB;Server=(local);Database=test;Integrated Security=SSPI");

            var cmd = new System.Data.OleDb.OleDbCommand(cmds, cn) { CommandTimeout = 5 };
            
            try
            {
                cn.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
    }