C# Class ConfigurationSetupUtility.SqlServerSetup

This class is used to aid in the manipulation of a SQL Server connection string as well as running the sqlcmd.exe process.
Mostra file Open project: GridProtectionAlliance/openPDC

Public Methods

Method Description
CreateLogin ( string loginName ) : void
CreateLogin ( string loginName, string password ) : void
ExecuteScript ( IDbConnection connection, string fileName ) : void

Executes a database script using the given connection.
ExecuteScript ( string scriptPath ) : void

Executes a SQL script using the SQL Server database engine.
ExecuteStatement ( string statement ) : void
GrantDatabaseAccess ( string loginName ) : void
OpenConnection ( IDbConnection &connection ) : void
SqlServerSetup ( ) : System

Creates a new instance of the MySqlSetup class.

Method Details

CreateLogin() public method

public CreateLogin ( string loginName ) : void
loginName string
return void

CreateLogin() public method

public CreateLogin ( string loginName, string password ) : void
loginName string
password string
return void

ExecuteScript() public method

Executes a database script using the given connection.
public ExecuteScript ( IDbConnection connection, string fileName ) : void
connection IDbConnection The connection to be used to execute the script.
fileName string The path to the script to be executed.
return void

ExecuteScript() public method

Executes a SQL script using the SQL Server database engine.
public ExecuteScript ( string scriptPath ) : void
scriptPath string The path to the SQL Server script to be executed.
return void

ExecuteStatement() public method

public ExecuteStatement ( string statement ) : void
statement string
return void

GrantDatabaseAccess() public method

public GrantDatabaseAccess ( string loginName ) : void
loginName string
return void

OpenConnection() public method

public OpenConnection ( IDbConnection &connection ) : void
connection IDbConnection
return void

SqlServerSetup() public method

Creates a new instance of the MySqlSetup class.
public SqlServerSetup ( ) : System
return System