C# Extension Method: SqlBulkCopy - GetTransaction | C# Online Compiler

C# Extension Method: SqlBulkCopy - GetTransaction by ZZZ Projects

// C# Extension Method
// Doc: https://csharp-extension.com/en/method/1002786/sqlbulkcopy-gettransaction

// @nuget: Z.ExtensionMethods

using System;
using System.Data.SqlClient;
					
public class Program
{
	public static void Main()
	{		
		using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
			conn.Open();
            SqlTransaction trans = conn.BeginTransaction();

            using (var sqlBulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, trans))
            {
				//C# Extension Method: SqlBulkCopy - GetTransaction
                SqlTransaction result = sqlBulkCopy.GetTransaction();
				
				Console.WriteLine(trans.Equals(result));
			}
        }
	}
}

​x
 
// C# Extension Method
// Doc: https://csharp-extension.com/en/method/1002786/sqlbulkcopy-gettransaction
​
// @nuget: Z.ExtensionMethods
​
using System;
using System.Data.SqlClient;
                    
public class Program
{
    public static void Main()
    {       
        using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
            conn.Open();
            SqlTransaction trans = conn.BeginTransaction();
​
            using (var sqlBulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, trans))
            {
                //C# Extension Method: SqlBulkCopy - GetTransaction
                SqlTransaction result = sqlBulkCopy.GetTransaction();
                
                Console.WriteLine(trans.Equals(result));
            }
        }
    }
}

Unhandled exception. System.Net.Sockets.SocketException (00000005, 0xFFFDFFFF): Name or service not known
   at System.Net.Dns.GetHostEntryOrAddressesCore(String hostName, Boolean justAddresses, AddressFamily addressFamily, Nullable`1 activityOrDefault)
   at System.Net.Dns.GetHostAddresses(String hostNameOrAddress, AddressFamily family)
   at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout) in C:\projects\npgsql\src\Npgsql\NpgsqlConnector.cs:line 634
   at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlConnector.cs:line 517
   at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlConnector.cs:line 381
   at Npgsql.ConnectorPool.AllocateLong(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\ConnectorPool.cs:line 241
   at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<<Open>g__OpenLong|0>d.MoveNext() in C:\projects\npgsql\src\Npgsql\NpgsqlConnection.cs:line 269
--- End of stack trace from previous location ---
   at Npgsql.NpgsqlConnection.Open() in C:\projects\npgsql\src\Npgsql\NpgsqlConnection.cs:line 119
   at Program.Main()
Command terminated by signal 6

Last Run:	2:46:43 am
Compile:	0.402s
Execute:	0.25s
Memory:	18.84Mb
CPU:	0.652s

View IL Code