Connecting and Using SQL Compact Edition in a WPF application

Connecting and Using SQL Compact Edition in a WPF application

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

• 

  fleury_darts_05

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 31 October 2022, 8:13 pm EST

  Hi,

  This is product related forum and you are not asking related to our products. However, you can refer to this for your concern: https://social.msdn.microsoft.com/Forums/office/en-US/17848176-04bb-4758-b769-dc590b5ae769/connecting-and-using-sql-compact-edition-in-a-wpf-application

  Regards,
  
  Nitin