Deploy SQL Server CE with my Windows Mobile Application

Question

I wrote a Windows Mobile Standard / Smartphone application (my first) that uses the SQL Server Compact Edition database as a backend. I had no problems testing in the emulator in Visual Studio as it installed SQL Server CE for the emulator for me. However, when I created the deployment project, the resulting CAB file was installed on my phone in order, but it did not start because it could not find the SQL Server CE library.

Should SQL Server CE be installed as a standalone CAB, such as .NET CF 3.5? If so, where can I get it (I did not find anything like this on the MS website)? Or can I just include the the System.Data.SqlServerCe.dllfile in my deployment?

Edit:

I added the aforementioned DLL to the deployment and it works, so that answers my original question. But I have ideas for more applications, most of which will also use SQL Server CE. Instead of including a copy of the DLL with each installation, I would rather have a single source for the SQL Server CE library. I think I could create my own installation folder for the DLL only, but I suppose there may be a more “official” way to do this. So, I will return to my first question: is there a CAB for SQL Server CE? I do not want to install files if the user already has them, and, of course, do not install duplicates if I do not need it.

Answer 1

I think my fingers move faster than my brain. Here is the mobile version for Sql Server Compact installed: Microsoft SQL Server Compact 3.5 for Windows Mobile

Edit:

I wanted to add additional information for everyone who comes across this and is looking for the same information as me.

Firstly, there are two ways to find SqlCe with a mobile application: either use the CAB installation, or enable the seven SqlCe DLLs with your application. Personally, I chose the first, so that SqlCe can be used by other applications. All files (both CAB and DLL) for my device were located in C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i*, but again I have an ARM processor and I don’t know anything about others.

- DLL, . , DLL .

, , . , , CAB (, .NET CF 3.5), . Multicab, , CAB , . ++ ( #), WinMo 6 SDK, uber-CAB. C:\Program Files\Windows Mobile 6 SDK\Samples\Common\CPP\Win32\multicabinstall *.

, -.

* , .

Answer 2

?

Mobile Packager , .

. , , .

. http://www.mobilepackager.com