Android.Database.Sqlite Namespace

Applications use these classes to manage private databases.

Classes

Name Description
SQLiteAbortException

An exception that indicates that the SQLite program was aborted.

SQLiteAccessPermException

This exception class is used when sqlite can't access the database file due to lack of permissions on the file.

SQLiteBindOrColumnIndexOutOfRangeException

Thrown if the bind or column parameter index is out of range.

SQLiteBlobTooBigException

An exception for SQLite's SQLITE_TOOBIG error, which indicates that a string or binary value exceeds a size limit.

SQLiteCantOpenDatabaseException

An exception for SQLite's SQLITE_CANTOPEN error, which indicates that a database file could not be opened.

SQLiteClosable

An object created from a SQLiteDatabase that can be closed.

SQLiteConstraintException

An exception that indicates that an integrity constraint was violated.

SQLiteCursor

A Cursor implementation that exposes results from a query on a SQLiteDatabase.

SQLiteDatabase

Exposes methods to manage a SQLite database.

SQLiteDatabase.OpenParams

Wrapper for configuration parameters that are used for opening SQLiteDatabase

SQLiteDatabase.OpenParams.Builder

Builder for OpenParams.

SQLiteDatabaseCorruptException

An exception that indicates that the SQLite database file is corrupt.

SQLiteDatabaseLockedException

Thrown if the database engine was unable to acquire the database locks it needs to do its job.

SQLiteDatatypeMismatchException

An exception for SQLite's SQLITE_MISMATCH error, which indicates a data type mismatch.

SQLiteDiskIOException

Indicates that an IO error occurred while accessing the SQLite database file.

SQLiteDoneException

An exception that indicates that the SQLite program is done.

SQLiteException

A SQLite exception that indicates there was an error with SQL parsing or execution.

SQLiteFullException

An exception that indicates that the SQLite database is full.

SQLiteMisuseException

This error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time.

SQLiteOpenHelper

A helper class to manage database creation and version management.

SQLiteOutOfMemoryException

An exception for SQLite's SQLITE_NOMEM error, which indicates that a memory allocation failed.

SQLiteProgram

A base class for compiled SQLite programs.

SQLiteQuery

Represents a query that reads the resulting rows into a SQLiteQuery.

SQLiteQueryBuilder

This is a convenience class that helps build SQL queries to be sent to SQLiteDatabase objects.

SQLiteRawStatement

A SQLiteRawStatement represents a SQLite prepared statement.

SQLiteReadOnlyDatabaseException

An exception for SQLite's SQLITE_READONLY error, which indicates an attempt to write to a read-only database.

SQLiteStatement

Represents a statement that can be executed against a database.

SQLiteTableLockedException

An exception for SQLite's SQLITE_LOCKED error, which indicates that a table is locked.

Interfaces

Name Description
ISQLiteCursorDriver

A driver for SQLiteCursors that is used to create them and gets notified by the cursors it creates on significant events in their lifetimes.

ISQLiteTransactionListener

A listener for transaction events.

SQLiteDatabase.ICursorFactory

Used to allow returning sub-classes of Cursor when calling query.

Enums

Name Description
Conflict

Specifies how a database insert or update handles a constraint conflict.

DatabaseOpenFlags

Specifies database access modes and options for opening a SQLite database.

SqliteDataType

Identifies the SQLite type of a column value returned by a raw statement.

Remarks

Use SQLiteOpenHelper to manage database creation and schema versions. SQLiteDatabase provides SQL execution, queries, and transactions. Cursors provide access to query results, and compiled statements support bound parameters.

See the Android SQLite database implementation and database helper implementation.