.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Integrate/Install SQLServer Compact (SQLCE) with a ZIP file

Posted By:Manas Patnaik       Posted Date: February 26, 2011    Points: 100    Category: DataBase    URL: http://www.dotnetspark.com  

Integrating SQLCE to project with out any installation

As we know SqlCE database is a collection of dlls and can be distributed along with your applications with out any additional  installation.Now integrating sqlserver Compact  was never easy before Nuget ( formerly NuPack ) .It is open source ,completely free and comes as a VS add in.This post we will have a look into NuGet features and will integrate SQLCE to our project with out any installation.

  • Download and install Nuget from codeplex.
  • Once installed click on "Add Package Reference" from reference.
  • manaspatnaik Blog

  • This will show you Nuget window with all package references as shown bellow.

manaspatnaik Blog

  • Search for SQLCE and click on install.

manaspatnaik Blog

  • Once installed you will find changes to the existing project.The SqlCE references will be added to the project .You can find the package at local project folder.

manaspatnaik Blog

The  folder contains the .zip file manaspatnaik Blog with SQLCE Binaries and files .The tools folder contains scripts to add a post build job to your project, that copies the files in the Native Binaries folder to the bin folder.Check with Erik Ejlskov Jensen's this blog post for more details .

So Nuget helps to eradicate the manual process involving installation and referring to the dlls by privately installing the components.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend