Blog‎ > ‎

SQL Server CE 4.0 + Visual Studio 2010

Recently, I needed the SqlCeConnection.GetSchema() method for retrieving the schema of an embedded SQL CE database. Apparently the GetSchema method is not implemented in SQL Server CE 3.5 and throws an exception when called. The method is implemented in SQL Server CE 4.0, but there were no official MS articles on how to install it or where to get the installer for integrating the Tools into VS. Through trial and error, I found the way.

Here's how:
  1. Install Visual Studio 2010 SP1 FROM THE DVD ISO here.
  2. Install SQL Server CE 4.0 Runtime from here.
  3. Install SQL Server CE 4.0 Tools for Visual Studio SP1 here.