Executes an SQL query against the specified connection.

Namespace: BlueCieloECM.InnoCielo.Meridian.Scripting
Assembly: BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 1.4.0.0 (1.4.40.0)

Syntax

C#
public Array ExecSQL(
	string connectionString,
	string query,
	IEnumerable<Object> parameters
)
Visual Basic
Public Function ExecSQL ( _
	connectionString As String, _
	query As String, _
	parameters As IEnumerable(Of Object) _
) As Array
Visual C++
public:
Array^ ExecSQL(
	String^ connectionString, 
	String^ query, 
	IEnumerable<Object^>^ parameters
)

Parameters

connectionString
Type: System..::..String
The connection string that includes the source database name, and other parameters needed to establish the initial connection.
query
Type: System..::..String
The SQL query to execute.
parameters
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'Object>)>)>
The collection of parameters for the query (in the same order they appear in the SQL expression).

Return Value

A 2D array of values ([column, row]) that represents the SQL result. If no result, an empty array.

See Also