C# Класс SonarQubeBootstrapper.Helpers.SqlConnectionExtensions

Показать файл Открыть проект

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

Метод Описание
ChangeSqlUserDbRole ( this connection, string rolename, string username ) : bool

Changes role of the user for given database

Needs connection to sql server with a database

CreateNewSqlServerLogin ( this connection, string username, string password ) : bool

Creates a new sql server login that is used to create users in database

Needs connection to sql server only without specifying any database

CreateSqlServerDatabase ( this connection, string databaseName ) : bool

Creates a new sql database

Needs connection to sql server only without specifying any database

CreateSqlUserFromSqlLogin ( this connection, string username, string loginName ) : bool

Creates a new user for a database from a login

Needs connection to sql server with a database

Описание методов

ChangeSqlUserDbRole() публичный статический Метод

Changes role of the user for given database
Needs connection to sql server with a database
public static ChangeSqlUserDbRole ( this connection, string rolename, string username ) : bool
connection this
rolename string eg. db_owner
username string user name
Результат bool

CreateNewSqlServerLogin() публичный статический Метод

Creates a new sql server login that is used to create users in database
Needs connection to sql server only without specifying any database
public static CreateNewSqlServerLogin ( this connection, string username, string password ) : bool
connection this
username string
password string
Результат bool

CreateSqlServerDatabase() публичный статический Метод

Creates a new sql database
Needs connection to sql server only without specifying any database
public static CreateSqlServerDatabase ( this connection, string databaseName ) : bool
connection this
databaseName string
Результат bool

CreateSqlUserFromSqlLogin() публичный статический Метод

Creates a new user for a database from a login
Needs connection to sql server with a database
public static CreateSqlUserFromSqlLogin ( this connection, string username, string loginName ) : bool
connection this
username string
loginName string
Результат bool