- Ms sql server compact 3.5 sp2 install#
- Ms sql server compact 3.5 sp2 update#
- Ms sql server compact 3.5 sp2 software#
- Ms sql server compact 3.5 sp2 code#
If you’re not handling this in your code, it looks like the user has lost his data. In other news about SQLCE databases (or any database, for that matter), if you are deploying one with ClickOnce deployment as data, did you know if you open the database it changes the timestamp, and deploys a new version next time you deploy an update? On the client side, it then copies the previous version to the ApplicationData\pre folder, and puts the new one to the ApplicationData folder. On the reference to the in your project, set “Copy Local” to “true”. Set the Build Action to “Content”, and “Copy to Output Directory” to “copy always” on these entries in Solution Explorer. If you are using 3.0, substitute “30” for “35” in the names of these dll’s. You should be able to find them in C:\Program Files\Microsoft SQL Server Compact Edition\v3.5 (or v3.0). In the interest of copy and paste and making your life easier, here are the 7 dll’s you need to locate and add to your project.
Ms sql server compact 3.5 sp2 update#
At least one of them will be out of town, and when they come back, they’ll have too much e-mail to deal with and won’t take the time to follow your instructions to update their application.Ī better idea is to deploy the assemblies required locally. He must also have administrative privileges.Īdditionally, version control is more difficult with ClickOnce deployment, because prerequisites are not handled by the incremental updates, and you can never get all of your customers to reinstall a prerequisite.
Ms sql server compact 3.5 sp2 install#
You can deploy it as a prerequisite, but this requires the customer to install one more thing without clicking Cancel.
Ms sql server compact 3.5 sp2 software#
If you are using a SQLServer Compact Edition database, you will need to deploy the software for it.
Information from the product team about product release versions is available here: SQL Server Compact Release Versions and here: Description of the various build versions of SQL Server Compact Edition The sample in this blog entry gives you the file version, there are only difference in this per major version (2.0, 3.1/3.0, 3.5 and 4.0) String fileVersion = info.FileVersion File format/version of database file Var info = (System.IO.Path.Combine(pathName, "sqlceme35.dll")) String pathName = (string)registryKey.GetValue("InstallDir") registryKey = SQL Server Compact Edition\v3.5", false) This can be done like so for 3.5 and 4.0 (if installed by an administrator on the machine): Getting information about these files is more challenging, as we need to locate the unmanaged DLL files.
Ms sql server compact 3.5 sp2 code#
0 (for patches the final zero will be from 1 to 14) File version of the unmanaged DLLsĪs you may know, the SQL Server Compact engine consists both of managed DLL files (the that has been referenced in all code above), and a number of C++ unmanaged DLL files. String asmFileVersion = asmInfo.FileVersion įor 3.1, this returns. Getting the file system version of the managed ADO.NET provider will give you more precise version information (in particular for 3.0/3.1), and will not require guessing the location of any DLL files (as below for getting the version for unmanaged files). Var ver = new ().ServerVersion įor 3.5/4.0 this will give you the build version of the database engine, including any patches. The ServerVersion property of the SqlCeConnection object. 0 for devices (not exactly what you would expect)įor 3.5 SP1 and SP2 this is 3.5.1.0 “ServerVersion” This will give you the assembly version of the, not the build number.įor 3.1, this is 9.0.242.0 for the desktop and. Var version = typeof().Assembly.GetName().Version NET specific, part of the assembly’s identity. This is not part of the file information, but. This blog post is an attempt to cover them all, let me know if something is missing.
There are various aspects to getting the version information for SQL Server Compact.