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 Basic | Visual C++ |
public IEnumerable ExecuteQuery( string query )
Public Function ExecuteQuery ( _ query As String _ ) As IEnumerable
public: IEnumerable^ ExecuteQuery( String^ query )
Parameters- query (String)
- Query to execute
Return ValueList 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#IEnumerable res = db.ExecuteQuery("SELECT TOP 100 Book WHERE Price > 25"); foreach(Book book in res) { ... }