Local database and updates

I'm reviewing an application that uses a local database for a .NET
application. In adding logic to automatically update components of the
application (content files, assemblies updates, and data updates) I found
that the original design locks the database while the app is running. This
means that the updater code needs to detect a runnning instance of the .NET
app and signal it to close down before it can apply database updates. This
makes it impossible to apply updates automatically.

It seems to me that tightly linking the database to the .NET app is
unnecessary. I see no reason why the database cannot be updated while the
application is running. The updater itself could lock portions of the
database during updating to prevent corruption and then signal the
application to refresh its in-memory data once the updates have been
committed.

I'd appreciate any feedback from others about this issue as I want to be
sure that I've thought through all the possibilities.

TIA.

--
Peter Bernhardt
SharpSense Software LLC
peter@xxxxxxxxxxxxxxxxxxxx


.

Relevant Pages

  • Re: Updating a database
    ... whilst the backend is an Access database. ... >>>I do changes to the app and the database (add fields, change queries, ... >>>User A updates to Version 1.1 ... >> the update by running the appropriate scripts. ...
    (microsoft.public.vb.general.discussion)
  • Re: Like I said...
    ... > rich apps running a unidirectional database connection. ... > Can you access regular $50 USB scanners via TWAIN in an app shared ... > updates to the clients. ... you can only do this with middleware ...
    (borland.public.delphi.non-technical)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: sql server express connection
    ... is that though the data has been refreshed and the win app ... reconnects to the database to collect the updates it does not ... better way of 2 apps using the same database without having to attach it. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
Quantcast