Class SQLiteDatabase

Namespace: Android.Database.Sqlite

Assembly: MASES.Netdroid.dll

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html

public class SQLiteDatabase : SQLiteClosable, IDynamicMetaObjectProvider, IJVMBridgeCore, IDisposable, IJVMBridgeBaseStatic, IJVMBridgeBase, IJVMBridgeDefinition, ICloseable, IAutoCloseable

Inheritance: object

DynamicObject

JVMBridgeBase

JVMBridgeBase<AutoCloseable>

AutoCloseable

Closeable

SQLiteClosable

SQLiteDatabase

Implements: IDynamicMetaObjectProvider

IJVMBridgeCore

IDisposable

IJVMBridgeBaseStatic

IJVMBridgeBase

IJVMBridgeDefinition

ICloseable

IAutoCloseable

Inherited Members: SQLiteClosable.AcquireReference()

SQLiteClosable.Close()

SQLiteClosable.ReleaseReference()

SQLiteClosable.ReleaseReferenceFromContainer()

JVMBridgeBase<AutoCloseable>.SExecute(IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature(IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute(string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature(string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn>(IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn>(IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn>(string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn>(string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute(Type, IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature(Type, IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute(Type, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature(Type, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TNewClass, TReturn>(IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TNewClass, TReturn>(IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TNewClass, TReturn>(string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TNewClass, TReturn>(string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn>(Type, IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn>(Type, IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn>(Type, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn>(Type, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TNewClass, TReturn, TConverter>(IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TNewClass, TReturn, TConverter>(IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TNewClass, TReturn, TConverter>(string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TNewClass, TReturn, TConverter>(string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn, TConverter>(Type, IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn, TConverter>(Type, IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecute<TReturn, TConverter>(Type, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignature<TReturn, TConverter>(Type, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteArray<T>(IJavaType, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignatureArray<T>(IJavaType, string, string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteArray<T>(string, params object[])

JVMBridgeBase<AutoCloseable>.SExecuteWithSignatureArray<T>(string, string, params object[])

JVMBridgeBase<AutoCloseable>.SGetField(IJavaType, string)

JVMBridgeBase<AutoCloseable>.SGetField(string)

JVMBridgeBase<AutoCloseable>.SGetField<TReturn>(IJavaType, string)

JVMBridgeBase<AutoCloseable>.SGetField<TReturn>(string)

JVMBridgeBase<AutoCloseable>.SGetFieldArray<TReturn>(IJavaType, string)

JVMBridgeBase<AutoCloseable>.SGetFieldArray<TReturn>(string)

JVMBridgeBase<AutoCloseable>.SSetField(IJavaType, string, object)

JVMBridgeBase<AutoCloseable>.SSetField(string, object)

JVMBridgeBase<AutoCloseable>.SSetField<TValue>(IJavaType, string, TValue)

JVMBridgeBase<AutoCloseable>.SSetField<TValue>(string, TValue)

JVMBridgeBase<AutoCloseable>.IsAssignableFrom(string)

JVMBridgeBase<AutoCloseable>.IsAssignableFrom(IJavaType)

JVMBridgeBase<AutoCloseable>.IsAssignableFrom<T>()

JVMBridgeBase<AutoCloseable>.New(params object[])

JVMBridgeBase<AutoCloseable>.NewWithSignature(string, params object[])

JVMBridgeBase<AutoCloseable>.Execute<T>(params T[])

JVMBridgeBase<AutoCloseable>.DynBridgeClazz

JVMBridgeBase<AutoCloseable>.BridgeClazz

JVMBridgeBase.ClazzOf<TClass>(bool)

JVMBridgeBase.ClazzOf(string, bool)

JVMBridgeBase.RuntimeClassNameOf<T>()

JVMBridgeBase.ClassNameOf<T>()

JVMBridgeBase.ClassOf<T>()

JVMBridgeBase.WrapsDirect<TNewClass>(IJavaObject)

JVMBridgeBase.Wraps<TNewClass>(IJavaObject)

JVMBridgeBase.Wraps(Type, IJavaObject, string)

JVMBridgeBase.Wraps<TNewClass, TReturn>(IJavaObject)

JVMBridgeBase.Wraps<TReturn>(Type, IJavaObject, string)

JVMBridgeBase.Wraps<TNewClass, TReturn, TConverter>(IJavaObject)

JVMBridgeBase.Wraps<TReturn, TConverter>(Type, IJavaObject)

JVMBridgeBase.MonitorEnter()

JVMBridgeBase.MonitorExit()

JVMBridgeBase.IsInstanceOf(string)

JVMBridgeBase.IsInstanceOf(IJavaType)

JVMBridgeBase.IsInstanceOf<T>()

JVMBridgeBase.RuntimeIsInstanceOf<T>()

JVMBridgeBase.CastTo<TNewClass>()

JVMBridgeBase.CastDirect<TNewClass>()

JVMBridgeBase.Dispose()

JVMBridgeBase.ToString()

JVMBridgeBase.Equals(object)

JVMBridgeBase.GetHashCode()

JVMBridgeBase.Notify()

JVMBridgeBase.NotifyAll()

JVMBridgeBase.Wait()

JVMBridgeBase.Wait(long)

JVMBridgeBase.Wait(long, int)

JVMBridgeBase.IExecute(string, params object[])

JVMBridgeBase.IExecuteWithSignature(string, string, params object[])

JVMBridgeBase.IExecute<TReturn>(string, params object[])

JVMBridgeBase.IExecuteWithSignature<TReturn>(string, string, params object[])

JVMBridgeBase.IExecute<TNewClass, TReturn>(string, params object[])

JVMBridgeBase.IExecuteWithSignature<TNewClass, TReturn>(string, string, params object[])

JVMBridgeBase.IExecute<TNewClass, TReturn, TConverter>(string, params object[])

JVMBridgeBase.IExecuteWithSignature<TNewClass, TReturn, TConverter>(string, string, params object[])

JVMBridgeBase.IExecuteArray<T>(string, params object[])

JVMBridgeBase.IExecuteWithSignatureArray<T>(string, string, params object[])

JVMBridgeBase.IGetField(string)

JVMBridgeBase.IGetField<TReturn>(string)

JVMBridgeBase.IGetFieldArray<TReturn>(string)

JVMBridgeBase.ISetField(string, object)

JVMBridgeBase.ISetField<TValue>(string, TValue)

JVMBridgeBase.DynBridgeInstance

JVMBridgeBase.BridgeInstance

JVMBridgeBase.IsBridgeListener

DynamicObject.GetDynamicMemberNames()

DynamicObject.GetMetaObject(Expression)

DynamicObject.TryBinaryOperation(BinaryOperationBinder, object, out object)

DynamicObject.TryConvert(ConvertBinder, out object)

DynamicObject.TryCreateInstance(CreateInstanceBinder, object[], out object)

DynamicObject.TryDeleteIndex(DeleteIndexBinder, object[])

DynamicObject.TryDeleteMember(DeleteMemberBinder)

DynamicObject.TryGetIndex(GetIndexBinder, object[], out object)

DynamicObject.TryGetMember(GetMemberBinder, out object)

DynamicObject.TryInvoke(InvokeBinder, object[], out object)

DynamicObject.TryInvokeMember(InvokeMemberBinder, object[], out object)

DynamicObject.TrySetIndex(SetIndexBinder, object[], object)

DynamicObject.TrySetMember(SetMemberBinder, object)

DynamicObject.TryUnaryOperation(UnaryOperationBinder, out object)

object.Equals(object, object)

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Extension Methods: JNetCoreExtensions.Class<TClass>(TClass)

Constructors

SQLiteDatabase()

Default constructor: even if the corresponding Java class does not have one, it is mandatory for JCOBridge

public SQLiteDatabase()

SQLiteDatabase(params object[])

Generic constructor: it is useful for JCOBridge when there is a derived class which needs to pass arguments to the highest JVMBridgeBase class

public SQLiteDatabase(params object[] args)

Parameters

args object[]

Properties

BridgeClassName

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_BridgeClassName.htm

public override string BridgeClassName { get; }

Property Value

string

CONFLICT_ABORT

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_ABORT

public static int CONFLICT_ABORT { get; }

Property Value

int

CONFLICT_FAIL

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_FAIL

public static int CONFLICT_FAIL { get; }

Property Value

int

CONFLICT_IGNORE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_IGNORE

public static int CONFLICT_IGNORE { get; }

Property Value

int

CONFLICT_NONE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_NONE

public static int CONFLICT_NONE { get; }

Property Value

int

CONFLICT_REPLACE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_REPLACE

public static int CONFLICT_REPLACE { get; }

Property Value

int

CONFLICT_ROLLBACK

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CONFLICT_ROLLBACK

public static int CONFLICT_ROLLBACK { get; }

Property Value

int

CREATE_IF_NECESSARY

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#CREATE_IF_NECESSARY

public static int CREATE_IF_NECESSARY { get; }

Property Value

int

ENABLE_WRITE_AHEAD_LOGGING

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#ENABLE_WRITE_AHEAD_LOGGING

public static int ENABLE_WRITE_AHEAD_LOGGING { get; }

Property Value

int

IsBridgeAbstract

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeAbstract.htm

public override bool IsBridgeAbstract { get; }

Property Value

bool

IsBridgeCloseable

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeCloseable.htm

public override bool IsBridgeCloseable { get; }

Property Value

bool

IsBridgeInterface

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeInterface.htm

public override bool IsBridgeInterface { get; }

Property Value

bool

IsBridgeStatic

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeStatic.htm

public override bool IsBridgeStatic { get; }

Property Value

bool

JOURNAL_MODE_DELETE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_DELETE

public static String JOURNAL_MODE_DELETE { get; }

Property Value

String

JOURNAL_MODE_MEMORY

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_MEMORY

public static String JOURNAL_MODE_MEMORY { get; }

Property Value

String

JOURNAL_MODE_OFF

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_OFF

public static String JOURNAL_MODE_OFF { get; }

Property Value

String

JOURNAL_MODE_PERSIST

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_PERSIST

public static String JOURNAL_MODE_PERSIST { get; }

Property Value

String

JOURNAL_MODE_TRUNCATE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_TRUNCATE

public static String JOURNAL_MODE_TRUNCATE { get; }

Property Value

String

JOURNAL_MODE_WAL

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#JOURNAL_MODE_WAL

public static String JOURNAL_MODE_WAL { get; }

Property Value

String

MAX_SQL_CACHE_SIZE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#MAX_SQL_CACHE_SIZE

public static int MAX_SQL_CACHE_SIZE { get; }

Property Value

int

NO_LOCALIZED_COLLATORS

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#NO_LOCALIZED_COLLATORS

public static int NO_LOCALIZED_COLLATORS { get; }

Property Value

int

OPEN_READONLY

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#OPEN_READONLY

public static int OPEN_READONLY { get; }

Property Value

int

OPEN_READWRITE

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#OPEN_READWRITE

public static int OPEN_READWRITE { get; }

Property Value

int

SQLITE_MAX_LIKE_PATTERN_LENGTH

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#SQLITE_MAX_LIKE_PATTERN_LENGTH

public static int SQLITE_MAX_LIKE_PATTERN_LENGTH { get; }

Property Value

int

SYNC_MODE_EXTRA

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#SYNC_MODE_EXTRA

public static String SYNC_MODE_EXTRA { get; }

Property Value

String

SYNC_MODE_FULL

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#SYNC_MODE_FULL

public static String SYNC_MODE_FULL { get; }

Property Value

String

SYNC_MODE_NORMAL

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#SYNC_MODE_NORMAL

public static String SYNC_MODE_NORMAL { get; }

Property Value

String

SYNC_MODE_OFF

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#SYNC_MODE_OFF

public static String SYNC_MODE_OFF { get; }

Property Value

String

Methods

BeginTransaction()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransaction()

public void BeginTransaction()

BeginTransactionNonExclusive()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransactionNonExclusive()

public void BeginTransactionNonExclusive()

BeginTransactionReadOnly()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransactionReadOnly()

public void BeginTransactionReadOnly()

BeginTransactionWithListener(SQLiteTransactionListener)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransactionWithListener(android.database.sqlite.SQLiteTransactionListener)

public void BeginTransactionWithListener(SQLiteTransactionListener arg0)

Parameters

arg0 SQLiteTransactionListener: SQLiteTransactionListener

BeginTransactionWithListenerNonExclusive(SQLiteTransactionListener)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransactionWithListenerNonExclusive(android.database.sqlite.SQLiteTransactionListener)

public void BeginTransactionWithListenerNonExclusive(SQLiteTransactionListener arg0)

Parameters

arg0 SQLiteTransactionListener: SQLiteTransactionListener

BeginTransactionWithListenerReadOnly(SQLiteTransactionListener)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransactionWithListenerReadOnly(android.database.sqlite.SQLiteTransactionListener)

public void BeginTransactionWithListenerReadOnly(SQLiteTransactionListener arg0)

Parameters

arg0 SQLiteTransactionListener: SQLiteTransactionListener

CompileStatement(String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#compileStatement(java.lang.String)

public SQLiteStatement CompileStatement(String arg0)

public static SQLiteDatabase Create(SQLiteDatabase.CursorFactory arg0)

Parameters

arg0 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory

Returns

SQLiteDatabase: SQLiteDatabase

CreateInMemory(OpenParams)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#createInMemory(android.database.sqlite.SQLiteDatabase.OpenParams)

public static SQLiteDatabase CreateInMemory(SQLiteDatabase.OpenParams arg0)

Parameters

arg0 SQLiteDatabase.OpenParams: SQLiteDatabase.OpenParams

Returns

SQLiteDatabase: SQLiteDatabase

CreateRawStatement(String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#createRawStatement(java.lang.String)

public SQLiteRawStatement CreateRawStatement(String arg0)

Parameters

arg0 String: String

Returns

SQLiteRawStatement: SQLiteRawStatement

Delete(String, String, String[])

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#delete(java.lang.String,java.lang.String,java.lang.String[])

public int Delete(String arg0, String arg1, String[] arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 String[]: String

Returns

int: int

DeleteDatabase(File)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#deleteDatabase(java.io.File)

public static bool DeleteDatabase(File arg0)

Parameters

arg0 File: File

Returns

bool: bool

DisableWriteAheadLogging()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#disableWriteAheadLogging()

public void DisableWriteAheadLogging()

EnableWriteAheadLogging()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#enableWriteAheadLogging()

public bool EnableWriteAheadLogging()

Returns

bool: bool

EndTransaction()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#endTransaction()

public void EndTransaction()

ExecPerConnectionSQL(String, object[])

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#execPerConnectionSQL(java.lang.String,java.lang.Object[])

public void ExecPerConnectionSQL(String arg0, object[] arg1)

Parameters

arg0 String: String
arg1 object[]: object

Exceptions

SQLException

ExecSQL(String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#execSQL(java.lang.String)

public void ExecSQL(String arg0)

Parameters

arg0 String: String

Exceptions

SQLException

ExecSQL(String, object[])

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#execSQL(java.lang.String,java.lang.Object[])

public void ExecSQL(String arg0, object[] arg1)

Parameters

arg0 String: String
arg1 object[]: object

Exceptions

SQLException

FindEditTable(String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#findEditTable(java.lang.String)

public static String FindEditTable(String arg0)

Parameters

arg0 String: String

Returns

String: String

GetAttachedDbs()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getAttachedDbs()

public List<Pair<String, String>> GetAttachedDbs()

Returns

List<Pair<String, String>>: List

GetLastChangedRowCount()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getLastChangedRowCount()

public long GetLastChangedRowCount()

Returns

long: long

GetLastInsertRowId()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getLastInsertRowId()

public long GetLastInsertRowId()

Returns

long: long

GetMaximumSize()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getMaximumSize()

public long GetMaximumSize()

Returns

long: long

GetPageSize()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getPageSize()

public long GetPageSize()

Returns

long: long

GetPath()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getPath()

public String GetPath()

Returns

String: String

GetSyncedTables()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getSyncedTables()

[Obsolete]
public Map<String, String> GetSyncedTables()

Returns

Map<String, String>: Map

GetTotalChangedRowCount()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getTotalChangedRowCount()

public long GetTotalChangedRowCount()

Returns

long: long

GetVersion()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#getVersion()

public int GetVersion()

Returns

int: int

InTransaction()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#inTransaction()

public bool InTransaction()

Returns

bool: bool

Insert(String, String, ContentValues)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insert(java.lang.String,java.lang.String,android.content.ContentValues)

public long Insert(String arg0, String arg1, ContentValues arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 ContentValues: ContentValues

Returns

long: long

InsertOrThrow(String, String, ContentValues)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insertOrThrow(java.lang.String,java.lang.String,android.content.ContentValues)

public long InsertOrThrow(String arg0, String arg1, ContentValues arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 ContentValues: ContentValues

Returns

long: long

Exceptions

SQLException

InsertWithOnConflict(String, String, ContentValues, int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insertWithOnConflict(java.lang.String,java.lang.String,android.content.ContentValues,int)

public long InsertWithOnConflict(String arg0, String arg1, ContentValues arg2, int arg3)

Parameters

arg0 String: String
arg1 String: String
arg2 ContentValues: ContentValues
arg3 int: int

Returns

long: long

IsDatabaseIntegrityOk()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isDatabaseIntegrityOk()

public bool IsDatabaseIntegrityOk()

Returns

bool: bool

IsDbLockedByCurrentThread()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isDbLockedByCurrentThread()

public bool IsDbLockedByCurrentThread()

Returns

bool: bool

IsDbLockedByOtherThreads()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isDbLockedByOtherThreads()

[Obsolete]
public bool IsDbLockedByOtherThreads()

Returns

bool: bool

IsOpen()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isOpen()

public bool IsOpen()

Returns

bool: bool

IsReadOnly()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isReadOnly()

public bool IsReadOnly()

Returns

bool: bool

IsWriteAheadLoggingEnabled()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#isWriteAheadLoggingEnabled()

public bool IsWriteAheadLoggingEnabled()

Returns

bool: bool

MarkTableSyncable(String, String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#markTableSyncable(java.lang.String,java.lang.String)

[Obsolete]
public void MarkTableSyncable(String arg0, String arg1)

Parameters

arg0 String: String
arg1 String: String

MarkTableSyncable(String, String, String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#markTableSyncable(java.lang.String,java.lang.String,java.lang.String)

[Obsolete]
public void MarkTableSyncable(String arg0, String arg1, String arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 String: String

NeedUpgrade(int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#needUpgrade(int)

public bool NeedUpgrade(int arg0)

Parameters

arg0 int: int

Returns

bool: bool

OpenDatabase(File, OpenParams)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openDatabase(java.io.File,android.database.sqlite.SQLiteDatabase.OpenParams)

public static SQLiteDatabase OpenDatabase(File arg0, SQLiteDatabase.OpenParams arg1)

Parameters

arg0 File: File
arg1 SQLiteDatabase.OpenParams: SQLiteDatabase.OpenParams

Returns

SQLiteDatabase: SQLiteDatabase

OpenDatabase(String, CursorFactory, int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openDatabase(java.lang.String,android.database.sqlite.SQLiteDatabase.CursorFactory,int)

public static SQLiteDatabase OpenDatabase(String arg0, SQLiteDatabase.CursorFactory arg1, int arg2)

Parameters

arg0 String: String
arg1 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg2 int: int

Returns

SQLiteDatabase: SQLiteDatabase

OpenDatabase(String, CursorFactory, int, DatabaseErrorHandler)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openDatabase(java.lang.String,android.database.sqlite.SQLiteDatabase.CursorFactory,int,android.database.DatabaseErrorHandler)

public static SQLiteDatabase OpenDatabase(String arg0, SQLiteDatabase.CursorFactory arg1, int arg2, DatabaseErrorHandler arg3)

Parameters

arg0 String: String
arg1 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg2 int: int
arg3 DatabaseErrorHandler: DatabaseErrorHandler

Returns

SQLiteDatabase: SQLiteDatabase

OpenOrCreateDatabase(File, CursorFactory)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openOrCreateDatabase(java.io.File,android.database.sqlite.SQLiteDatabase.CursorFactory)

public static SQLiteDatabase OpenOrCreateDatabase(File arg0, SQLiteDatabase.CursorFactory arg1)

Parameters

arg0 File: File
arg1 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory

Returns

SQLiteDatabase: SQLiteDatabase

OpenOrCreateDatabase(String, CursorFactory)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openOrCreateDatabase(java.lang.String,android.database.sqlite.SQLiteDatabase.CursorFactory)

public static SQLiteDatabase OpenOrCreateDatabase(String arg0, SQLiteDatabase.CursorFactory arg1)

Parameters

arg0 String: String
arg1 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory

Returns

SQLiteDatabase: SQLiteDatabase

OpenOrCreateDatabase(String, CursorFactory, DatabaseErrorHandler)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#openOrCreateDatabase(java.lang.String,android.database.sqlite.SQLiteDatabase.CursorFactory,android.database.DatabaseErrorHandler)

public static SQLiteDatabase OpenOrCreateDatabase(String arg0, SQLiteDatabase.CursorFactory arg1, DatabaseErrorHandler arg2)

Parameters

arg0 String: String
arg1 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg2 DatabaseErrorHandler: DatabaseErrorHandler

Returns

SQLiteDatabase: SQLiteDatabase

Query(String, String[], String, String[], String, String, String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#query(java.lang.String,java.lang.String[],java.lang.String,java.lang.String[],java.lang.String,java.lang.String,java.lang.String)

public Cursor Query(String arg0, String[] arg1, String arg2, String[] arg3, String arg4, String arg5, String arg6)

Parameters

arg0 String: String
arg1 String[]: String
arg2 String: String
arg3 String[]: String
arg4 String: String
arg5 String: String
arg6 String: String

Returns

Cursor: Cursor

Query(String, String[], String, String[], String, String, String, String)

public Cursor Query(String arg0, String[] arg1, String arg2, String[] arg3, String arg4, String arg5, String arg6, String arg7)

Parameters

arg0 String: String
arg1 String[]: String
arg2 String: String
arg3 String[]: String
arg4 String: String
arg5 String: String
arg6 String: String
arg7 String: String

Returns

Cursor: Cursor

Query(bool, String, String[], String, String[], String, String, String, String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#query(boolean,java.lang.String,java.lang.String[],java.lang.String,java.lang.String[],java.lang.String,java.lang.String,java.lang.String,java.lang.String)

public Cursor Query(bool arg0, String arg1, String[] arg2, String arg3, String[] arg4, String arg5, String arg6, String arg7, String arg8)

Parameters

arg0 bool: bool
arg1 String: String
arg2 String[]: String
arg3 String: String
arg4 String[]: String
arg5 String: String
arg6 String: String
arg7 String: String
arg8 String: String

Returns

Cursor: Cursor

Query(bool, String, String[], String, String[], String, String, String, String, CancellationSignal)

public Cursor Query(bool arg0, String arg1, String[] arg2, String arg3, String[] arg4, String arg5, String arg6, String arg7, String arg8, CancellationSignal arg9)

Parameters

arg0 bool: bool
arg1 String: String
arg2 String[]: String
arg3 String: String
arg4 String[]: String
arg5 String: String
arg6 String: String
arg7 String: String
arg8 String: String
arg9 CancellationSignal: CancellationSignal

Returns

Cursor: Cursor

QueryWithFactory(CursorFactory, bool, String, String[], String, String[], String, String, String, String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#queryWithFactory(android.database.sqlite.SQLiteDatabase.CursorFactory,boolean,java.lang.String,java.lang.String[],java.lang.String,java.lang.String[],java.lang.String,java.lang.String,java.lang.String,java.lang.String)

public Cursor QueryWithFactory(SQLiteDatabase.CursorFactory arg0, bool arg1, String arg2, String[] arg3, String arg4, String[] arg5, String arg6, String arg7, String arg8, String arg9)

Parameters

arg0 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg1 bool: bool
arg2 String: String
arg3 String[]: String
arg4 String: String
arg5 String[]: String
arg6 String: String
arg7 String: String
arg8 String: String
arg9 String: String

Returns

Cursor: Cursor

QueryWithFactory(CursorFactory, bool, String, String[], String, String[], String, String, String, String, CancellationSignal)

public Cursor QueryWithFactory(SQLiteDatabase.CursorFactory arg0, bool arg1, String arg2, String[] arg3, String arg4, String[] arg5, String arg6, String arg7, String arg8, String arg9, CancellationSignal arg10)

Parameters

arg0 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg1 bool: bool
arg2 String: String
arg3 String[]: String
arg4 String: String
arg5 String[]: String
arg6 String: String
arg7 String: String
arg8 String: String
arg9 String: String
arg10 CancellationSignal: CancellationSignal

Returns

Cursor: Cursor

RawQuery(String, String[])

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQuery(java.lang.String,java.lang.String[])

public Cursor RawQuery(String arg0, String[] arg1)

Parameters

arg0 String: String
arg1 String[]: String

Returns

Cursor: Cursor

RawQuery(String, String[], CancellationSignal)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQuery(java.lang.String,java.lang.String[],android.os.CancellationSignal)

public Cursor RawQuery(String arg0, String[] arg1, CancellationSignal arg2)

Parameters

arg0 String: String
arg1 String[]: String
arg2 CancellationSignal: CancellationSignal

Returns

Cursor: Cursor

RawQueryWithFactory(CursorFactory, String, String[], String)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQueryWithFactory(android.database.sqlite.SQLiteDatabase.CursorFactory,java.lang.String,java.lang.String[],java.lang.String)

public Cursor RawQueryWithFactory(SQLiteDatabase.CursorFactory arg0, String arg1, String[] arg2, String arg3)

Parameters

arg0 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg1 String: String
arg2 String[]: String
arg3 String: String

Returns

Cursor: Cursor

RawQueryWithFactory(CursorFactory, String, String[], String, CancellationSignal)

public Cursor RawQueryWithFactory(SQLiteDatabase.CursorFactory arg0, String arg1, String[] arg2, String arg3, CancellationSignal arg4)

Parameters

arg0 SQLiteDatabase.CursorFactory: SQLiteDatabase.CursorFactory
arg1 String: String
arg2 String[]: String
arg3 String: String
arg4 CancellationSignal: CancellationSignal

Returns

Cursor: Cursor

ReleaseMemory()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#releaseMemory()

public static int ReleaseMemory()

Returns

int: int

Replace(String, String, ContentValues)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#replace(java.lang.String,java.lang.String,android.content.ContentValues)

public long Replace(String arg0, String arg1, ContentValues arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 ContentValues: ContentValues

Returns

long: long

ReplaceOrThrow(String, String, ContentValues)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#replaceOrThrow(java.lang.String,java.lang.String,android.content.ContentValues)

public long ReplaceOrThrow(String arg0, String arg1, ContentValues arg2)

Parameters

arg0 String: String
arg1 String: String
arg2 ContentValues: ContentValues

Returns

long: long

Exceptions

SQLException

SetCustomAggregateFunction(String, BinaryOperator<String>)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setCustomAggregateFunction(java.lang.String,java.util.function.BinaryOperator)

public void SetCustomAggregateFunction(String arg0, BinaryOperator<String> arg1)

Parameters

arg0 String: String
arg1 BinaryOperator<String>: BinaryOperator

Exceptions

SQLiteException

SetCustomScalarFunction(String, UnaryOperator<String>)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setCustomScalarFunction(java.lang.String,java.util.function.UnaryOperator)

public void SetCustomScalarFunction(String arg0, UnaryOperator<String> arg1)

Parameters

arg0 String: String
arg1 UnaryOperator<String>: UnaryOperator

Exceptions

SQLiteException

SetForeignKeyConstraintsEnabled(bool)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setForeignKeyConstraintsEnabled(boolean)

public void SetForeignKeyConstraintsEnabled(bool arg0)

Parameters

arg0 bool: bool

SetLocale(Locale)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setLocale(java.util.Locale)

public void SetLocale(Locale arg0)

Parameters

arg0 Locale: Locale

SetLockingEnabled(bool)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setLockingEnabled(boolean)

[Obsolete]
public void SetLockingEnabled(bool arg0)

Parameters

arg0 bool: bool

SetMaxSqlCacheSize(int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setMaxSqlCacheSize(int)

public void SetMaxSqlCacheSize(int arg0)

Parameters

arg0 int: int

SetMaximumSize(long)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setMaximumSize(long)

public long SetMaximumSize(long arg0)

Parameters

arg0 long: long

Returns

long: long

SetPageSize(long)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setPageSize(long)

public void SetPageSize(long arg0)

Parameters

arg0 long: long

SetTransactionSuccessful()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setTransactionSuccessful()

public void SetTransactionSuccessful()

SetVersion(int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setVersion(int)

public void SetVersion(int arg0)

Parameters

arg0 int: int

Update(String, ContentValues, String, String[])

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#update(java.lang.String,android.content.ContentValues,java.lang.String,java.lang.String[])

public int Update(String arg0, ContentValues arg1, String arg2, String[] arg3)

Parameters

arg0 String: String
arg1 ContentValues: ContentValues
arg2 String: String
arg3 String[]: String

Returns

int: int

UpdateWithOnConflict(String, ContentValues, String, String[], int)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#updateWithOnConflict(java.lang.String,android.content.ContentValues,java.lang.String,java.lang.String[],int)

public int UpdateWithOnConflict(String arg0, ContentValues arg1, String arg2, String[] arg3, int arg4)

Parameters

arg0 String: String
arg1 ContentValues: ContentValues
arg2 String: String
arg3 String[]: String
arg4 int: int

Returns

int: int

ValidateSql(String, CancellationSignal)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#validateSql(java.lang.String,android.os.CancellationSignal)

public void ValidateSql(String arg0, CancellationSignal arg1)

Parameters

arg0 String: String
arg1 CancellationSignal: CancellationSignal

YieldIfContended()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#yieldIfContended()

[Obsolete]
public bool YieldIfContended()

Returns

bool: bool

YieldIfContendedSafely()

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#yieldIfContendedSafely()

public bool YieldIfContendedSafely()

Returns

bool: bool

YieldIfContendedSafely(long)

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#yieldIfContendedSafely(long)

public bool YieldIfContendedSafely(long arg0)

Parameters

arg0 long: long

Returns

bool: bool

Table of Contents

Class SQLiteDatabase

Constructors

SQLiteDatabase()

SQLiteDatabase(params object[])

Parameters

Properties

BridgeClassName

Property Value

CONFLICT_ABORT

Property Value

CONFLICT_FAIL

Property Value

CONFLICT_IGNORE

Property Value

CONFLICT_NONE

Property Value

CONFLICT_REPLACE

Property Value

CONFLICT_ROLLBACK

Property Value

CREATE_IF_NECESSARY

Property Value

ENABLE_WRITE_AHEAD_LOGGING

Property Value

IsBridgeAbstract

Property Value

IsBridgeCloseable

Property Value

IsBridgeInterface

Property Value

IsBridgeStatic

Property Value

JOURNAL_MODE_DELETE

Property Value

JOURNAL_MODE_MEMORY

Property Value

JOURNAL_MODE_OFF

Property Value

JOURNAL_MODE_PERSIST

Property Value

JOURNAL_MODE_TRUNCATE

Property Value

JOURNAL_MODE_WAL

Property Value

MAX_SQL_CACHE_SIZE

Property Value

NO_LOCALIZED_COLLATORS

Property Value

OPEN_READONLY

Property Value

OPEN_READWRITE

Property Value

SQLITE_MAX_LIKE_PATTERN_LENGTH

Property Value

SYNC_MODE_EXTRA

Property Value

SYNC_MODE_FULL

Property Value

SYNC_MODE_NORMAL

Property Value

SYNC_MODE_OFF

Property Value

Methods

BeginTransaction()

BeginTransactionNonExclusive()

BeginTransactionReadOnly()

BeginTransactionWithListener(SQLiteTransactionListener)

Parameters

BeginTransactionWithListenerNonExclusive(SQLiteTransactionListener)

Parameters

BeginTransactionWithListenerReadOnly(SQLiteTransactionListener)

Parameters

CompileStatement(String)

Parameters

Returns

Exceptions

Create(CursorFactory)

Parameters

Returns