C# Класс Wix.SonarQube.SqlServerHelper

Открытые методы

Метод	Описание
CreateSqlConnectionWithSqlLogin ( string dataSource, string username, string password, string databaseName = null ) : SqlConnection	Creates sql connection object with sql login
CreateSqlConnectionWithWindowsLogin ( string dataSource, string databaseName = null ) : SqlConnection	Create SqlConnection object for windows authentication
IsSqlServerInstalled ( ) : bool	Checks if sql is already installed on the machine
TestSqlConnectionWithSqlServerLogin ( string dataSource, string username, string password ) : bool	Tries to connect to sql database with user provided credentials
TestSqlServerConnectionWithWindowsLogin ( string dataSource ) : bool	Tries to connect to sql database with windows login.

Метод	Описание
CheckSqlServer ( RegistryKey instanceKey ) : bool

Creates sql connection object with sql login

public static CreateSqlConnectionWithSqlLogin ( string dataSource, string username, string password, string databaseName = null ) : SqlConnection
dataSource	string
username	string
password	string
databaseName	string
Результат	System.Data.SqlClient.SqlConnection

Create SqlConnection object for windows authentication

public static CreateSqlConnectionWithWindowsLogin ( string dataSource, string databaseName = null ) : SqlConnection
dataSource	string
databaseName	string
Результат	System.Data.SqlClient.SqlConnection

Checks if sql is already installed on the machine

public static IsSqlServerInstalled ( ) : bool
Результат	bool

Tries to connect to sql database with user provided credentials

public static TestSqlConnectionWithSqlServerLogin ( string dataSource, string username, string password ) : bool
dataSource	string
username	string
password	string
Результат	bool

Tries to connect to sql database with windows login.

public static TestSqlServerConnectionWithWindowsLogin ( string dataSource ) : bool
dataSource	string
Результат	bool