Clone Method (MySqlConnection)

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Function Clone() As Object

public object Clone()

Return Value

A new MySqlConnection object.

Remarks

Creates a new MySqlConnection 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 MySqlConnection. To make sure all the properties are inherited, one of them (UserId) is written to the console.

csharp

public void CloneAConnection()
{
  MySqlConnection myConnection = new MySqlConnection(
      "User Id=root;Host=localhost;Database=Test;");
  MySqlConnection myConnection2 = (MySqlConnection)myConnection.Clone();
  Console.WriteLine(myConnection2.UserId);
}

Visual Basic

Public Sub CloneAConnection()
  Dim myConnection As New MySqlConnection( _
      "User Id=root;Host=localhost;Database=Test;")
  Dim myConnection2 As MySqlConnection = CType(myConnection.Clone(), MySqlConnection)
  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

MySqlConnection Class
MySqlConnection Members

Send Feedback