[Roam-commit] SF.net SVN: roam:[138] Trunk/Source

[<jon...@us...>]

Revision: 138
          http://roam.svn.sourceforge.net/roam/?rev=138&view=rev
Author:   jonfroehlich
Date:     2009-06-02 01:37:07 +0000 (Tue, 02 Jun 2009)

Log Message:
-----------
added auto-upgrade to SQL CE 3.5 database in SqlCeConnectionManager

Modified Paths:
--------------
    Trunk/Source/Roam.SqlCe/SqlCeConnectionManager.cs

Added Paths:
-----------
    Trunk/Source/Roam.Common/Roam.Common.csproj.user
    Trunk/Source/Roam.SqlCe/Roam.SqlCe.csproj.user

Added: Trunk/Source/Roam.Common/Roam.Common.csproj.user
===================================================================
--- Trunk/Source/Roam.Common/Roam.Common.csproj.user	                        (rev 0)
+++ Trunk/Source/Roam.Common/Roam.Common.csproj.user	2009-06-02 01:37:07 UTC (rev 138)
@@ -0,0 +1,5 @@
+<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <PropertyGroup>
+    <DeployDeviceID>BEDE20EF-6548-413E-943F-1E87FEC249FA</DeployDeviceID>
+  </PropertyGroup>
+</Project>
\ No newline at end of file

Added: Trunk/Source/Roam.SqlCe/Roam.SqlCe.csproj.user
===================================================================
--- Trunk/Source/Roam.SqlCe/Roam.SqlCe.csproj.user	                        (rev 0)
+++ Trunk/Source/Roam.SqlCe/Roam.SqlCe.csproj.user	2009-06-02 01:37:07 UTC (rev 138)
@@ -0,0 +1,5 @@
+<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <PropertyGroup>
+    <DeployDeviceID>BEDE20EF-6548-413E-943F-1E87FEC249FA</DeployDeviceID>
+  </PropertyGroup>
+</Project>
\ No newline at end of file

Modified: Trunk/Source/Roam.SqlCe/SqlCeConnectionManager.cs
===================================================================
--- Trunk/Source/Roam.SqlCe/SqlCeConnectionManager.cs	2009-04-29 12:37:17 UTC (rev 137)
+++ Trunk/Source/Roam.SqlCe/SqlCeConnectionManager.cs	2009-06-02 01:37:07 UTC (rev 138)
@@ -422,7 +422,17 @@
                     if (sqlConn.State == System.Data.ConnectionState.Closed)
                     {
                         _log.DebugFormat("Open : The connection={0} is closed, opening now", sqlConn);
-                        sqlConn.Open();
+                        try
+                        {
+                            sqlConn.Open();
+                        }
+                        catch (SqlCeInvalidDatabaseFormatException sqlException)
+                        {
+                            SqlCeEngine sqlCeEngine = new SqlCeEngine(_connectionString);
+                            sqlCeEngine.Upgrade();
+                            sqlCeEngine.Dispose();
+                            sqlConn.Open();
+                        }
                     }
 
                     //most efficient to check for this flag before logging


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.