How can I disable auto deployment of SQL Server Compact when debugging CF.NET app?

Question

I have a problem where whenever I debug (F5) the Compact Framework app we're developing and VS starts deploying the projects it will always also deploy the SQL Compact 3.5 libraries.

The problem is very similar to Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging except for the fact that it's not happening on a Windows CE device, but rather the WM 6 emulator.

I've tried upping the Target Platform to WM 6.0 Professional and installing the required SQL Compact libraries manually but it made no difference.

What's interesting is that the issue in my case doesn't occur on any real devices, only on the emulator.

Update: It seems that the problem isn't emulator, but rather WM version specific. I'm getting the same issue on a WM 6 device. It doesn't occur on WM 5.

score 2 · Accepted Answer · answered Jun 29 '11 at 15:16

2

Have you seen this: http://silverfinn.net/blog/?p=91

answered Jun 29 '11 at 15:16

ErikEJ

40,951
5
75
115

Nope. I haven't seen it. I'll check it out and let you know how it went. Thanks. – Michał Drozdowicz Jun 30 '11 at 09:14
I've checked the references - they all point to the same version, but the problem still occurs. – Michał Drozdowicz Jul 07 '11 at 08:18
3

Turns out all projects were pointing to the same dll but it was the wrong version - 3.5.0. I changed them to point to 3.5.1 instead and it stopped redeploying. Thanks so much for saving my time :) – Michał Drozdowicz Jul 07 '11 at 10:29
The link is down, so it is not the solution for this question anymore. – Christoph Meißner Mar 17 '15 at 08:20

score 1 · Answer 2 · answered Jun 29 '11 at 17:46

1

I have seen this issue before when the version I had for SQL Server Compact installed in the OS image of my device/emulator did not match the version I had with Visual Studio. There are several Service Packs available for SQL Server Compact, I would recommend installing the same in both sides, and making sure you are referencing the same version in all your assemblies.

answered Jun 29 '11 at 17:46

yms

10,361
3
38
68

I've actually tried installing on the emulator the same .cab files VS is deploying. Didn't work. – Michał Drozdowicz Jun 30 '11 at 09:12
1

It's important to have all projects referencing the same - new version of sqlserverce.dll – Michał Drozdowicz Jul 07 '11 at 10:31

score 0 · Answer 3 · answered Mar 17 '15 at 08:44

As Michal Drozdowicz pointed out in his comments, the solution is to check the references of the SQLServerCe Component in all projects. They all must point to one and the same version, which should correspond to the latest installed version on the computer you are debugging from. So fixing is should be as easy as replacing all references to the assembly by a reference to

%YourProgramFilesDir%\Microsoft SQL Server Compact Edition\v3.5\Devices\System.Data.SqlServerCe.dll

(The place where you've installed SQLServerCe.)

If this is fixed, you may also need to install the previously automatically deployed cab files once manually.

How can I disable auto deployment of SQL Server Compact when debugging CF.NET app?

3 Answers3