Members

The members of Android.Database.Sqlite.SQLiteDatabase are listed below.

Protected Constructors

SQLiteDatabase(IntPtr, Android.Runtime.JniHandleOwnership)

A constructor used when creating managed representations of JNI objects; called by the runtime.

Public Fields

const	ConflictAbort	Conflict (2). When a constraint violation occurs,no ROLLBACK is executed so changes from prior commands within the same transaction are preserved.
const	ConflictFail	Conflict (3). When a constraint violation occurs, the command aborts with a return code SQLITE_CONSTRAINT.
const	ConflictIgnore	Conflict (4). When a constraint violation occurs, the one row that contains the constraint violation is not inserted or changed.
const	ConflictNone	Conflict (0). Use the following when no conflict action is specified.
const	ConflictReplace	Conflict (5). When a UNIQUE constraint violation occurs, the pre-existing rows that are causing the constraint violation are removed prior to inserting or updating the current row.
const	ConflictRollback	Conflict (1). When a constraint violation occurs, an immediate ROLLBACK occurs, thus ending the current transaction, and the command aborts with a return code of SQLITE_CONSTRAINT.
const	MaxSqlCacheSize	int (100). Absolute max value that can be set by `SQLiteDatabase.SetMaxSqlCacheSize(int)`.
const	SqliteMaxLikePatternLength	int (50000). Maximum Length Of A LIKE Or GLOB Pattern The pattern matching algorithm used in the default LIKE and GLOB implementation of SQLite can exhibit O(N^2) performance (where N is the number of characters in the pattern) for certain pathological cases.

Public Properties

[read-only]	IsDatabaseIntegrityOk	bool. Runs 'pragma integrity_check' on the given database (and all the attached databases) and returns true if the given database (and all its attached databases) pass integrity_check, false otherwise.
[read-only]	IsDbLockedByCurrentThread	bool. Returns true if the current thread is holding an active connection to the database.
[read-only]	IsDbLockedByOtherThreads	bool. Always returns false.
[read-only]	IsOpen	bool. Returns true if the database is currently open.
[read-only]	IsReadOnly	bool. Returns true if the database is opened as read only.
[read-only]	IsWriteAheadLoggingEnabled	bool. Returns true if write-ahead logging has been enabled for this database.
[read-only]	MaximumSize	long. Returns the maximum size the database may grow to.
	PageSize	long. Returns the current database page size, in bytes.
[read-only]	Path	string. Gets the path to the database file.
[read-only]	SyncedTables	IDictionary<string, string>. Deprecated.
	Version	int. Gets the database version.

Protected Properties

[read-only] override	ThresholdClass	IntPtr. This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.
[read-only] override	ThresholdType	Type. This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

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.