This page includes a number of screenshots showing VistaDB screens and configurations. Click on a link below to jump to a specific area, or just scroll down the page. Click images to see full screen versions.
Visual Studio Integration with Server Explorer support
VistaDB is fully compatible with ADO.NET 2.0 which allows VistaDB to be tightly integrated into the Visual Studio 2008 IDE.
By providing native support for Visual Studio Server Explorer, you can connect to and use VistaDB databases just as you would SQL Server or SQL CE. Building typed datasets is exactly the same as what you are already used to doing today
VistaDB Data Builder
VistaDB Data Builder lets you visually create databases, tables and run interactive SQL. The ability to visual create data tables, foreign keys, enter data into your database and scroll through tables makes this a great DBA tool for most desktop database applications. We give an unbranded version of this DBA tool with complete C# source code for you to use as a quick and powerful DBA tool for your users.
You can use Data Builder to view data directly and optionally specify indexes and filter and scope expressions for application to the current view of the data. This provides a quick way to build DDA filter and scope expressions and test them against live data.
Instantly see the results of a View by clicking on the Data treelist item. This data is scrollable and provides a quick way to validate your SQL View is returning the desired results.
You can visually manage Foreign Key Relationships using Data Builder. The view here shows all the relationships for the database. Each table also shows only the relationships that apply to it directly.
The included Data Builder application provides full support for displaying image and other non text data inside the results pane.
The process of adding a CLR Proc assembly to a VistaDB database is easy with Data Builder. Simply select the .NET assembly that contains your C# or VB.NET code and VistaDB Data Builder does the rest. You can rename the static methods and see all the method signatures and parameter details.
Easily create columns and define column attributes simply by clicking and setting properties. Data Builder even lets you set column captions that can be used by your applications and column descriptions that can help document your database schema.
You can even define advanced data types such as Identity columns that provide efficient auto-increment support for column values. Other attributes include Primary Key settings, Read Only, Encryption, Compression, Full Text Search (FTS) for text columns, and quickly build indexes.