SqlClient Constructor (String)

Nemiro.Data.dll

Initializes a new instance of the SqlClient class.

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

public SqlClient(
	string connectionString
)

public SqlClient(
	string connectionString
)

Public Sub New ( 
	connectionString As String
)

Public Sub New ( 
	connectionString As String
)

Parameters

connectionString: Type: System String
Connection string. For example: user id=;password=;data source=(local);initial catalog= Default value: LocalSqlServer (key name of the connection string in the.config file)

Examples

The following example creates an instance of the SqlClient class with the parameter name in the configuration file that contains the connection string to the SQL Server.

C++

Copy to Clipboard Print

using (SqlClient client = new SqlClient("MyConnectionString"))
{
  // ...
}

using (SqlClient client = new SqlClient("MyConnectionString"))
{
  // ...
}

Using client As New SqlClient("MyConnectionString")
  '... 
End Using

Using client As New SqlClient("MyConnectionString")
  '... 
End Using

Here's the file web.config:

XML

Copy to Clipboard Print

<configuration> 
  <connectionStrings> 
    <add 
      name="LocalSqlServer" 
      connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=example;Trusted_Connection=True;" 
    /> 
  </connectionStrings> 
</configuration>

<configuration> 
  <connectionStrings> 
    <add 
      name="LocalSqlServer" 
      connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=example;Trusted_Connection=True;" 
    /> 
  </connectionStrings> 
</configuration>