Features
VistaDB consists of a redistributable database engine, Visual Studio integration, tools for data management, documentation, sample code and our fanatical technical support. In addition, VistaDB works with various ORMs and other third party tools.
What you get
-
Visual Studio Integration
VistaDB integrates tightly with Microsoft Visual Studio 2019, 2017, and 2015 so you can create databases and alter their schema, indexes and more directly inside Visual Studio.
-
Entity Framework Integration
VistaDB Supports Entity Framework for easy access to your relational data without writing T-SQL code.
-
Mobile Support
Use the same powerful engine anywhere you use .NET - for Windows, Linux, iOS, Android, and Macintosh. VistaDB fully supports Xamarin making it the only option for T-SQL support on mobile phones and tablets.
-
VistaDB Database Engine
No SQL database is easier to deploy than VistaDB. With just a single, fully .NET assembly to add to your application there's nothing to install, nothing that requires elevated privileges or additional dependencies. Each database is a single file with your full schema and data. Backup and restore is as easy as copying files.
-
Data Builder
Data Builder is a powerful yet easy-to-use application that lets you visually create and manage VistaDB databases.
-
Data Migration
The Data Migration Wizard makes it easy to migrate existing schema and data from SQL Server, SQL Server CE, or Microsoft Access (MDB and ACCDB) to VistaDB's database format.
Easy to Deploy, Program & Upscale
VistaDB is the ideal embedded database for .NET applications on .NET Framework, .NET Core, and .NET 6: easy to deploy, easy to program, easy to upscale to SQL Server.
Easy to Deploy
The VistaDB engine is a single, small managed assembly you deploy with your app and each database is a single file. No hassles with different versions for x86 versus x64. No COM objects to register. No installer to run. No database server to administer. Just xcopy and go!
Easy to Program
VistaDB is a fully compliant ADO.NET data provider with support for Entity Framework, ADO.NET, and Typed Datasets as well as its own Direct Data Access API for efficient cursor-based operations. VistaDB offers impressive compatibility with T-SQL including stored procedures, updatable views, cascading updates / deletes, table value params, CLR Triggers and CLR stored procs.
Easy to Upscale
VistaDB fully supports the ADO.NET Provider Factory model allowing you write one codebase that can target either VistaDB or SQL Server at runtime. Use VistaDB for the "lite" version of your application in which size and easy of deployment are paramount. And when greater scalability is required, upscale to SQL Server with no code changes.