C# Class Galen.CI.Azure.Sql.Sharding.App.SqlDatabaseUtilities

显示文件 Open project: GalenHealthcare/Galen.Ef.Deployer Class Usage Examples

Public Methods

Method	Description
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

Private Methods

Method	Description
ExecuteNonQuery ( string sql, string connectionString, int commandTimeout = null ) : void
GetIsSqlAzure ( string connectionString ) : bool
GetMasterDatabaseConnectionString ( string serverConnectionString ) : string

Method Details

CreateDatabaseIfNotExists() public static method

public static CreateDatabaseIfNotExists ( string databaseName, string serverConnectionString ) : void
databaseName	string
serverConnectionString	string
return	void

CreateDatabaseUserIfNotExists() public static method

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

CreateSqlLoginIfNotExists() public static method

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

CreateWindowsLoginIfNotExists() public static method

public static CreateWindowsLoginIfNotExists ( string loginName, string serverConnectionString ) : void
loginName	string
serverConnectionString	string
return	void

GrantUserDatabaseRequiredPermissions() public static method

public static GrantUserDatabaseRequiredPermissions ( string databaseUserName, string connectionString ) : void
databaseUserName	string
connectionString	string
return	void