roam-commit Mailing List for Roam, a Windows Mobile library

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.




2007	Jan	Feb	Mar (9)	Apr (10)	May	Jun	Jul (10)	Aug (1)	Sep (7)	Oct (4)	Nov (6)	Dec (3)
2008	Jan (1)	Feb (9)	Mar (11)	Apr	May	Jun	Jul	Aug (2)	Sep (1)	Oct	Nov	Dec
2009	Jan	Feb	Mar (1)	Apr (2)	May	Jun (1)	Jul	Aug	Sep	Oct	Nov	Dec

roam-commit Mailing List for Roam, a Windows Mobile library

roam-commit — Sends out messages for each SVN commit