title: ADO.Net Synchronization & SQL CE
body: <p>I've succesfully synchronized both source and local db using the local database cache item in VS 2008. </p>
  
  <p>However, I need to access the SQL CE db directly from within another dll/process, and without using a dataset. The reason being that my business object code does not use datasets. </p>
  
  <p>The final code wouldlook something like this:</p>
  
  <pre><code>Dim conn As New SqlServerCe.SqlCeConnection("Data Source=C:\Development\UserDirectory\UserDirectory.DBSyncher\ProfDir.sdf;Persist Security Info=False;")
  Dim cmd As New SqlServerCe.SqlCeCommand("Select EmailAddress from Employees Where ID=23", conn)
  Dim returnString As String = ""
  
  If conn.State = ConnectionState.Closed Then
      conn.Open()
  End If
  returnString = cmd.ExecuteScalar
  
  conn.Close()
  cmd = Nothing
  </code></pre>
  
  <p>I notice something very strange using a dataset the synchronized changes are shown but accessing the CE database file directly returns old data - no synched data whatsoever.</p>
  
  <p>What am I missing? Any help would be greatly appreciated.</p>