QDatabase Class

Microsoft Deployment Compression & Installer

Copy image CopyHover image
Deployment Tools Foundation QDatabase Class
Queryable MSI database - extends the base Database class with LINQ query functionality along with predefined entity types for common tables.
Declaration Syntax
C# Visual Basic Visual C++
public class QDatabase : Database
Public Class QDatabase
	Inherits Database
public ref class QDatabase : public Database
Members
All Members Constructors Methods Properties



Icon Member Description
QDatabase(String)
Opens an existing database in read-only mode.

QDatabase(String, String)
Opens an existing database with another database as output.

QDatabase(String, DatabaseOpenMode)
Opens an existing database or creates a new one.

QDatabase(IntPtr, Boolean, String, DatabaseOpenMode)
Creates a new database from an MSI handle.

ApplyTransform(String)
Apply a transform to the database, suppressing any error conditions specified by the transform's summary information.
(Inherited from Database.)
ApplyTransform(String, TransformErrors)
Apply a transform to the database, specifying error conditions to suppress.
(Inherited from Database.)
AsQueryable(Database)
Converts any Database instance into a queryable database.
(Inherited from Queryable.)
Close()()()()
Closes the handle. After closing a handle, further method calls may throw an InvalidHandleException.
(Inherited from InstallerHandle.)
CodePage
Gets or sets the code page of the Database.
(Inherited from Database.)
Commit()()()()
Finalizes the persistent form of the database. All persistent data is written to the writeable database, and no temporary columns or rows are written.
(Inherited from Database.)
Components
Queryable standard table with predefined specialized record type.

CountRows(String)
Gets the count of all rows in the table.
(Inherited from Database.)
CountRows(String, String)
Gets the count of all rows in the table that satisfy a given condition.
(Inherited from Database.)
CreateFolders
Queryable standard table with predefined specialized record type.

CreateObjRef(Type)
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
CreateRecord(Int32)
Creates a new record object with the requested number of fields.
(Inherited from Database.)
CreateTransformSummaryInfo(Database, String, TransformErrors, TransformValidations)
Creates and populates the summary information stream of an existing transform file, and fills in the properties with the base and reference ProductCode and ProductVersion.
(Inherited from Database.)
CustomActions
Queryable standard table with predefined specialized record type.

DeleteOnClose(String)
Schedules a file or directory for deletion after the database handle is closed.
(Inherited from Database.)
Directories
Queryable standard table with predefined specialized record type.

Dispose(Boolean)
Closes the database handle. After closing a handle, further method calls may throw InvalidHandleException.
(Inherited from Database.)
Dispose()()()()
Closes the handle. After closing a handle, further method calls may throw an InvalidHandleException.
(Inherited from InstallerHandle.)
DuplicateFiles
Queryable standard table with predefined specialized record type.

Equals(Object)
Tests whether this handle object is equal to another handle object. Two handle objects are equal if their types are the same and their native integer handles are the same.
(Inherited from InstallerHandle.)
Execute(String, array<Object>[]()[][])
Executes the query specified by a SQL string. The query may not be a SELECT statement.
(Inherited from Database.)
Execute(String, Record)
Executes the query specified by a SQL string. The query may not be a SELECT statement.
(Inherited from Database.)
ExecuteIntegerQuery(String, array<Object>[]()[][])
Executes the specified SQL SELECT query and returns all results as integers.
(Inherited from Database.)
ExecuteIntegerQuery(String, Record)
Executes the specified SQL SELECT query and returns all results as integers.
(Inherited from Database.)
ExecutePropertyQuery(String)
Returns the value of the specified property.
(Inherited from Database.)
ExecuteQuery(String, array<Object>[]()[][])
Executes the specified SQL SELECT query and returns all results.
(Inherited from Database.)
ExecuteQuery(String, Record)
Executes the specified SQL SELECT query and returns all results.
(Inherited from Database.)
ExecuteScalar(String, array<Object>[]()[][])
Executes the specified SQL SELECT query and returns a single result.
(Inherited from Database.)
ExecuteScalar(String, Record)
Executes the specified SQL SELECT query and returns a single result.
(Inherited from Database.)
ExecuteStringQuery(String, array<Object>[]()[][])
Executes the specified SQL SELECT query and returns all results as strings.
(Inherited from Database.)
ExecuteStringQuery(String, Record)
Executes the specified SQL SELECT query and returns all results as strings.
(Inherited from Database.)
Export(String, String)
Copies the structure and data from a specified table to a text archive file.
(Inherited from Database.)
ExportAll(String)
Exports all database tables, streams, and summary information to archive files.
(Inherited from Database.)
FeatureComponents
Queryable standard table with predefined specialized record type.

Features
Queryable standard table with predefined specialized record type.

FileHashes
Queryable standard table with predefined specialized record type.

FilePath
Gets the file path the Database was originally opened from, or null if not known.
(Inherited from Database.)
Files
Queryable standard table with predefined specialized record type.

Finalize()()()()
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
GenerateTransform(Database, String)
Creates a transform that, when applied to the object database, results in the reference database.
(Inherited from Database.)
GetHashCode()()()()
Gets a hash value for the handle object.
(Inherited from InstallerHandle.)
GetLifetimeService()()()()
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
Handle
Gets the native integer handle.
(Inherited from InstallerHandle.)
Import(String)
Imports a database table from a text archive file, dropping any existing table.
(Inherited from Database.)
ImportAll(String)
Imports all database tables, streams, and summary information from archive files.
(Inherited from Database.)
InitializeLifetimeService()()()()
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
InstallExecuteSequences
Queryable standard table with predefined specialized record type.

InstallUISequences
Queryable standard table with predefined specialized record type.

IsClosed
Checks if the handle is closed. When closed, method calls on the handle object may throw an InvalidHandleException.
(Inherited from InstallerHandle.)
IsColumnPersistent(String, String)
Checks whether a table contains a persistent column with a given name.
(Inherited from Database.)
IsReadOnly
Gets a boolean value indicating whether this database was opened in read-only mode.
(Inherited from Database.)
IsTablePersistent(String)
Checks whether a table exists and is persistent in the database.
(Inherited from Database.)
IsTransformValid(String)
Checks whether a transform is valid for this Database, according to its validation data and flags.
(Inherited from Database.)
IsTransformValid(SummaryInfo)
Checks whether a transform is valid for this Database, according to its SummaryInfo data.
(Inherited from Database.)
Item[([( String])])
Gets a queryable table from the datbaase.

LaunchConditions
Queryable standard table with predefined specialized record type.

Log
Gets or sets a log where all MSI SQL queries are written.

Medias
Queryable standard table with predefined specialized record type.

MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Merge(Database, String)
Merges another database with this database.
(Inherited from Database.)
Merge(Database)
Merges another database with this database.
(Inherited from Database.)
OpenMode
Gets the open mode for the database.
(Inherited from Database.)
OpenView(String, array<Object>[]()[][])
Gets a View object representing the query specified by a SQL string.
(Inherited from Database.)
Properties
Queryable standard table with predefined specialized record type.

Registries
Queryable standard table with predefined specialized record type.

RemoveFiles
Queryable standard table with predefined specialized record type.

SummaryInfo
Gets the SummaryInfo object for this database that can be used to examine and modify properties to the summary information stream.
(Inherited from Database.)
Tables
Gets the collection of tables in the Database.
(Inherited from Database.)
ToString()()()()
Returns the file path of this database, or the handle value if a file path was not specified.
(Inherited from Database.)
ViewTransform(String)
Apply a transform to the database, recording the changes in the "_TransformView" table.
(Inherited from Database.)
Inheritance Hierarchy
Object
MarshalByRefObject
  InstallerHandle
    Database
      QDatabase

Assembly: Microsoft.Deployment.WindowsInstaller.Linq (Module: Microsoft.Deployment.WindowsInstaller.Linq.dll) Version: 3.0.0.0 (3.9.1006.0)