
VistaDB is an embedded database that executes in-process with your application. The database is stored in a single file that may be renamed in order to be used as a file format for your application. The program allows you to seamlessly embed the .net database engine into your application for the best possible end user experience. No need to deploy complex servers or multiple editions for 32 and 64 bit platforms.
v5.0 [Sep 1, 2014]
- SQL Query Fix: Quoted table name or alias with a wildcard (such as [Table Name].* fails to parse correctly.
- SQL Query Fix: IN operator against a sub-query can result in a NullReferenceException.
- SQL Query Fix: REPLACE function returns NULL instead of original string when first string argument is shorter than second string.
- SQL Query Fix: REPLACE function raises error instead of returning original string if second argument is empty.
- SQL Query Fix: Cache optimized JOINs can produce incorrect results when OR is used in WHERE or ON clauses to combine conditions referencing different tables.
- Transaction Fix: Disposing an ADO.NET transaction object can throw an exception complaining that the connection must be open.
- Entity Framework Provider Fix: Adding new rows fails on tables with Identity keys under EF 6 in some cases.