BBDXamarinForms.Common.Library.SecureDatabase.SQLiteConnection Class Reference

Public Member Functions
List< string >	RawQuery (string query, params object[] args)
	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 string representation. This function can be used for ad hoc debug and tests in order to query the database without creating database table mapping objects. It is normally not used and does not handle all SQLite query command types. More...

Static Public Member Functions
static bool	ImportDatabase (string sourcePath, string destinationPath)
	Use this function to create an encrypted database from a plain SQLite database file. The database file must be in the secure file system, see BlackBerry Secure Store Common.Interfaces.SecureStorage.IBBDLocalFileSystem. After a succesful import, the database can be opened using the SQLiteConnection constructor. This function would typically be used on an SQLite database that had been retrieved as a single file from an application server. This function can only be called after BlackBerry Dynamics authorization processing is complete, Common.Interfaces.RuntimeObject.IBBDXamarin. More...

Member Function Documentation

ImportDatabase()

static bool BBDXamarinForms.Common.Library.SecureDatabase.SQLiteConnection.ImportDatabase ( string  sourcePath, string  destinationPath  )

inlinestatic

Use this function to create an encrypted database from a plain SQLite database file. The database file must be in the secure file system, see BlackBerry Secure Store Common.Interfaces.SecureStorage.IBBDLocalFileSystem. After a succesful import, the database can be opened using the SQLiteConnection constructor. This function would typically be used on an SQLite database that had been retrieved as a single file from an application server. This function can only be called after BlackBerry Dynamics authorization processing is complete, Common.Interfaces.RuntimeObject.IBBDXamarin.

Returns

On success, true is returned. Otherwise false is returned.

Parameters

sourcePath	Source path, within the secure file system, of the plain SQLite database file to be imported.
destinationPath	Database to be created. If the database already exists, its contents will be overwritten.

RawQuery()

List<string> BBDXamarinForms.Common.Library.SecureDatabase.SQLiteConnection.RawQuery ( string  query, params object[]  args  )

inline

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 string representation. This function can be used for ad hoc debug and tests in order to query the database without creating database table mapping objects. It is normally not used and does not handle all SQLite query command types.

Parameters

query	The fully escaped SQL.
args	Arguments to substitute for the occurences of '?' in the query.

Returns

An enumerable with one string result for each row returned by the query.