C# 클래스 SQLDiagRunner.Runner

파일 보기 프로젝트 열기: Mitch-Wheat/SQLDiagCmd 1 사용 예제들

공개 메소드들

메소드 설명
ExecuteQueries ( IList servers, string username, string password, string scriptLocation, string outputFolder, IList databases, bool useTrusted, bool autoFitColumns, int queryTimeoutSeconds ) : void

비공개 메소드들

메소드 설명
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

메소드 상세

ExecuteQueries() 공개 메소드

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
리턴 void