VistaDB 5
Properties  Methods 

VistaDB.DDA Namespace : IVistaDBDatabase Interface
IVistaDBDatabase Interface Members

The following tables list the members exposed by IVistaDBDatabase.

Public Properties
 NameDescription
 PropertyName of active index that pivots current row order (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyWhether this database is encrypted at the database page level. ()  
 PropertyWhether the format version of this database supports page encryption (true) or only column encryption (false). If true then the column attribute "Encrypted" is meaningless. ()  
 PropertyDatabase sensitivity in character data  
 PropertyDatabase culture used to collate character data or apply date and time masks in filters or queries  
 PropertyThe unique key that points out current row when Key is read or set respective row to be current when Key is wrote (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyRow structure containing current table row columns While reading creates new current row copy. When writing, caches data in the table until Post is issued. (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyDatabase description  
 PropertyTests if a record movement function has placed the row pointer beyond the last row in the table. (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyGets or sets a value indicating whether constraint rules are followed when attempting any insert, update or delete operation (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyGets or sets a value indicating whether identities are active when attempting any insert operation (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyGet or set the manual setting for IDENTITY_INSERT ON (true) or OFF (false) for this table. This is independent from the one-table-at-a-time setting for a SQL connection but provides the same basic functionality to allow explicit value insertion for identity columns. (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyGet the value indicating whether the table is closed (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyWhether the format version of this database is the current version (the latest version known to this version of the VistaDB provider engine).  
 PropertyDatabase file resides in isolated storage  
 PropertyIsolation level for current transaction  
 PropertyRead the memory-cached value of last insert operation made to the identity columns by this table instance (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyRead the last value of identity columns that will be used by any client in nearest insert operation. This value is saved in the file storage. (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyRead current database opening mode  
 PropertyTable name (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyCurrent level for nested transactions  
 PropertyThe algorithm used to encrypt database pages ("None" if not enabled, null if N/A for this database format). ()  
 PropertyThe Page size in kilobytes. A setting of 1 = 1,024 bytes.  
 PropertyGet collection of regular indexes created and/or opened in this table instance (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyRelationships collection from the database  
 PropertyNumber of physical rows in the table (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyScans active index and calculates the keys in it, taking current scope operators into account. (WARNING: CAUSES SIDE-EFFECTS: The current row position of the parent table becomes undefined/EOF) (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyTests if a a record movement function has placed the row pointer before the first row in the table (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyGet collection of temporary indexes created and assigned to this table instance (Inherited from VistaDB.DDA.IVistaDBTable)
 PropertyRead only unique identifier assigned to this database schema version. Used for sync and schema updates systems. You cannot infer anything to the meaning of the guid other than to compare if they are equal. If they are equal then you have two databases with the exact same schema version.  
Top
Public Methods
 NameDescription
 MethodRestructure table in order to allow sync service to work  
 MethodAdd assembly from external file and store it in database for use by CLR Procs, triggers, etc. Does not load any third party dependencies. If you need an external dependency to be included you should ILMERGE the assemblies together.  
 MethodAdd table name to the table transfer list used by xml ExportXml/ImportXml functions.  
 MethodAlter table in according to new table schema  
 MethodOverloaded. Begin transaction in ReadCommitted isolation level  
 MethodClear table transfer list used by xml export/import routines.  
 MethodClose the table and clear respective resources (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCommit transaction  
 MethodDoes this database contain a table with this name?  
 MethodCreate constraint to check after insert, update or before delete operations (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate a default value for a column using an expression. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate foreign key constraint that instantiates respective relationship in the database (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate special index to use by full text search. Identity columns may not be used for FullTextSearch indexes. Only a single FullTextSearch index may exist per table. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate and initialize identity counter. Applied to integer type columns only. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate an index on current table. This may be a unique constrained index, or a primary key index. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCreate new table given the table schema. You should call NewTable() first to get the schema to pass to this function.  
 MethodCreate temporary index from given keyExpression. The index is not added to database but kept separately in the user temporary folder. The file is deleted by engine when the table is closed. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodRestructure table in order to exclude meta information allowing sync service to work  
 MethodImmediately deletes current row and reset row lock if it was set before delete operation (Inherited from VistaDB.DDA.IVistaDBTable)
 Method (Inherited from System.IDisposable)
 MethodDrop the assembly from database  
 MethodDrop existing constraint (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop an existing default value (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop foreign key constraint. Respective foreign key index will be deleted from the table as well. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop full text search index. No params are required as there may be only one Full Text Search (FTS) Index per table. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop existing identity column (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop existing index (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDrop existing table. The engine will verify it is possible to delete the table and maintain relationships integrity in the database before allowing the DropTable to succeed.  
 MethodEvaluate expression. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodTo export table data using constraint set on destination table. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodExport database schema and table data to xml-formated file according to the transfer list of tables. If relationships set in database, the information will be exported only concerning those ones, which link tables included into the transfer list.  
 MethodFind an expression in an index. This is for searching for exact and partial matching records. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodSet current row pointer to the first row position. If there are no rows, the EndOfTable flag is set to the true value (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodGet column value by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodGet a collection of the assemblies currently registered in the database (CLR Procs, CLR Triggers, etc).  
 MethodGet collection of Clr Procs in database  
 MethodOverloaded. Collection of CLR Triggers registered in database. These triggers are contained within an assembly and referenced through trigger naming.  
 MethodGets filter expression for current table state. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodGet last value assigned to the identity column in table insert operation at this database instance. The table inserted the row may be already closed at current moment.  
 MethodGet last value assigned to the timestamp column in the table insert operation for this database instance. The table inserted the row may be already closed at current moment.  
 MethodGets the IVistaDBRow objects containing current top and bottom rows of the applied scope. These objects before the first row and after the last row. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodCollection of table information  
 MethodRead Text, NText, Image data from database and put them to external file. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodOverloaded. Update database schema and import table data in according to the transfer list of tables.  
 MethodThe method should be called in the beginning the insert operation. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodInvoke Clr Procedure. Assembly must already be loaded into database and procedure name associated.  
 MethodInvoke the FillRow method for Clr Procedure  
 MethodSet current row pointer to the last row position. If there are no rows, the EndOfTable flag is set to the true value (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodLock row. If zero is passed, the entire table will be locked (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAdvances current row pointer position (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodThe first method to call in order to create new table in database. This method instantiates an IVistaDBTableSchema object and returns it.  
 MethodAdvances current row pointer position If there are no rows, the EndOfTable flag is set to the true value (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodOpen table  
 MethodThe method should be called to finalize insert or update operations. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodOverloaded. Prepare current context to use by Clr Procedure or Trigger  
 MethodMove row pointer one record ahead If there are no rows, the StartOfTable flag is set to the true value (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign column value with system type value by column order in the row. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign array of bytes value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign boolean value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign byte value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign DateTime value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign DateTimeOffset value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign Decimal value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign Double value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodPut Text, NText, Image data from external file to a column. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign Guid value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign int16 value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign int32 value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign int64 value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodSet null value by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign Float value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign string value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodAssign TimeSpan value to column by column's name (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodLooks for CLR Proc in assembly. If CLR Proc found, registers the link to this method by custom name  
 MethodLooks for CLR Trigger in assembly. If CLR Trigger found, registers user provided name.  
 MethodRename existing index without rebuilding. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodReset event delegate type called by DDA (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodReset all filters (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodReset scope in active index (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodRollback current transaction  
 MethodSet delegate method called by core engine by event (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodSet filter expression and try to optimize it if the optimize parameter is true (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodDefines a delegate that time consuming operations may call back in order to inform the user as to the progress of the operation and additional information. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodSet scope on active index to apply filter on the number of rows. The columns referenced in the scope operators must be present in the active index for them to work correctly. (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodGet table schema existing in the database. You may read table schema without opening the table  
 MethodTest if name of table, column, index etc. is correct  
 MethodUnlock row. If zero is passed, the entire table will be unlocked and all existing row locks will be released (Inherited from VistaDB.DDA.IVistaDBTable)
 MethodRelease current context used by CLR Proc  
 MethodUnregister the link to CLR Proc  
 MethodUnregister the link to CLR Trigger  
 MethodUpdate existing assembly registered in database with new assembly. Will remove any clr procs or functions that are not present in new assembly. Third party assemblies are not loaded into the database.  
Top
See Also