VistaDB 5
Fields  Properties  Methods  Events


VistaDB.Provider Namespace : VistaDBConnection Class
VistaDBConnection Class Members

The following tables list the members exposed by VistaDBConnection.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Fields
 NameDescription
Public Fieldstatic (Shared in Visual Basic)System table name  
Public Fieldstatic (Shared in Visual Basic)System table type name  
Public Fieldstatic (Shared in Visual Basic)User table type name  
Top
Public Properties
 NameDescription
Public PropertyGets the setting from the connection string for this connection. Read only, may not be changed after opening the connection.  
Public PropertyOverridden. Gets or sets the string used to open the connection. Class VistaDBConnectionClass VistaDBConnectionStringBuilder  
Public Property (Inherited from System.Data.Common.DbConnection)
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyUsed only inside CLR stored procedures. If it is set to true the context connection is used.  
Public PropertyOverridden. Get the name of the database.  
Public PropertyOverridden. Get the name of the database.  
Public PropertyIf it is set to true the database placed in isolated storage.  
Public PropertyAn integer value that represents the time in seconds as the maximum time a transaction is locked. 10 seconds is the default, negative values reset to default. Maximum time is one hour.  
Public PropertyGets a value that indicates connection open mode.  
Public Property(BETA ONLY) Get the current optimization setting of this (open) VistaDBConnection as a string. This string value will be an option which can be used with the "SET OPTIMIZATION {0}" command.  
Public Property(BETA ONLY) Get the current optimization setting of this (open) VistaDBConnection as a version string (or "Off"). This string value will be the approximate version equivalent of the current optimization setting.  
Public PropertyGet the string used for the base of the encryption key.  
Public PropertyControl lifetime of .lck files on hard drive. If it is set to true this connection will not try to delete these files upon table closing. It may give some performance boosting in multi-user environment.  
Public PropertyOverridden. VistaDB version for connection information (We only really need major / minor here for client compatibility)  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyOverridden. Gets a value that describes the state of the connection.  
Public PropertyGets the current TransactionMode for this connection. Read only, may not be changed after opening the connection. Class VistaDBConnection Class VistaDBConnectionStringBuilder  
Top
Protected Properties
 NameDescription
Protected Property (Inherited from System.ComponentModel.Component)
Protected PropertyOverridden. DB Provider Factory object  
Protected Property (Inherited from System.ComponentModel.Component)
Protected Property (Inherited from System.ComponentModel.Component)
Top
Public Methods
 NameDescription
Public MethodOverloaded. Starts a database transaction on the current connection. Because BeginTransaction creates a new transaction and associates it with the current connection that created it, you can simplify your code by using this method rather than allocating a new transaction and then assigning it manually. Class VistaDBConnection  
Public MethodOverridden. This method is not supported and should not be called.  
Public Methodstatic (Shared in Visual Basic)Empties all of the connection pools associated with the current connection.  
Public Methodstatic (Shared in Visual Basic)Empties a single connection pool associated with the specified connection. This may be useful if you are wanting to release a single connection string but keep other connections active in your application.  
Public MethodOverridden. Closes the connection to the database. It is considered a best practice to close the database connection as soon as you are finished with it. Putting the VistaDBConnection within a using() statement is the easiest way to ensure it is actively cleaned up fast. Do NOT place this call in an object destructor or Finalize call. That will lead to non-deterministic release of object handles and potential connection leaks. Class VistaDBConnection  
Public MethodCreates and returns a new VistaDBCommand object associated with the current connection.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Overridden. Dispose the object and release all resources. A best practice for performing this automatically is to put all your VistaDBConnection objects within Using() statements to ensure they are cleaned up in a timely manner.  
Public Method (Inherited from System.Data.Common.DbConnection)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Overridden. Returns schema information for the data source of this VistaDBConnection. See the MSDN Topic "Understanding the Common Schema Collections" for in depth information about Schema collections. Class VistaDBConnection  
Public MethodGets the schema for a given table from the current open connection.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodCheck SQL command of the constraint to validate it is correct.  
Public MethodCheck SQL command correctness. This does not actually execute the command or validate the structures on disk. It only parses the command and attempts to verify that the parser can split the tokens or not.  
Public MethodCheck SQL command correctness of CREATE VIEW statement  
Public MethodOverridden. Opens a database connection with the settings specified by the ConnectionString.  
Public MethodOverloaded.  (Inherited from System.Data.Common.DbConnection)
Public Methodstatic (Shared in Visual Basic)Overloaded. Pack database to compress free space in the database and reorganize the internal layout of the database on disk.  
Public Methodstatic (Shared in Visual Basic)Overloaded. Attempt to repair a physically or logically corrupted database file.  
Public Method(BETA ONLY) Change the current optimization setting of this (open) VistaDBConnection. This setting can also be changed by executing the "SET OPTIMIZATION {0}" SQL command with the desired option.  
Public Method (Inherited from System.ComponentModel.Component)
Top
Protected Methods
 NameDescription
Protected MethodOverridden. Starts a database transaction.  
Protected MethodOverridden. Create a new DbCommand object from the current VistaDBConnection.  
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method (Inherited from System.ComponentModel.Component)
Protected MethodOverloaded.  (Inherited from System.MarshalByRefObject)
Protected Method (Inherited from System.Data.Common.DbConnection)
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Public EventCallback event for SQL PRINT Statements Class VistaDBConnection Class VistaDBInfoMessageEvent VistaDBInfoMessageEventEventArgs.Message  
Public Event (Inherited from System.Data.Common.DbConnection)
Top
See Also