SQLiteQueryBuilder Class

Reference

Definition

Namespace:: Android.Database.Sqlite

Assembly:: Mono.Android.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

[Android.Runtime.Register("android/database/sqlite/SQLiteQueryBuilder", DoNotGenerateAcw=true)]
public class SQLiteQueryBuilder : Java.Lang.Object

[<Android.Runtime.Register("android/database/sqlite/SQLiteQueryBuilder", DoNotGenerateAcw=true)>]
type SQLiteQueryBuilder = class
    inherit Object

Inheritance: Object

Object
SQLiteQueryBuilder

Attributes: RegisterAttribute

Remarks

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

Java documentation for android.database.sqlite.SQLiteQueryBuilder.

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Constructors

SQLiteQueryBuilder()
SQLiteQueryBuilder(IntPtr, JniHandleOwnership)	A constructor used when creating managed representations of JNI objects; called by the runtime.

Properties

Class	Returns the runtime class of this `Object`. (Inherited from Object)
CursorFactory	Gets the cursor factory to be used for the query, as last configured by `#setCursorFactory(android.database.sqlite.SQLiteDatabase.CursorFactory)`.
Handle	The handle to the underlying Android instance. (Inherited from Object)
IsDistinct	Get if the query is marked as `DISTINCT`, as last configured by `#setDistinct(boolean)`.
IsStrict	Get if the query is marked as strict, as last configured by `#setStrict(boolean)`.
JniIdentityHashCode	(Inherited from Object)
JniPeerMembers
PeerReference	(Inherited from Object)
ProjectionGreylist	Gets the projection greylist for the query, as last configured by `#setProjectionGreylist`. -or- Sets a projection greylist of columns that will be allowed through, even when `#setStrict(boolean)` is enabled.
ProjectionMap	Gets the projection map for the query, as last configured by `#setProjectionMap(Map)`.
StrictColumns	Get if the query is marked as strict, as last configured by `#setStrictColumns(boolean)`. -or- When enabled, verify that all projections and `ContentValues` only contain valid columns as defined by `#setProjectionMap(Map)`.
StrictGrammar	Get if the query is marked as strict, as last configured by `#setStrictGrammar(boolean)`. -or- When enabled, verify that all untrusted SQL conforms to a restricted SQL grammar.
Tables	Returns the list of tables being queried -or- Sets the list of tables to query.
ThresholdClass	This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.
ThresholdType	This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

Methods

AppendColumns(StringBuilder, String[])	Add the names that are non-null in columns to s, separating them with commas.
AppendWhere(ICharSequence)	Append a chunk to the `WHERE` clause of the query.
AppendWhere(String)	Append a chunk to the `WHERE` clause of the query.
AppendWhereEscapeString(String)	Append a chunk to the `WHERE` clause of the query.
AppendWhereStandalone(ICharSequence)	Add a standalone chunk to the `WHERE` clause of this query.
AppendWhereStandalone(String)	Add a standalone chunk to the `WHERE` clause of this query.
BuildQuery(String[], String, String, String, String, String)	Construct a `SELECT` statement suitable for use in a group of `SELECT` statements that will be joined through `UNION` operators in buildUnionQuery.
BuildQuery(String[], String, String[], String, String, String, String)	Obsolete. This member is deprecated.
BuildQueryString(Boolean, String, String[], String, String, String, String, String)	Build an SQL query string from the given clauses.
BuildUnionQuery(String[], String, String)	Given a set of subqueries, all of which are `SELECT` statements, construct a query that returns the union of what those subqueries return.
BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String, String)	Construct a `SELECT` statement suitable for use in a group of `SELECT` statements that will be joined through `UNION` operators in buildUnionQuery.
BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String[], String, String)	Obsolete. This member is deprecated.
Clone()	Creates and returns a copy of this object. (Inherited from Object)
Delete(SQLiteDatabase, String, String[])	Perform a delete by combining all current settings and the information passed into this method.
Dispose()	(Inherited from Object)
Dispose(Boolean)	(Inherited from Object)
Equals(Object)	Indicates whether some other object is "equal to" this one. (Inherited from Object)
GetHashCode()	Returns a hash code value for the object. (Inherited from Object)
Insert(SQLiteDatabase, ContentValues)	Perform an insert by combining all current settings and the information passed into this method.
JavaFinalize()	Called by the garbage collector on an object when garbage collection determines that there are no more references to the object. (Inherited from Object)
Notify()	Wakes up a single thread that is waiting on this object's monitor. (Inherited from Object)
NotifyAll()	Wakes up all threads that are waiting on this object's monitor. (Inherited from Object)
Query(SQLiteDatabase, String[], String, String[], String, String, String)	Perform a query by combining all current settings and the information passed into this method.
Query(SQLiteDatabase, String[], String, String[], String, String, String, String)	Perform a query by combining all current settings and the information passed into this method.
Query(SQLiteDatabase, String[], String, String[], String, String, String, String, CancellationSignal)	Perform a query by combining all current settings and the information passed into this method.
SetCursorFactory(SQLiteDatabase+ICursorFactory)	Sets the cursor factory to be used for the query.
SetDistinct(Boolean)	Mark the query as `DISTINCT`.
SetHandle(IntPtr, JniHandleOwnership)	Sets the Handle property. (Inherited from Object)
SetProjectionMap(IDictionary<String,String>)	Sets the projection map for the query.
SetStrict(Boolean)	When set, the selection is verified against malicious arguments.
ToArray<T>()	(Inherited from Object)
ToString()	Returns a string representation of the object. (Inherited from Object)
UnregisterFromRuntime()	(Inherited from Object)
Update(SQLiteDatabase, ContentValues, String, String[])	Perform an update by combining all current settings and the information passed into this method.
Wait()	Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>. (Inherited from Object)
Wait(Int64)	Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed. (Inherited from Object)
Wait(Int64, Int32)	Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed. (Inherited from Object)

Explicit Interface Implementations

IJavaPeerable.Disposed()	(Inherited from Object)
IJavaPeerable.DisposeUnlessReferenced()	(Inherited from Object)
IJavaPeerable.Finalized()	(Inherited from Object)
IJavaPeerable.JniManagedPeerState	(Inherited from Object)
IJavaPeerable.SetJniIdentityHashCode(Int32)	(Inherited from Object)
IJavaPeerable.SetJniManagedPeerState(JniManagedPeerStates)	(Inherited from Object)
IJavaPeerable.SetPeerReference(JniObjectReference)	(Inherited from Object)

Extension Methods

JavaCast<TResult>(IJavaObject)	Performs an Android runtime-checked type conversion.
JavaCast<TResult>(IJavaObject)
GetJniTypeName(IJavaPeerable)

Applies to