New Features In This Release

NuGet Packages for Entity Framework and Logging

You can now add VistaDB Entity Framework support and VistaDB Logging support for Loupe directly from NuGet.  This is particularly useful for Entity Framework because it automatically updates your application configuration file with the appropriate entries, adds the correct version of EF, and adds the provider assembly for VistaDB in one pass.

We encourage you to use the NuGet distribution where feasible because fixes and enhancements are occasionally released to NuGet prior to the next full product release.

Data Builder Hides Obsolete Encryption Options

As of VistaDB 5 encryption is performed at the full page level, not at the column level.  This was largely the case with VistaDB 4 as well and has significant performance advantages.  To preserve the ability to display the encryption status of VistaDB 3 and 4 databases the column-level encryption settings were previously displayed in Data Builder.  As of this release, we've hidden these fields when they do not apply as they caused confusion to users wondering if their databases were encrypted or not.  We have also updated the relevant API methods that managed column encryption with the Obsolete attribute to warn developers when they are still being used since they no longer apply.

Defects Fixed In This Release

Engine

• SQL Query Fix: Performing an ORDER BY on a SELECT UNION doesn't enforce order over all tables in the UNION
• SQL Query Fix: SELECT can return incorrect results for an OUTER JOIN that matches no rows when there are other peer INNER JOINS
• Entity Framework 6 Provider Fix: Using the Database-first designer fails with the Visual Studio EF Tools version 6.0.2 and later.
• Entity Framework 4 Provider Fix: VistaDB 5 isn't available in the data source list for making connections when using EF 4 and EF 5.
  

Data Builder

• Fixed: Extended length string fields (NVarchar(Max) and Varchar(Max), NText and Text) now display in the lower extended data area when viewing the data of a table.
• Fixed: Data Builder process doesn't exit when no license is provided at startup and the window is closed.
• Fixed: Data Builder reports an error when running second query after a query is performed on a database with any compilation issues.