Public Static (Shared) Methods
  GetLibEncoding | Returns the encoding of the underlying library |
| GetLibVersion | Returns the underlying library version |
| GetMessageForError | Returns an appropriate error message for the given error code |
| Quote | Escapes a string to allow it to be safely used in an SQL query. It will double up single quotes, and return the supplied string wrapped in single quotes. Eg the string "Steve's a guy" will be returned as "'Steve''s a guy'". Binary characters are not handled. |
Public Instance Constructors
| SQLiteClient Constructor | Instanciates a new copy of a SQLiteClient object and attempts to open the database with the supplied name. |
Public Instance Properties
 BusyRetries | Gets or sets the number of retries that occur if the database is busy |
| BusyRetryDelay | Gets or sets the retry delay in milliseconds. |
Public Instance Methods
| ChangedRows | Returns the number of rows changed since the database was last "quiescent". |
| Close | Closes the database |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| Execute | Executes the supplied query and returns an SQLiteResultSet object |
| GetAll | Returns an ArrayList of the rows of the results of the given query. |
| GetAllHash | Returns an ArrayList of the rows of the results of the given query. |
| GetColumn | Overloaded. Returns the specified column of a queries result set |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetOne | Returns the first column of the first row of a queries result set |
| GetRow | Overloaded. Returns the specified row of a queries result set |
| GetRowHash | Overloaded. Returns a hashtable row of resultset with given row index |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| Interrupt | Interrupts the current database operation asap |
| LastInsertID | Returns the last insert id for this database |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
Protected Instance Methods
 Finalize | Closes the the database if it is still open. |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
SQLiteClient Class | SQLite.NET Namespace