Visual Studio Integration
VistaDB is integrated tightly into Microsoft Visual Studio 2017, 2015 and 2013 environments.
Visual Studio Integration Features in VistaDB
The VistaDB Designer for Visual Studio extends the Server Explorer with a complete interface for developing VistaDB databases including schema design, modeling, editing, and data manipulation.
Of course, you can always use Data Builder outside of Visual Studio for VistaDB database development but it’s great to have everything you might need available within your IDE.
Entity Framework 6 / 5 / 4
The VistaDB Entity Framework provider supports Entity Framework 6 as well as EF5 and EF4. You can generate EF models with Visual Studio using the Database-First approach where you create the VistaDB database using your preferred approach and then import that database into your Entity Model. For more information see the power of VistaDB’s support for Entity Framework.
ADO.NET Support (Of Course!)
VistaDB is also a fully compliant ADO.NET provider factory that supports .Net 2 through .Net 4.7. The basic database engine and ADO.NET provider only requires .Net 2 SP1 or higher in order to run, the Entity Framework provider requires .Net 4.x.
Native support for the Server Explorer lets you connect to and use VistaDB databases as you would Microsoft SQL Server, including visual query creation inside the Visual Studio IDE.
Full support for ADO.NET Provider Factories also means you can write generic data access code and change the connection string to load VistaDB or SQL Server at runtime for a single application build that supports multiple backend data stores.
To see all of the features available check out the VistaDB Visual Studio Users Guide.