I’m sitting around tonight trying to reverse engineer a database with Database Professional 2008 and I get this unexpected error. (they’re all unexpected, aren’t they)
Microsoft Visual Studio
Could not load file or assembly ‘System.Data.SqlServerCe, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
But since I didn’t read the instructions I didn’t know what the problem was. Fortunately I found the answer; which also mentioned reading Gert’s blog.
Long story short I had to install Microsoft SQL Server Compact 3.5 Service Pack 1 and Synchronization Services for ADO.NET version 1.0 Service Pack 1 for Windows Desktop.