C# 클래스 Galen.CI.Azure.Sql.Sharding.App.SqlDatabaseUtilities

파일 보기 프로젝트 열기: GalenHealthcare/Galen.Ef.Deployer 1 사용 예제들

공개 메소드들

메소드	설명
CreateDatabaseIfNotExists ( string databaseName, string serverConnectionString ) : void
CreateDatabaseUserIfNotExists ( string loginName, string databaseUserName, string connectionString ) : void
CreateSqlLoginIfNotExists ( string loginName, string loginPassword, string serverConnectionString ) : void
CreateWindowsLoginIfNotExists ( string loginName, string serverConnectionString ) : void
GrantUserDatabaseRequiredPermissions ( string databaseUserName, string connectionString ) : void

비공개 메소드들

메소드	설명
ExecuteNonQuery ( string sql, string connectionString, int commandTimeout = null ) : void
GetIsSqlAzure ( string connectionString ) : bool
GetMasterDatabaseConnectionString ( string serverConnectionString ) : string

메소드 상세

CreateDatabaseIfNotExists() 공개 정적인 메소드

public static CreateDatabaseIfNotExists ( string databaseName, string serverConnectionString ) : void
databaseName	string
serverConnectionString	string
리턴	void

CreateDatabaseUserIfNotExists() 공개 정적인 메소드

public static CreateDatabaseUserIfNotExists ( string loginName, string databaseUserName, string connectionString ) : void
loginName	string
databaseUserName	string
connectionString	string
리턴	void

CreateSqlLoginIfNotExists() 공개 정적인 메소드

public static CreateSqlLoginIfNotExists ( string loginName, string loginPassword, string serverConnectionString ) : void
loginName	string
loginPassword	string
serverConnectionString	string
리턴	void

CreateWindowsLoginIfNotExists() 공개 정적인 메소드

public static CreateWindowsLoginIfNotExists ( string loginName, string serverConnectionString ) : void
loginName	string
serverConnectionString	string
리턴	void

GrantUserDatabaseRequiredPermissions() 공개 정적인 메소드

public static GrantUserDatabaseRequiredPermissions ( string databaseUserName, string connectionString ) : void
databaseUserName	string
connectionString	string
리턴	void