VistaDB.Net Logo

VistaDB 4 Build 10

by Jason Short 12 November 2009

Build 10 is mostly a rollup of fixes from user tickets over the past few weeks.  This will also become the new trial version since it works with Visual Studio 2010 Beta 2.

ASP.NET Membership

Corrected issues in the VistaDB ASP.NET Membership providers and wizards pertaining to the Asp.Net Configuration Wizard of Visual Studio. The web.config should persist newer provider entries, and the license manager can correctly fall back to the design time license for use in the Asp.Net Configuration wizard of Visual Studio.

Corrected issue in the VistaDB ASP.NET Membership providers where the GetRolesForUser and GetUsersInRoles methods were not returning any results when roles were mapped in the database.

DBNull vs Null

Corrected VistaDBDataReader to return DBNull instead of null on column values.  Attempts to read from a row that contained a null value would return null rather than DBNull.  The SQL Server behavior is to return DBNull, so we have changed to match that behavior.  This was actually performed in Build 7, but we forgot to include it in the release notes.

DBA Sample Tool Update

A big thanks to Chris Bray (long time Team VistaDB member, customer, and contributor) for updating the DBA Sample tool.  Chris made a number of changes to make it faster to modify the tool to be branded for your own company, and updated some features as well. 

There were also some artifacts still left of VDB3 in the code that he removed.  This sample can be used commercially within your applications, but may not be sold as a stand alone product or tool.  You have to be including it with a product for your users to use as an admin tool, something like that.  It should not be used as a data entry replacement - it is not end user friendly in that regard.  Tech support personnel, local admins, etc are all good candidates for the tool. 

A new file (Common.cs) has been included to allow a central point for the customization of the tools naming and config options.

The DBA Sample Tool is a tremendous time saver for building a tool your tech support people can send to customers.  We have had a number of companies tell us this tool alone was worth the purchase price because it saved them more than the VistaDB license cost in programmer time to build something like this for their applications.

Fixes

Fixed a memory leak in Data Builder when browsing the Data tab memory could become pinned due to certain column types not being cleaned out of the grid.

Fixed a column result returning inaccurate results with sub queries that are filtered by columns in their parent query.  This behavior is used in some cases through Entity Framework when using aggregates like Count on sub queries.

Fixed an issue where performing a database update in an Entity Framework model with views present would generate an error.

Comments are closed

Powered by BlogEngine.NET and VistaDB

Log in