Keeping Windows Applications Up-To-Date via Auto-Updates

<h1>Keeping Windows Applications Up-To-Date via Auto-Updates</h1>

<p align=right>by Andrew Coulson</p>

<div align=justify><P><B><SPAN style="FONT-SIZE: 18pt; FONT-FAMILY: Arial">Keeping Windows Applications Up-To-Date via Auto-Updates</SPAN></B></P>
<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">As a developer of commercial Windows and .Net applications and components, one problem I've had to grapple with on many occasions is how to automatically distribute patches or updates for applications or components we sell.  Our goal was to update-enable applications we develop, allowing them to poll for and, optionally, automatically apply designated patches or updates.</SPAN></P>
<P><FONT size=2><SPAN style="FONT-FAMILY: Arial">In this article, I outline some of the options for creating auto-update applications and describe, in detail, the approach we finally took.</SPAN></FONT></P>
<P> </P>
<P><SPAN style="FONT-SIZE: 14pt"><B><SPAN style="FONT-FAMILY: Arial">Overview</SPAN></B></SPAN></P>
<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Our solution needed to be easy to implement on the client side, but also flexible enough to allow us to perform update-related activities that could potentially perform unusual tasks specific to the application. It should provide simple, 'native' support for typical update activities; like installing updated files or assemblies, adjusting registry entries, or launching a downloaded executable (It should support the ability to launch software installers built by Visual Studio or other installer creation tools). Ideally the solution would also support customized, application-specific tasks - starting or stopping services, for example.  Also, </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> it would need to be a component that we can easily embed in our end-user applications and utilities, although it would also be nice to be able to deploy the solution as a stand-alone 'agent' which runs independently of our applications.  </SPAN></P>
<P style="MARGIN-BOTTOM: 0px"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We wanted our solution to be robust enough to allow us to customize the behavior and UI of the update process with minimal effort. Some examples of customization features we were interested in included: </SPAN></P>
<UL type=circle>
<LI>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The ability to enable end-users of an application using this update component to do things like manually check for updates via a button or menu option</SPAN></DIV>
<LI>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Control over whether the update check, download, and application process happen transparently, or prompt the user first</SPAN></DIV>
<LI>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The ability to override UI elements like prompt and progress forms and indicators with customized versions providing custom look-and-feel</SPAN></DIV></LI></UL>
<P></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Since we can't predict where our applications (or applications incorporating our components) will be deployed, we want the communication between the client and the server to be over the HTTP protocol - ensuring maximum compatibility with secure, fire-walled environments.  Furthermore, end-users of these update-enabled applications will essentially be 'anonymous'  to us - we don't necessarily know anything about the network environment where our app lives.  The process should therefore be client-driven - the agent should poll for updates then request them if any are available.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Finally, the solutions needed to be relatively inexpensive.</SPAN></P>
<P class=MsoNormal> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 14pt"><B><SPAN style="FONT-FAMILY: Arial">To Build or not to Build</SPAN></B></SPAN></P>
<P class=MsoNormal><FONT size=2><SPAN style="FONT-FAMILY: Arial">I began by looking at the commercial and open-source solutions.  While a number of commercial products are available, I found that many of them tended to be strongly focused on managing the desktop in an Enterprise environment. Features like the ability to inventory the desktop, compliance and vulnerability management, the ability to push software packages to named sets of machines, and robust reporting are all valuable for administrators of internal networks, but are overkill for our use-case.  We just wanted a simple, embeddable agent which polls for updates for the specific apps it's embedded in.  </SPAN></FONT></P>
<P class=MsoNormal><FONT size=2><SPAN style="FONT-FAMILY: Arial">There are some commercial solutions which are more focused on update-enabling specific apps, but they tend to be complicated to implement, not very customizable, not embeddable, or not .NET-friendly.  The commercial products also tend to be moderately to prohibitively expensive.</SPAN></FONT></P>
<P class=MsoNormal><FONT size=2><SPAN style="FONT-FAMILY: Arial">Open source solutions seem to be completely lacking for this use-case on the .NET platform.  A notable exception is 'sample' application available from Microsoft's <A href="http://windowsforms.net/Default.aspx">.NET Framework Windows Forms website</A>.  The .Net Application Updater Component described there (and available for download) seemed to be closer to what I was looking for in terms of a simple, lightweight component which can be embedded in an app.  The component is dropped into your app, then polls a server for "manifests" available for that application and, if any are available, downloads the files described there.  Unfortunately, the Updater Component is truly a sample application.  Setup of the host is done manually, managing the host manifests and file repository is entirely manual, and there is virtually no client-side support for user prompting, custom progress UI's, etc. It is left to the developer to build out more robust features beyond simple update download.  Update support is also limited exclusively to downloading files and assemblies. Still, the approach of using a lightweight client component that connects over HTTP via web services to perform simple update downloads was in line with the kind of solution I was looking for.</SPAN></FONT></P>
<P class=MsoNormal><FONT size=2><SPAN style="FONT-FAMILY: Arial">Ultimately, given the mismatch between commercial products and the features we required and the lack of robustness in free solutions, we chose to develop our own solution.</SPAN></FONT></P>
<P> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 14pt"><B><SPAN style="FONT-FAMILY: Arial">A Web-based Patch and Update Solution</SPAN></B></SPAN></P>
<P><FONT size=2><SPAN style="FONT-FAMILY: Arial">Based on our requirements and the nature of our end-users, we determined that that our solution would have the following characteristics:</SPAN></FONT></P>
<UL>
<LI>
<DIV>
<P style="MARGIN-BOTTOM: 5px"><FONT size=2><SPAN style="FONT-FAMILY: Arial">A client-side component agent that would be both very simple to implement, but also provide access to more detailed API's allowing the developer to have more control over the process with an investment greater implementation effort.  It would support the ability to easily embed the agent component in update-enabled apps and we would also create a stand-alone agent - essentially an application using the component that runs in the SysTray.  A config file would contain the identity of the update-enable application as well as settings controlling the agent behavior.  These settings would also be exposed by the API, enabling the developer to control the agent behavior programmatically, if desired.</SPAN></FONT></P></DIV>
<LI>
<DIV>
<P style="MARGIN-BOTTOM: 5px"><FONT size=2><SPAN style="FONT-FAMILY: Arial">The update framework would support the ability to deliver new or updated files (which could include assembly .dlls), the ability to create and update client registry entries, the ability to invoke a custom .Net Installer assembly, and the ability to download and invoke an executable.  Furthermore, the framework would be extensible, allowing us to add new custom update actions in the future, if need be.</SPAN></FONT></P></DIV>
<LI>
<DIV>
<P style="MARGIN-BOTTOM: 5px"><FONT size=2><SPAN style="FONT-FAMILY: Arial">We would create a web-based host application for managing the patches or updates available for a given application.  Patches or updates would be published as "Manifests" describing the update contents, which would consist of "Manifest Items" of one of the aforementioned types.  The client agent would communicate with this host via web services.  The agent would poll the host for any Manifests appropriate to the application and current version it is associated with, then download the manifest contents, if desired - also via a web service.  The administration application would be role-based, allowing the System Administrator to control the privileges of users defining Manifests in the system.</SPAN></FONT></P></DIV>
<LI>
<DIV>
<P style="MARGIN-BOTTOM: 5px"><FONT size=2><SPAN style="FONT-FAMILY: Arial">The client would provide default UI elements, such as progress indicators and prompts before downloading or applying updates.  It would be possible to disable individual and/or all prompts, enabling "silent mode". The client would also support ability to override UI elements with customized versions, providing custom look-and-feel. </SPAN></FONT></P></DIV></LI></UL>
<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We also decided early on to design in some feature that would allow us to 'productize' our solution for sale to other developer's who want to build similar auto-update capabilities into their apps without investing all the time and effort we did.  These features included support for managing updates for multiple companies, tools for simplifying certain processes, installers for the client SDK and server web applications, extra effort in terms of the usability of the web-based hosting application, as well as two levels of administrative roles in that app.  A full list of the features in the final product, EverUpate, can be found<A href="http://www.practical-apps.com/practical-apps/products/everupdate/application-update-installer-patch-management-software-component.net-.aspx">here</A>.</SPAN></P>
<P> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 14pt"><B><SPAN style="FONT-FAMILY: Arial">Design Details</SPAN></B></SPAN></P>
<P><SPAN style="FONT-WEIGHT: 700; FONT-FAMILY: Arial">Host Application</SPAN></P>
<P><FONT size=2><SPAN style="FONT-FAMILY: Arial">We built the Host application using ASP.Net with a SQL Server database.  The database schema consists of primarily of Company, Application, Manifest, ManifestItem, and User tables. A Category table provides a folder-based organizational structure for Manifest Items.  An intersection table representing a many-to-many relationship between ManifestItem and Categories provides the ability to define a Manifest Item once, but have it appear in multiple places in the Manifest Item organizational folders. Another intersection table between ManifestItem and Manifest allows one item to be associated with multiple manifests. This is useful when some component is used in multiple different applications, for instance.</SPAN></FONT></P>
<TABLE id=table1 cellSpacing=0 cellPadding=5 width="51%" border=0>
<TBODY>
<TR>
<TD colSpan=2><B><FONT face=Arial size=2>Fig 1 - General Table Schema</FONT></B></TD>
<TD> </TD>
<TD> </TD></TR>
<TR>
<TD>
<TABLE id=table2 borderColor=#000000 cellSpacing=0 width=95 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>Application</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR></TBODY></TABLE></TD>
<TD>
<TABLE id=table3 borderColor=#000000 cellSpacing=0 width=95 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>Application</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR></TBODY></TABLE></TD>
<TD>
<TABLE id=table4 borderColor=#000000 cellSpacing=0 width=95 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>Category</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>ParentId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR></TBODY></TABLE></TD>
<TD>
<TABLE id=table5 borderColor=#000000 cellSpacing=0 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0><FONT face=Arial size=1>CategoryManifestItems</FONT></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CategorryId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>ManifestItemId</FONT></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE id=table6 borderColor=#000000 cellSpacing=0 width=74 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>Company</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR></TBODY></TABLE></TD>
<TD>
<TABLE id=table7 borderColor=#000000 cellSpacing=0 width=114 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>Manifest</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>AppId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Version</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>FinalVersion</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>RebootRequired</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>BackupFiles</FONT></TD></TR></TBODY></TABLE></TD>
<TD rowSpan=2>
<TABLE id=table8 borderColor=#000000 cellSpacing=0 width=118 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>ManifestItem</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Name</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Action</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Type</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Sequence</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Version</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>RegistryTarget</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>FileSize</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>FileName</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>TargetPath</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Args</FONT></TD></TR></TBODY></TABLE></TD>
<TD rowSpan=2> </TD></TR>
<TR>
<TD>
<TABLE id=table10 borderColor=#000000 cellSpacing=0 width=90 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>User</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>CompanyId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>UserId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>Role</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>FirstName</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>LastName</FONT></TD></TR></TBODY></TABLE></TD>
<TD>
<TABLE id=table11 borderColor=#000000 cellSpacing=0 width=164 border=1>
<TBODY>
<TR>
<TH bgColor=#c0c0c0>
<P align=left><FONT face=Arial size=1>ManifestItemManifest</FONT></P></TH></TR>
<TR>
<TD><FONT face=Arial size=1>Id</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>ManifestId</FONT></TD></TR>
<TR>
<TD><FONT face=Arial size=1>ManifestItemId</FONT></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<P><FONT size=2><SPAN style="FONT-FAMILY: Arial">Rather than developing a lot of custom code for querying these tables and for persisting data to them, we leveraged an opensource ORM (Object Relational Mapping) package called<A href="http://ojb-net.sourceforge.net/">OJB.NET</A>.  ORM's, like OJB.NET provide object-based access to relational databases, saving you from having to write a bunch of custom persistence code.  While OJB.NET seems to be very much a grass-roots effort and is not as mature as similar packages that exist in the Java world (Hibernate, for example), it met our purposes well.  I recommend you consider a package like this any time you're considering developing a database persistence layer.</SPAN></FONT></P>
<P><FONT size=2><SPAN style="FONT-FAMILY: Arial">The manifest management console was constructed almost entirely in ASP.NET with C# under the covers. As I mentioned earlier, since we anticipated marketing our final product to other developers, we put a fair amount</div>

<p align=center>Article source: <a href="http://www.ArticlePros.com/computers_and_internet/programming/article-32322.html">ArticlePros.com</a></p>