A .NET wrapper to the SQLite database

SQLiteClient.Execute Method 

Executes the supplied query and returns an SQLiteResultSet object

[Visual Basic]
Public Function Execute( _
   ByVal query As String _
) As SQLiteResultSet
[C#]
public SQLiteResultSet Execute(
   string query
);

Parameters

query
The SQL query to execute

Return Value

SQLiteResultSet of results

Remarks

If the database is busy (ie with another process/thread using it) then this method will call Thread.Sleep(), and then retry the query. Number of retries and retry delay are configurable using the appropriate properties.

The result set object may be empty if there are no results, or if the query does not return results (eg. UPDATE, INSERT, DELETE etc)

Exceptions

Exception TypeCondition
SQLiteException Thrown if an error occurs or if the database is busy and the retries are exhausted.

See Also

SQLiteClient Class | SQLite.NET Namespace