Easy to Deploy, Program & Upscale
-
Easy to Deploy
The VistaDB engine is a single, small managed assembly you deploy with your app and each database is a single file. Using Xamarin, you can fit a full RDBMS on your phone!
-
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. Thanks to ADO.NET, VistaDB is already compatible with a wide range of third party ORMs, reporting systems and more!
-
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.
Works with Anything built on ADO.NET
Think of all the things built on top of ADO.NET - not just your application but reporting systems, ORMs, and other data-driven libraries for .NET. You can use all of these in your application with our easy to deploy, cross-platform database engine.
Thanks to ADO.NET's provider model, you can even have one application easily support Microsoft SQL Server and VistaDB with just a change in a connection string! Perfect for scale-down scenarios like stand alone deployments and demo versions.
How we measure up
When you want to ship a full featured SQL database in your application VistaDB offers a compact, easy to integrate option with the SQL language you're used to.
| Microsoft SQL Express | SQLite | VistaDB | |
|---|---|---|---|
| Distribution Size | 132MB | 1MB | 1MB |
| T-SQL Language Support | Yes | No | Yes |
| Optimized Multi-thread/Multi-process Support | Yes | No | Yes |
| No Privileges Required | No | Yes | Yes |
| Easy Database Distribution | No | Yes | Yes |
| Universal Binary | No | No | Yes |
Straight-forward licensing
We know your whole team will want access to VistaDB. That's why our simple licensing model covers every developer working out of one location, no matter how big your team is! (Remote workers too)
Better yet, the VistaDB Engine is Runtime Royalty Free so whether you're deploying to 10 computers or 10 million, there's no additional cost.