VistaDB 5

VistaDB.DDA Namespace : IVistaDBDatabase Interface
IVistaDBDatabase Interface Methods

For a list of all members of this type, see IVistaDBDatabase members.

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