VistaDB 3 database engine was developed in C# specifically for Microsoft .NET Framework, Compact Framework and Mono. VistaDB is the perfect embedded alternative to SQL Server. Use our embedded engine for developing small to midsize managed ASP.NET and WinForms applications that run on desktops, mobile devices and web servers. VistaDB 3 delivers high-performance data management in a small single-file footprint. Lightweight deployment means no registry access or service installation required. VistaDB is a true transactional TSQL compliant RDBMS that delivers robust data management. As an embedded database, it requires zero administration and ZeroClick deployment lets you embedded VistaDB directly into your EXE and DLLs using ILMerge. Licensed per developer.
VistaDB is deeply integrated into Visual Studio 2005 and 2008 so building applications is easy and intuitive. VistaDB features a built-in ADO.NET Provider that supports SQL and Direct Data Access objects that provide object-based high-speed scrollable and updateable cursors. VistaDB's SQL query processor supports T-SQL syntax and VistaDB's data types are highly compatible with SQL Server. A high degree of compatibility with SQL Server 2005 means existing T-SQL statements and procs can be re-used with small changes and source code that uses SQL Server can be re-used with minor changes to namespaces and class references.
Other features include a Data Migration Wizard tool that migrates data from MS-Access, SQL Server, SQL CE to VistaDB (C# source code included) and a Data Builder tool for visually creating and managing databases (C# source code included). The robust single-file data store stores ANSI and Unicode data, tables, views, CLR Procs, CLR Triggers, indexes, Full Text Search (FTS), constraints, primary and foreign keys and data can be encrypted at the database, table or column level using Blowfish. Full transaction processing with Snapshot isolation level ensure that VistaDB is ACID compliant.