VistaDB Data Access Components

VistaDB Data Access Components (VistaDBDAC) is a feature-rich and high-performance library of components that provides native connectivity to VistaDB database from Delphi for both 32-bit and 64-bit Windows platforms. VistaDBDAC-based applications connect to VistaDB database directly through the VistaDB.Net, which is an ADO.NET provider for VistaDB. VistaDBDAC is designed to help programmers develop faster and cleaner VistaDB database applications with no need to deploy any additional libraries. VistaDBDAC is lightweight and performs well because it is optimized to access VistaDB databases directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

VistaDBDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

Component List

VistaDBConnection  

TVistaDBConnection
This class is responsible for establishing connection with VistaDB database.

VistaDBCommand  

TVistaDBCommand
This class is responsible for executing a Transact-SQL statement or stored procedure against a VistaDB database.

VistaDBDataReader  

TVistaDBDataReader
This class is responsible for providing a way of reading a forward-only stream of rows from a VistaDB database.

VistaDBDataAdapter  

TVistaDBDataAdapter
This class is responsible for filling Virtual Table components with data and update a VistaDB database.

VistaDBtQuery  

TVistaDBQuery
This class uses SQL statements to retrieve data from tables in a VistaDB database and pass it to one or more data-aware components through a TDataSource object. This component provides a mechanism for updating data.

VistaDBTable  

TVistaDBTable
This class is responsible for retrieving and updating data in a single table in a VistaDB database without writing SQL statements.

SqlClientStoredProc  

TVistaDBStoredProc
This class is responsible for executing stored procedures and functions in a VistaDB database.

Features

  • Direct access to VistaDB database. Does not require installation of other data provider layers (such as BDE)
  • Full support of the latest versions of VistaDB
  • Transmission is via XML format, therefore can pass through firewalls
  • High overall performance
  • High performance in batch processing. This is controlled by UpdateOptions.UpdateBatchSize property
  • Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
  • CachedUpdates operation mode which is controlled UpdateOptions.UpdateMode property
  • Automatic data updating with TVistaDBQuery, TVistaDBTable, and TVistaDBStoredProc components
  • Fast data retrieval with TVistaDBDataReader component or using Server CursorKind property of the TCustomClrDataSet
  • Automatic record locking
  • Automatic query preparing
  • Data export and import to/from XML
  • Unicode support
  • Easy to deploy

Supported Databases

  • Any VistaDB Database