Eloquera Database
ExecuteQuery Method (query, depth, parameters)
NamespacesEloquera.ClientDBExecuteQuery(String, Int32, Parameters)
Returns all objects meeting the conditions of the query. Data is retrieved by executing SQL statements. For information on the SQL syntax supported, see the SQL document "Eloquera SQL Reference", Throws an exception if the SQL statement fails to execute.
Declaration Syntax
C#Visual BasicVisual C++
public IEnumerable ExecuteQuery(
	string query,
	int depth,
	Parameters parameters
)
Public Function ExecuteQuery ( _
	query As String, _
	depth As Integer, _
	parameters As Parameters _
) As IEnumerable
public:
IEnumerable^ ExecuteQuery(
	String^ query, 
	int depth, 
	Parameters^ parameters
)
Parameters
query (String)
Query to execute
depth (Int32)
Activation depth of the object(s): value 0 means shallow read
parameters (Parameters)
Parameters for the query
Return Value
List of objects that met conditions of the query.
Remarks
For the query syntax, please refer to the 'Eloquera SQL Reference' in the documentation or on the web site.
Examples
CopyC#
Parameters param = db.CreateParameters();
param["manual"] = "Operation Manual";
IEnumerable res = db.ExecuteQuery("SELECT TOP 100 Book WHERE title = @manual", 0, param);
foreach(Book book in res)
{
 ...
}

Assembly: Eloquera.Client (Module: Eloquera.Client) Version: 4.5.0.0 (4.5.0.0)