VistaDB

From Wikipedia, the free encyclopedia

VistaDB
VistaDB 3.0 managed SQL database engine for .NET
Developer:	Vista Software
Latest release:	3.0 / December 27, 2006
OS:	.NET 1.1 .NET 2.0 64-bit .NET .NET Compact Framework Mono
Use:	Managed SQL database engine
License:	Commercial
Website:	www.vistadb.net

VistaDB is a fully managed and typesafe SQL database engine designed for the Microsoft .NET Framework, .NET Compact Framework and Mono platforms. VistaDB enables .NET developers to build robust small to midsize WinForms and ASP.NET applications that can run on desktops, mobile devices, and web servers using C#, Visual Basic .NET, Delphi.NET, and other .NET CLR-compliant languages.

Key features include Microsoft SQL Server T-SQL syntax and data types compatibility, a small 600KB single-file managed assembly with built-in ADO.NET Data Provider, full Unicode support, robust and secure data store with support for rich data types, large data capacity database, high-speed data processing, Copy 'n Go!™ deployment, royalty free distribution and much more. VistaDB's 600KB managed assembly is 50 times smaller than Microsoft SQL Express and MSDE, and VistaDB is over 40 times smaller than the Jet.

[edit] Features

• Fully managed and typesafe architecture
• Small 600KB footprint. Single managed assembly includes database engine, SQL query processor, Direct Data Access™ objects and .NET Data Provider!
• Supports Microsoft .NET Framework 2.0 and 1.1, Compact Framework 2.0 and 1.1, 64-bit .NET Framework, and Mono.
• Redesigned engine and data store to take full advantage of .NET's Common Language Runtime (CLR) and Garbage Collector (GC).
• SQL query processor compatible with Microsoft SQL Server T-SQL syntax
• Data types are 1:1 compatible with SQL Server 2005
• Built-in connection pooling
• ZeroClick™ deployment using Microsoft's ILMerge utility to fully embed the VistaDB assembly into your EXE or DLL. Using XCopy or FTP does not require access to the registry, Windows folder or GAC on client machines
• Deep integration into the Visual Studio 2005 IDE with new integrated support for Server Explorer
• Unicode support (NChar, NText and NVarchar support)
• 100% variable length data store architecture for .VDB3 database files
• CLR Procs™ let you write managed C# and Visual Basic .NET procedures to provide powerful data management. CLR Procs™ are more powerful than classical SQL-based Stored Procedures
• Support for traditional Stored Procs based on T-SQL syntax
• Support for Views
• Fully managed Data Builder tool allows developers to visually create and manage databases (Visual C# source code is included). New support for reverse engineering databases to create SQL scripts and support for viewing Query Plans.
• Fully managed Data Migration Wizard migrates existing databases to VistaDB database format (Visual C# source code is included)
• XML support now compatible with Microsoft SQL Server 2005
• Supports CLR compliant languages only (Visual C#, Visual Basic .NET, Delphi.NET, C++.NET, etc.)
• Supports .NET IDEs only (Visual Studio 2003, Visual Studio 2005, Borland Developer Studio 2005, Borland Developer Studio 2006, SharpDevelop etc.)
• Supports Windows Mobile 5.0 for Pocket PC (via CF 2.0)
• Supports Windows Mobile 5.0 for Smartphone (via CF 2.0)
• DataTable enables the high-speed DDA objects to work with databound controls
• Optimized low-level data encoding engine supports both ANSI and UTF8
• Full support for ADO.NET 1.1, ADO.NET 2.0 and all databound controls
• Managed Direct Data Access™ objects provide high-speed scrollable and updateable cursors for managing data tables
• Data storage architecture delivers a smaller database footprint
• Secure Blowfish encryption
• Data store supports 4TB of data, 64,000 tables, and 4GB of data per row
• Royalty free distribution!

[edit] External links

• http://www.vistadb.net/