Database Engine
* 100% fully managed and verifiably typesafe architecture
* Small 600KB footprint
* Royalty-free distribution
* Developed in C#
* Cross-platform support: Windows, Linux, Mac OS X, Sun Solaris & BSB
* Built-in SQL Server 2005 T-SQL compatible query processor
* Built-in ADO.NET Providers for each platform
* Built-in Direct Data Access™ objects (DDA)
* ASP.NET Allow Partially Trusted Callers (APTC) attribute
* ASP.NET Isolated Storage support for alternate way to manage data
* Thread safe
* ZeroClick™ deployment allows engine to be fully embedded into your application using ILMerge so there are zero additional files to deploy
* Allow Partially Trusted Callers Attribute (APTC)
* Custom VistaDBDataTable component
* Single and multi-user support
* Simultaneous multiple connection support
* Database level, table level and row level locking
* In-memory databases and tables
* XML import and export
* Dynamically create and modify databases
* Connection Pooling
* Transaction Processing (ACID)
* Read Committed isolation for Transaction Processing
* Side-by-side multiple version deployments can co-exist
* Schema's can be altered using shared mode access
* Diagnostics
* Write-behind data caching
* Support for |DataDirectory|
Database Features
* Database supports up to 4TB
* Single file data store (.VDB3 database file)
* SQL Server 2005 compatible data types
* UNICODE support (NChar, NText, NVarChar)
* Secure Blowfish encryption (32-bit to 448-bit)
* Schema can be altered in Shared Mode
* Views
* CLR Procs™
* Constraints
* Primary Keys and Foreign Keys
* Referential integrity
* Cascading deletes and updates
* Disk space can be reclaimed
* Granular encryption of database, tables or columns
* Password protect database
* Primary and secondary indexes
* Compression attribute for columns
* Relationships
* Dynamic default values using functions
* Identity Types
* Image data storage (i.e. BLOB)
* Extended properties (table and column descriptions etc.)
* Database allows custom file extensions
* Variable length rows
Data Management Tools
Data Builder Tool
* Visually creating and manage database schemas
* Run interactive SQL
* Query Plan support
* Browse, add and edit data
* Visually manage CLR Procs™
* Manage Tables, Columns, Indexes, Relationships, Primary and Forein Keys
Data Migration Wizard
* Migrating data from SQL Server, SQL CE, VistaDB 2.x and Access to VistaDB 3.0
* Supports silent mode data migration
* Automatically generates migration logs and re-usable migration scripts
Types of Applications Supported
* ASP.NET apps
* Windows Forms (WinForms) apps
* Windows Services apps
* Windows Console apps
* Mono Gtk# for Linux Desktop and Web Services
* Mono Glade for Linux Desktop and Web Services
Languages Supported
* C# (includes samples)
* VB.NET (includes samples)
* Other CLR-compliant languages (e.g. Delphi.NET, J# etc.)
IDE Support
* Visual Studio 2005 with Server Explorer with non-Express Editions
* Visual Studio .NET 2003 with DataAdapter Wizards with non-Express Editions
* ASP.NET WebMatrix via code
* SharpDevelop via code
* Borland Developer Studio via code
Platforms Supported
* .NET Framework 3.0 - for Windows Vista/XP/2000/Server 2003
* .NET Framework 2.0 - for Windows Vista/XP/2000/Server 2003
* .NET Framework 1.1 - for Windows XP/2000/Server 2003
* 64-bit .NET Framework - for Windows 64-bit/Vista
* Compact Framework 2.0 - for Windows Mobile 5.0 Pocket PC & Smartphone Editions
* Mono 1.x - for Linux, Mac OS X, Solaris, Free/Open/NetBSD