Gibraltar VistaDB 5.1.4.1523 » Developer.Team - Developers Paradise!

Gibraltar VistaDB 5.1.4.1523

Gibraltar VistaDB 5.1.4.1523
Gibraltar VistaDB 5.1.4.1523 | 31 Mb


VistaDB is the only .Net embedded database that allows you to Xcopy a single DLL for both 32 and 64 bit runtime support. Want ClickOnce deployment for your .Net application? VistaDB requires zero config on the client. No more worries about COM deployment for the database engine! Even our database files are built for ease of deployment - a single database file with no external logs or complex permissions.

.Net Database Basics
If a relational database doesn't have advanced features like updatable SQL Views, true referential integrity, cascading updates / deletes, table value params, T-SQL stored procedures, CLR Triggers, and CLR stored procs then why would you bother? Database engines that only provide basic ADO.NET features are a waste of your time. VistaDB is the most advanced embedded SQL desktop database engine in the world. We built VistaDB from the ground up to be a managed database engine, this is not some unmananged C++ database with a .Net wrapper!

Support VistaDB and SQL Server from the same executable?
Do you wish you could build a single executable that supported both SQL Server for multi user and another database on the desktop? We know how hard it is to build applications that support both desktop and client server from a single executable. VistaDB syntax contains the most commonly used features from SQL Server. All of our syntax will scale up to SQL Server. This means you can use one codebase in your product and run it against SQL Server and VistaDB. VistaDB fully supports the ADO.NET Provider Factory model. This allows you to dynamically load the database engine at runtime based upon application preferences. Many companies use VistaDB on the desktop and SQL Server for larger deployments. It is not the easiest way to write database code, and there is much less documenation around to explain how to do some things in Visual Studio. But if you take the time using Provider Factories can be a powerful runtime feature for your application.

.Net Database Admin Tools?
Some embedded databases give you an engine and nothing to edit or maintain the actual database. You usually have to purchase a third party DBA tool, build you own, or tell users to go download the large bulky tool from the vendor.


Defects Fixed in This Release
Engine

Fixed: A race condition in new-page allocation could allow corruption when a database is modified by multiple connections at the same time.
Fixed: Tables with wide row schemas may fail inserts or transactional updates with underlying "Value cannot be null" exception.
Fixed: Queries filtered by a long IN list can return incorrectly-empty results in some cases.

Data Migration Wizard

Fixed: DataMigrationWizard ignores column names in migration script when matching against source database and matches only by order.

Applies To
VistaDB version 5.1.4.1523


[/b]

[b] Only for V.I.P
Warning! You are not allowed to view this text.