SqlUtilityExecuteQuerySQLFile Method

Executes the SQL query in a file given its path, and a connection string to the database.

Namespace: Galactic.Sql
Assembly: Galactic.Sql (in Galactic.Sql.dll) Version: 1.3.0.499 (1.3.0.499)

Syntax

public virtual List<SqlRow> ExecuteQuerySQLFile(
	string scriptFilePath,
	string connectionString,
	EventLog log
)

Public Overridable Function ExecuteQuerySQLFile ( 
	scriptFilePath As String,
	connectionString As String,
	log As EventLog
) As List(Of SqlRow)

public:
virtual List<SqlRow^>^ ExecuteQuerySQLFile(
	String^ scriptFilePath, 
	String^ connectionString, 
	EventLog^ log
)

abstract ExecuteQuerySQLFile : 
        scriptFilePath : string * 
        connectionString : string * 
        log : EventLog -> List<SqlRow> 
override ExecuteQuerySQLFile : 
        scriptFilePath : string * 
        connectionString : string * 
        log : EventLog -> List<SqlRow>

Parameters

scriptFilePath: Type: SystemString
The path the the TSQL script file to execute.
connectionString: Type: SystemString
The connection string of the database to execute the script against.
log: Type: Galactic.EventLogEventLog
The event log to log execptions to. May be null for no logging.

Return Value

Type: ListSqlRow
A list of rows of data returned from the query.

Reference

SqlUtility Class

Galactic.Sql Namespace

SqlUtilityAddLanguageSpecificTextSet("LST79006AC3_0?cpp=::|nu=.");ExecuteQuerySQLFile Method

Parameters

Return Value

Reference

SqlUtilityExecuteQuerySQLFile Method