Executes an SQL query against the specified connection.
Namespace: BlueCieloECM.InnoCielo.Meridian.ScriptingAssembly: BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 4.0.0.0 (4.0.19.0)
Syntax public Array ExecSQL(
string connectionString,
string query,
IEnumerable<Object> parameters
)
Public Function ExecSQL (
connectionString As String,
query As String,
parameters As IEnumerable(Of Object)
) As Array
public:
Array^ ExecSQL(
String^ connectionString,
String^ query,
IEnumerable<Object^>^ parameters
)
member ExecSQL :
connectionString : string *
query : string *
parameters : IEnumerable<Object> -> Array
Parameters
- connectionString
- Type: SystemString
The connection string that includes the source database name,
and other parameters needed to establish the initial connection.
- query
- Type: SystemString
The SQL query to execute.
- parameters
- Type: System.Collections.GenericIEnumerableObject
The collection of parameters for the query
(in the same order they appear in the SQL expression).
Return Value
Type:
Array
A 2D array of values ([column, row]) that represents the SQL result.
If no result, an empty array.
See Also