Workaround: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

If you get that nice error message change your solution configuration to target 32-bit (x86) using configuration manager.

For more information read this.