VistaDB Software, Inc.

Database Engine

• 100% fully managed and verifiably typesafe architecture
• Small deployment - less than 1 MB footprint
• Royalty-free distribution
• Developed in C#
• Cross-platform support with Mono: Windows, Linux, Mac OS X, Sun Solaris & BSD
•  SQL Server 2005 TSQL compatible query processor
• ADO.NET 2 Provider - Full Provider Factory class support
• Built-in Direct Data Access objects (DDA) for xBase style
• ASP.NET Allow Partially Trusted Callers (APTC) attribute
• ASP.NET Isolated Storage
• No CPU or RAM usage limitations
• Native 64 bit support on Windows x64 platforms
• 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)
• Single and multi-user support (shared file access)
• Simultaneous multiple connection support (local processes or multi user across shared network drive)
• Database level, table level and row level locking
• In-memory databases and tables through Virtual Memory backed files
• XML import and export
• Dynamically create and modify databases
• Connection Pooling (ASP.NET)
• ACID compliant Transaction Processing
• Read Committed isolation
• Side-by-side multiple version deployments can co-exist
• Schema's may be altered using shared mode access
• |DataDirectory| macro drive mapping for App_Data

Database Features

• Database supports large file sizes limited by available RAM and storage on device
• Single file data store (.VDB3 database file)
• SQL Server 2005 compatible data types and syntax
• No CPU or RAM usage limitations
• UNICODE support (NChar, NText, NVarChar)
• Secure Blowfish encryption
• Schema can be altered in Shared Mode
• SQL Views
• CLR Procs and User Defined Functions
• TSQL Procs
• Table Value Params
• CLR Triggers
• Constraints
• Primary Keys and Foreign Keys
• Referential integrity
• Cascading deletes and updates
• Granular encryption of database, tables or columns
• Primary and secondary indexes
• Compression attribute for columns
• Relationships
• Dynamic default values using SQL functions
• Identity Types
• Image data storage (i.e. BLOB)
• Extended properties (table and column descriptions etc.) with Unicode support
• Database allows custom file extensions (Express Version does not)
• Variable length rows (varchar) up to 8096 in length
• Simple Full Text Search indexes
• Read only media support for runtime query from CD/DVD ROM

Data Management Tools

Data Builder Tool

• Visually creating and manage database schemas
• Run interactive TSQL with estimated execution plan
• Browse, add and edit data through familiar grid style interface
• Visually manage CLR Procs
• Manage Tables, Columns, Indexes, Relationships, Primary and Foreign Keys
• Source code and developer license allows customization and deployment as an admin tool for your product

Visual Studio 2005

• Designer integration within Visual Studio 2005 using the Server Explorer

Visual Studio 2008

• Designer integration within Visual Studio 2008 using the Server Explorer
• Entity Framework generation supported in Visual Studio 2008 SP1

Data Migration Wizard

• Migrating data from SQL Server, SQL CE, VistaDB 2.x and Access to VistaDB 3
• Supports silent mode data migration for command line scripting of migration
• Automatically generates migration logs and re-usable migration scripts
• Developer license allows redistribution with your application
• Source included with all developer licenses

Types of Applications Supported

• ASP.NET apps
• Windows Forms (Win Forms) apps
• Windows Services apps
• Windows Console apps
• Windows Workflow (WF)
• Windows Presentation Foundation (WPF)
• Mono .NET 2 applications

Languages Supported

• C# (includes samples)
• VB.NET (includes samples)
• Any CLR-compliant language (e.g. Delphi.NET, J#, Python.net etc.)

IDE Support

• Visual Studio 2005 (non-Express Editions)
• Visual Studio 2008 (non-Express Editions)
• ASP.NET Web Matrix via code
• SharpDevelop via code
• Borland Developer Studio via code

Platforms Supported

• .NET Framework 3.0/3.5 - for Windows Vista/XP/2000/Server 2003
• .NET Framework 2.0 - for Windows Vista/XP/2000/Server 2003
• 64-bit .NET Framework - for Server 2003 64-bit / Vista 64 Bit
• Compact Framework 2.0 - for Windows Mobile 5/6 (Pocket PC & Smartphone Editions)
• Mono .NET 2 - for Linux, Mac OS X, Solaris, FreeBSD