Database Methods

Begins a new transaction. Call Commit to end the transaction.

Commits the transaction that was begun by BeginTransaction.

Creates a new SQLiteCommand given the command text with arguments. Place a '?' in the command text for each of the arguments.

Creates an index for the specified table and column.

Creates an index for the specified table and columns.

Creates an index for the specified table and column.

Creates an index for the specified table and columns.

Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.

Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.

Deletes the given object from the database using its primary key.

Deletes all the objects from the specified table. WARNING WARNING: Let me repeat. It deletes ALL the objects from the specified table. Do you really want to do that?

Executes a "drop table" on the database. This is non-recoverable.

Determines whether the specified object is equal to the current object.

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. Use this method instead of Query when you don't expect rows back. Such cases include INSERTs, UPDATEs, and DELETEs. You can set the Trace or TimeExecution properties of the connection to profile execution.

Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the PrimaryKeyAttribute).

Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.

Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the PrimaryKeyAttribute).

Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.

Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the PrimaryKeyAttribute).

Serves as the default hash function.

Retrieves the mapping that is automatically generated for the given type.

Retrieves the mapping that is automatically generated for the given type.

Gets the Type of the current instance.

Inserts the given object and retrieves its auto incremented primary key if it has one.

Inserts the given object and retrieves its auto incremented primary key if it has one.

Inserts the given object and retrieves its auto incremented primary key if it has one.

Inserts the given object and retrieves its auto incremented primary key if it has one.

Inserts all specified objects.

Inserts all specified objects.

Inserts all specified objects.

Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.

Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.

Creates a shallow copy of the current Object.

Creates a new SQLiteCommand. Can be overridden to provide a sub-class.

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.

Releases a savepoint returned from SaveTransactionPoint. Releasing a savepoint makes changes since that savepoint permanent if the savepoint began the transaction, or otherwise the changes are permanent pending a call to Commit. The RELEASE command is like a COMMIT for a SAVEPOINT.

Rolls back the transaction that was begun by BeginTransaction or SaveTransactionPoint.

Rolls back the savepoint created by BeginTransaction or SaveTransactionPoint.

Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. Call RollbackTo(String) to undo transactions since the returned savepoint. Call Release(String) to commit transactions after the savepoint returned here. Call Commit to end the transaction, committing all changes.

Returns a queryable interface to the table represented by the given type.

Returns a string that represents the current object.

Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.

Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.

Updates all specified objects.