Deploy application without install SQL Server CE error

Question

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...

See my blog post here: erikej.blogspot.dk/2011/02/… - also, check the providername spelling/casing — ErikEJ
– ErikEJ, Commented Sep 24, 2013 at 16:14
Seams to be exactly the solution I'm looking for. Please make me an answer I will be glad to accept it. — Raúl Otaño
– Raúl Otaño, Commented Sep 24, 2013 at 16:21

ErikEJ · Accepted Answer · 2013-09-24 16:54:51Z

3

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

answered Sep 24, 2013 at 16:54

ErikEJ

42.1k5 gold badges82 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Raúl Otaño Over a year ago

I have a problem with this solution, maybe you can help me. This works when I run the code in some machines, and in others it doesn't. I uninstall the sqlserverce from the develop machine, and I when I run debuggin, in the console I can see it load the library from the running folder. But when I run the app in other machines (windows xp 32 bits, and windows 7 32 bits) it doesn't works. Also it works on a Virtual Machine wirth windows 7 that I created. What could it be? I will appreciate the helps. Thanks

ErikEJ Over a year ago

Are all the required files copied as Content? Do you have the correct files in the x86 and AMD64 folders. Does your project target AnyCPU? If yes, feel free to email me a repro project

Raúl Otaño Over a year ago

I have the target to x86. Could be this the problem?

Raúl Otaño Over a year ago

Yes, that works perfectly!! I found the problem. It was that the proyect originaly was for framework 4.5, and I converted it to 4.0. But seams still need some libraries from the framework 4.5, and don't load the data. But the local SSCE works fine on the framework 4.5. Thanks...

Collectives™ on Stack Overflow

Deploy application without install SQL Server CE error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related