title: Connecting and Using SQL Compact Edition in a WPF application
body: <p>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.</p>
  
  <ol>
  <li>Creating the database (I can try this with VS 2012 but hints are welcome)</li>
  <li>Adding (bundling) it to the application.</li>
  <li>Performing a CRUD on it (A simple class or example)</li>
  <li>Possibility of using one database in two projects of the same solution</li>
  <li>Other things I should know, not leaving out available ORM (if they are available) and their respective documentations.</li>
  </ol>
  
  <p>I will be glad if answers are related using a Database engine like MySql with PHP. I just need a breakdown.</p>
  
  <p>Replies will be much appreciated.</p>
  
  <p>Thanks in advance.</p>