Clone Method (SqlConnection)

In This Topic

Creates a new object that is a copy of the current instance.

Syntax

Visual Basic
C#

'Declaration
 
Public Function Clone() As SqlConnection

public SqlConnection Clone()

Return Value

A new SqlConnection object.

Remarks

Creates a new SqlConnection object with the properties that have the same values as those of the original object. However, changing properties of the new object has no influence on the values of the same properties of the original object.

Note that state of the new instance is always Closed, regardless of the state of original instance.

Example

This example shows how to clone a SqlConnection. To make sure all the properties are inherited, one of them (UserId) is written to the console.

csharp

public void CloneAConnection()
{
  SqlConnection myConnection = new SqlConnection(
      "User Id=sa;Server=localhost;Initial Catalog=Test;");
  SqlConnection myConnection2 = (SqlConnection)myConnection.Clone();
  Console.WriteLine(myConnection2.UserId);
}

Visual Basic

Public Sub CloneAConnection()
  Dim myConnection As New SqlConnection( _
      "User Id=sa;Server=localhost;Initial Catalog=Test;")
  Dim myConnection2 As SqlConnection = CType(myConnection.Clone(), SqlConnection)
  Console.WriteLine(myConnection2.UserId)
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlConnection Class
SqlConnection Members

Send Feedback