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=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
—————————
OK
—————————
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.
Strate SQL 