CODEWITHSUNDEEP
c#.netwpfsql-server-ce
Raúl Otaño
Raúl Otaño

Reputation: 4770

Deploy application without install SQL Server CE error

I'm trying to deploy a desktop application (wpf) that uses an external .dll that defines the logical model. In this external library the model is defined using EntityFramework. In the wpf application I use SQL Server CE as database using this app.config info:

<connectionStrings>
   <add name="SomeManager" 
        connectionString="Data Source=Database/SomeDatabase-20130220200325.sdf" 
        providerName="System.Data.SqlServerCE.4.0"/>
</connectionStrings>

I want that the final client doesn't need to install SQL Server CE in his machine, so I want include the libraries CE libraries into my finall folder. I know it is possible due in the MSDN they give a solution for it. Copying the seven files of SQL Server CE 4 on the finall folder, and also the System.Data.SqlServerCE.dll file. I do this, but for some reason the application still is trying to get the libraries from the system, and not from the local application folder, so when I run the app in a machine without the SQL Server CE 4 installed, it doesn't runs.

What could fix this problem, I will appreciate any ideas. Thanks...

Upvotes: 1

Views: 3270

Answers (1)

ErikEJ
ErikEJ

Reputation: 41819

You can include the SQL Server Compact binaries with your application, and simply xcopy deploy them, for detailed inctructions see my blogpost here: http://erikej.blogspot.dk/2011/02/using-sql-server-compact-40-with.html

Upvotes: 3

Related Questions