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