Android.Database.Sqlite.SQLiteDatabase: Method Members

The methods of Android.Database.Sqlite.SQLiteDatabase are listed below. For a list of all members, see the SQLiteDatabase Members list.

See Also: Inherited members from Android.Database.Sqlite.SQLiteClosable

Public Methods

BeginTransaction()
Begins a transaction in EXCLUSIVE mode.
BeginTransactionNonExclusive()
Begins a transaction in IMMEDIATE mode.
BeginTransactionWithListener(ISQLiteTransactionListener)
Begins a transaction in EXCLUSIVE mode.
BeginTransactionWithListenerNonExclusive(ISQLiteTransactionListener)
Begins a transaction in IMMEDIATE mode.
override
Close()
Documentation for this section has not yet been entered.
CompileStatement(string) : SQLiteStatement
Compiles an SQL statement into a reusable pre-compiled statement object.
static
Create(SQLiteDatabase.ICursorFactory) : SQLiteDatabase
Create a memory backed SQLite database.
Delete(string, string, string[]) : int
Convenience method for deleting rows in the database.
static
DeleteDatabase(Java.IO.File) : bool
Deletes a database including its journal file and other auxiliary files that may have been created by the database engine.
DisableWriteAheadLogging()
This method disables the features enabled by SQLiteDatabase.EnableWriteAheadLogging.
EnableWriteAheadLogging() : bool
This method enables parallel execution of queries from multiple threads on the same database.
EndTransaction()
End a transaction.
ExecSQL(string)
Execute a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.
ExecSQL(string, Java.Lang.Object[])
Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.
static
FindEditTable(string) : string
Finds the name of the first table, which is editable.
Insert(string, string, Android.Content.ContentValues) : long
Convenience method for inserting a row into the database.
InsertOrThrow(string, string, Android.Content.ContentValues) : long
Convenience method for inserting a row into the database.
InsertWithOnConflict(string, string, Android.Content.ContentValues, Conflict) : long
General method for inserting a row into the database.
InTransaction() : bool
Returns true if the current thread has a transaction pending.
MarkTableSyncable(string, string)
Mark this table as syncable.
MarkTableSyncable(string, string, string)
Mark this table as syncable, with the _sync_dirty residing in another table.
NeedUpgrade(int) : bool
Returns true if the new version code is greater than the current database version.
static
OpenDatabase(string, SQLiteDatabase.ICursorFactory, DatabaseOpenFlags) : SQLiteDatabase
Open the database according to the flags SQLiteDatabase.OPEN_READWRITESQLiteDatabase.OPEN_READONLYSQLiteDatabase.CREATE_IF_NECESSARY and/or SQLiteDatabase.NO_LOCALIZED_COLLATORS.
static
OpenDatabase(string, SQLiteDatabase.ICursorFactory, DatabaseOpenFlags, Android.Database.IDatabaseErrorHandler) : SQLiteDatabase
Open the database according to the flags SQLiteDatabase.OPEN_READWRITESQLiteDatabase.OPEN_READONLYSQLiteDatabase.CREATE_IF_NECESSARY and/or SQLiteDatabase.NO_LOCALIZED_COLLATORS.
static
OpenOrCreateDatabase(Java.IO.File, SQLiteDatabase.ICursorFactory) : SQLiteDatabase
Equivalent to openDatabase(file.getPath(), factory, CREATE_IF_NECESSARY).
static
OpenOrCreateDatabase(string, SQLiteDatabase.ICursorFactory) : SQLiteDatabase
Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY).
static
OpenOrCreateDatabase(string, SQLiteDatabase.ICursorFactory, Android.Database.IDatabaseErrorHandler) : SQLiteDatabase
Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY, errorHandler).
Query(bool, string, string[], string, string[], string, string, string, string, Android.OS.CancellationSignal) : Android.Database.ICursor
Query the given URL, returning a Android.Database.ICursor over the result set.
Query(string, string[], string, string[], string, string, string) : Android.Database.ICursor
Query the given table, returning a Android.Database.ICursor over the result set.
Query(string, string[], string, string[], string, string, string, string) : Android.Database.ICursor
Query the given table, returning a Android.Database.ICursor over the result set.
Query(bool, string, string[], string, string[], string, string, string, string) : Android.Database.ICursor
Query the given URL, returning a Android.Database.ICursor over the result set.
QueryWithFactory(SQLiteDatabase.ICursorFactory, bool, string, string[], string, string[], string, string, string, string) : Android.Database.ICursor
Query the given URL, returning a Android.Database.ICursor over the result set.
QueryWithFactory(SQLiteDatabase.ICursorFactory, bool, string, string[], string, string[], string, string, string, string, Android.OS.CancellationSignal) : Android.Database.ICursor
Query the given URL, returning a Android.Database.ICursor over the result set.
RawQuery(string, string[]) : Android.Database.ICursor
Runs the provided SQL and returns a Android.Database.ICursor over the result set.
RawQuery(string, string[], Android.OS.CancellationSignal) : Android.Database.ICursor
Runs the provided SQL and returns a Android.Database.ICursor over the result set.
RawQueryWithFactory(SQLiteDatabase.ICursorFactory, string, string[], string) : Android.Database.ICursor
Runs the provided SQL and returns a cursor over the result set.
RawQueryWithFactory(SQLiteDatabase.ICursorFactory, string, string[], string, Android.OS.CancellationSignal) : Android.Database.ICursor
Runs the provided SQL and returns a cursor over the result set.
static
ReleaseMemory() : int
Attempts to release memory that SQLite holds but does not require to operate properly.
Replace(string, string, Android.Content.ContentValues) : long
Convenience method for replacing a row in the database.
ReplaceOrThrow(string, string, Android.Content.ContentValues) : long
Convenience method for replacing a row in the database.
SetForeignKeyConstraintsEnabled(bool)
Sets whether foreign key constraints are enabled for the database.
SetLocale(Java.Util.Locale)
Sets the locale for this database.
SetLockingEnabled(bool)
Control whether or not the SQLiteDatabase is made thread-safe by using locks around critical sections.
SetMaximumSize(long) : long
Sets the maximum size the database will grow to.
SetMaxSqlCacheSize(int)
Sets the maximum size of the prepared-statement cache for this database. (size of the cache = number of compiled-sql-statements stored in the cache).
SetTransactionSuccessful()
Marks the current transaction as successful.
Update(string, Android.Content.ContentValues, string, string[]) : int
Convenience method for updating rows in the database.
UpdateWithOnConflict(string, Android.Content.ContentValues, string, string[], Conflict) : int
Convenience method for updating rows in the database.
YieldIfContended() : bool
Temporarily end the transaction to let other threads run.
YieldIfContendedSafely() : bool
Temporarily end the transaction to let other threads run.
YieldIfContendedSafely(long) : bool
Temporarily end the transaction to let other threads run.

Protected Methods

override
OnAllReferencesReleased()
Called when the last reference to the object was released by a call to SQLiteClosable.ReleaseReference or SQLiteClosable.Close.