Deploying SQL CE for the Compact Framework


Question: I am developing a Pocket PC application and want to use SQL Server CE for the storage of the data. I have SQL Server installed on my development environment and it works fine. How can I get it running on the Pocket PC?

Answer: By default when you set up the development environment of Visual Studio 2003 the files are already placed on your machine. The easiest way is to simply set a reference to the System.Data.SqlServerCE namespace.

This will deploy SQL Server CE to the emulator. If you want to further validate that SQL CE is installed open the Programs menu, which now contains the SQLCE query program as shown below.

Comments (5)

  1. G. Man says:

    OK but how do I deploy it along with my application to the end user machine?

  2. It gets deployed as part of the installation package you build for the project.

    I have an article on using SQL CE together with Merge Replication on VSM at: http://www.fawcette.com/vsm/2003_10/magazine/features/thews/

  3. online poker says:

    Please check some relevant pages about online poker http://online-poker.cheat-elite.com/

    phentermine http://phentermine.ps2cool.com/

    viagra http://viagra.cheat-elite.com/

    credit cards http://credit-cards.cheat-elite.com/

    flowers http://flowers.cheat-elite.com/

    casino http://casino.ps2cool.com/

    poker http://poker.cheat-elite.com/

    online casino http://online-casino.ps2cool.com/

    texas holdem http://texas-holdem.ps2cool.com/

    texas hold em http://texas-hold-em.cheat-elite.com/

    texas holdem poker http://texas-holdem-poker.ps2cool.com/

    pacific poker http://pacific-poker.cheat-elite.com/

    party poker http://party-poker.ps2cool.com/

    empire poker http://empire-poker.cheat-elite.com/

    poker games http://poker-games.ps2cool.com/

    generic viagra http://generic-viagra.cheat-elite.com/

    cialis http://cialis.ps2cool.com/

    levitra http://levitra.cheat-elite.com/

    tramadol http://tramadol.ps2cool.com/

    online pharmacy http://online-pharmacy.cheat-elite.com/

    soma http://soma.ps2cool.com/

    diet pills http://diet-pills.cheat-elite.com/

    phendimetrazine http://phendimetrazine.ps2cool.com/

    credit card http://credit-card.ps2cool.com/

    payday loans http://payday-loans.cheat-elite.com/

    loans http://loans.ps2cool.com/

    personal loans http://personal-loans.cheat-elite.com/

    student loans http://student-loans.ps2cool.com/

    private mortgages http://www.cheat-elite.com/

    low interest credit cards http://low-interest-credit-cards.ps2cool.com/

    online casinos http://online-casinos.cheat-elite.com/

    casinos http://casinos.ps2cool.com/

    flower shop http://www.ps2cool.com/

    online loan http://online-loan.cheat-elite.com/

    mortgage refinance http://mortgage-refinance.ps2cool.com/