deployment of sqlserverce.dll

I registered to redistribute the runtime for SQL Server Compact edition.

I have a desktop application which uses SDF files as the database.

In VS 2008 - when I set System.Data.SqlServerCe configured to Copy Local as TRUE - sqlserverce.dll does not get inserted to my bin directory. I am assuming if I manually put the DLL file into my bin directory (and deploy it) - the DLL file will automatically be used by my app?

If you install the 3.5 redistributable/runtime with your app, you do not need any SQL Compact DLLs in your bin folder.

http://www.microsoft.com/downloads/details.aspx?FamilyID=4dd09a86-03eb-40a1-bd32-0fd8bcdf7be0&displaylang=en

|||

This defeats the purpose of packaging up the database with your deployment package. I am not the original poster of this thread but I will need a solution that does not need/want to install the Compact Edition Runtime installation with my application deployment. The installation of the runtime package requires the user to have admin rights and most of my end users will not have admin rights.

Therefore, please provide us with the steps to include the Sql Server CE provider assemblies with our application deployment package.

Thank you.

|||Maybe tutorial 1 here will be able to assist you: http://msdn2.microsoft.com/en-us/sql/bb219480.aspxsql

deploying sql ce with desktop application

i have an application that uses sqlce.. now i want to install sqlce with my installer instead of seperate installer... could you please guide me how can i do this? i have created installer for my application but how to integrate sqlce with it...You can simply include the SQL CE dlls with your app, see this for a walkthrough of the options: http://msdn2.microsoft.com/en-us/library/bb219481.aspx