VistaDB 3.2.1.38

VistaDB - embedded SQL database alternative to Jet and MSDE for .NET VistaDB is the #1 embedded database for building robust small to midsize .NET database applications using C#, VB.NET and Delphi.
VistaDB is an alternative database engine to Jet/Access and MSDE that provides robust, high-speed SQL data management in a small 500KB footprint, rich data types.
Main features:
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
- Schemas 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
Version restrictions:
- 30 days trial