Connecting and Using SQL Compact Edition in a WPF application

Posted by: fleury_darts_05 on 31 October 2022, 4:46 pm EST

    • Post Options:
    • Link

    Posted 31 October 2022, 4:46 pm EST

    I am just keeping up with WPF and C#. I have written a complete desktop application and it was Ok. I am now working on a database driven application (The database is a temporary storage, the application will sync with a live server). I have chosen MsSql Compact Edition as my application database but I seem not to find any tutorial that breaks down connecting, accessing and administering the database in a WPF program. I have a good background knowledge of database, RDBMS and ORM from the likes of PHP and MySql. Moving to Desktop/MS applications, I have the following questions.

    Creating the database (I can try this with VS 2012 but hints are welcome)

    Adding (bundling) it to the application.

    Performing a CRUD on it (A simple class or example)

    Possibility of using one database in two projects of the same solution

    Other things I should know, not leaving out available ORM (if they are available) and their respective documentations.

    I will be glad if answers are related using a Database engine like MySql with PHP. I just need a breakdown.

    Replies will be much appreciated.

    Thanks in advance.

  • Posted 31 October 2022, 8:13 pm EST


    This is product related forum and you are not asking related to our products. However, you can refer to this for your concern:



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels