VistaDB 4.0 was released in July 2009 as a replacement to the VistaDB 3.x engine.
The VistaDB 4 .Net database engine has an improved API, better SQL Syntax support,
improved memory handling, internal changes for performance enhancements, and much
more. VistaDB 4 also introduces our Entity Framework provider for Visual Studio
2008 / 2010 / 2012.
- Visual Studio 2008 / 2010 / 2012 Designers
- Changes for Entity Framework support and Visual Studio 2008 object model
- Data Builder
- Syntax highlighting and colorizer for SQL Script Editing
- Migrate VDB3 files internally through Pack Operation
- Tab support in TSQL Procs and most text editors
- SQL Script generation removed
- VistaDB Engine
- Improved compatibility with SQL Server Syntax
- CLR Proc changes to improve SQL Server compatibility and make it easier to support
dual deployment of CLR Proc assemblies
- CLR Trigger changes for synax and compatibility
- Namespace changes to include a new compatibility namespace to help matching SQL
Server conventions
- Entity Framework assembly dynamic load during query from ADO.NET 3.5 Provider Factory
- GetSchema syntax and columns returned changes to support Entity Framework
- Entity Framework Support
- ADO.Net 3.5 SP1 (also sometimes called Entity Framework V1) support
- ADO.Net 4.0 EF (also sometimes called EF V2) support
- Changes to GetSchema in the main engine were required to support some Foreign Key
mapping constraints
- Sample Applications
- Online Help Files
- Updates and changes in the Help files
- New sections on Foreign Keys, GetSchema, CLR Trigger, and CLR Proc compatibility
in VistaDB 4
- CLR proc cection added with sample
- CLR function added with sample
- Explanations of differences between CLR Functions and CLR Procs