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.