Home Products VistaDB 2.1 VistaDB 2.1 .NET Edition

VistaDB 2.1 .NET Edition

2.1 is no longer sold or supported - these pages are for reference purposes only. VistaDB 3.x should be used for all new development.

Features

• Create WinForms and ASP.NET applications
• Includes managed C# source code to .NET Provider and DDA™ objects
• Compatible with .NET data bound controls and 3rd party components
• Easily scalable from embedded to client/server configuration with 5 lines of code
• Full ability to create and manage VistaDB .VDB databases via code
• Royalty free unlimited distribution

Note that the .NET support of VistaDB 2.1 Suite is a hybrid of unmanaged and managed code. The 2.1 core engine is an unmanaged Win32 .DLL and the .NET Data Provider is managed. See the new VistaDB 3 for the ultimate in .NET support.

Includes

• VistaDB embedded engine (600KB file) with royalty free deployment
• 2-User VistaDB Server with royalty free deployment
• Data Builder Utility for creating and managing databases
• Data Migration Wizard for migrating databases to VistaDB
• Demo and samples with full source code
• Help files

Supported .NET Languages

• C#
• VB.NET
• Delphi .NET

Supported Platforms

• .NET 1.1 & 2.0
• Win32

Supported .NET IDEs

• See screenshots
• Visual Studio .NET 2003 
• Visual Studio 2005 
• Delphi 2005 
• SharpDevelop 1.x 

Components

• Managed ADO.NET Data Provider
  •   VistaDBDataAdapter
    Works like SqlClient. Fills datasets with data defined by SQL commands and queries from VistaDBCommands.
  •   VistaDBCommand
    Works much like SqlCommand. Runs SQL-92 queries and commands to manage data in a VistaDB database. The Query object supports all the common SQL statements such as SELECT, INSERT, UPDATE, DELETE and more.
  •   VistaDBConnection
    Works much like SqlConnection. Connects to a .VDB database and allows you to manage database level settings such as encryption.
  •   VistaDBDataSet
    Unique to VistaDB. Works much like DataSet. Connects databound controls to VistaDB data tables using high-speed, low overhead DDA objects. More efficient than the standard .NET disconnected datasets yet provides all the convenience of databound controls support, including the DataGrid.
  •   VistaDBDataReader (non-visual)
    Works much like SqlDataReader. VistaDBTable is modeled after DataSet to provide direct data access with live data cursors to VistaDB tables without the overhead of ADO.NET. VistaDBTable provides high speed direct table access that is faster than ADO.NET.
• Managed Direct Data Access™ Objects
  •   VistaDBTable (DDA non-visual)
    Unique to VistaDB. VistaDBTable is modeled after Dataset to provide direct data access with live data cursors to VistaDB tables without the overhead of ADO.NET. Connects to VistaDB tables allowing you to add, delete, update, filter and find data, along with other table related operations. VistaDBTable provides high speed direct table access that is faster than ADO.NET.
  •   VistaDBDatabase (DDA non-visual)
    Unique to VistaDB. VistaDBDatabase works with VistaDBTable to provide direct data access to VistaDB .VDB data stores without the overhead of ADO.NET.

IDE Integration

The VistaDB ADO.NET Data Provider is fully integrated into all Microsoft Visual Studio .NET IDEs. The VistaDBDataAdapter features a design-time wizard that generates VistaDB database connections and SQL statements.

VistaDB ADO.NET Provider is compatible with Delphi 2005 and C#Builder. The VistaDBDataAdapter, VistaDBConnection and VistaDBCommand components get installed into the Delphi 2005 IDE and VistaDBDataReader and DDA objects VistaDBTable and VistaDBDatabase are available as a non-visual components.

VistaDB is compatible with SharpDevelop, which is a free .NET development tool developed in C#. The VistaDBDataAdapter, VistaDBConnection and VistaDBCommand components get installed into the SharpDevelop IDE and the VistaDBDataReader is available as a non-visual component.