C# Class SQLDiagRunner.Runner

Show file Open project: Mitch-Wheat/SQLDiagCmd Class Usage Examples

Public Methods

Method Description
ExecuteQueries ( IList servers, string username, string password, string scriptLocation, string outputFolder, IList databases, bool useTrusted, bool autoFitColumns, int queryTimeoutSeconds ) : void

Private Methods

Method Description
ExecuteQueriesAndSaveToExcel ( ExcelPackage pck, string connectionstring, IEnumerable queries, string database, string worksheetPrefix, bool autoFitColumns, int queryTimeoutSeconds ) : void
GetConnectionStringTemplate ( string servername, string database, string username, string password, bool trusted ) : string
GetOutputFilepath ( string outputFolder, string servername, string dateString ) : string
GetQueryText ( SqlQuery q, string database ) : string
GetWorkSheetName ( string queryTitle, string worksheetPrefix ) : string
SanitiseWorkSheetName ( string wsname ) : string

Method Details

ExecuteQueries() public method

public ExecuteQueries ( IList servers, string username, string password, string scriptLocation, string outputFolder, IList databases, bool useTrusted, bool autoFitColumns, int queryTimeoutSeconds ) : void
servers IList
username string
password string
scriptLocation string
outputFolder string
databases IList
useTrusted bool
autoFitColumns bool
queryTimeoutSeconds int
return void