SqlConnection Class

System.Data.SqlClient

Represents an open connection to a SQL Server data source.

Inheritance: Object > MarshalByRefObject > DbConnection > SqlConnection

Syntax

public sealed class SqlConnection : DbConnection

Remarks

The SqlConnection class is used to establish a connection to a Microsoft SQL Server database. You can use it to execute commands and retrieve data from the database.

The ConnectionString property specifies the source of data to which the user is to be connected. It is a string that includes various attributes, such as the server name, database name, and authentication details.

For more information on connection strings, refer to the official SQL Server documentation.

🛠️

Constructors

SqlConnection() - Initializes a new instance of the SqlConnection class.
SqlConnection(string connectionString) - Initializes a new instance of the SqlConnection class with the specified connection string.
Parameters:
connectionString String - The connection string to use for connecting to the data source.

🗄️

Properties

ConnectionString (get; set;)
String

Gets or sets the string used to open the connection to the data source.
ConnectionTimeout (get;)
Int32

Gets the time-out period (in seconds) for establishing a connection to the data source.
Database (get;)
String

Gets the name of the database to which the client is connected.
DataSource (get;)
String

Gets the server name to which the client is connected.
State (get;)
ConnectionState

Gets the current state of the connection.

⚙️

Methods

Open()
Opens a database connection with the properties and configuration specified by the ConnectionString.
Close()
Closes the connection to the data source.
CreateCommand()
SqlCommand

Creates and returns a SqlCommand object associated with the SqlConnection.
Dispose()
Releases the unmanaged resources and disposes of the object.

📢

Events

StateChange (EventHandler<StateChangeEventArgs>)
Occurs when the State property changes.