My expertise is in PHP and MySQL. However i am working through making a C# Program. This program is going to be run on a computer and i want to store the data locally. Since im used to MySQL and i like the advantages of databases over a flat file/xml file but I am unsure of if its possible.
I know that SQL Server Express from Microsoft is a free SQL server that is designed to run on a local machine and not as a large SQL server. What i am not sure of is if i can package SQL Server Express into an Application Installer and have it streamlined into the Install of my software, and if it is ok to do so legally. I would prefer to not have to tell people to Download it and set it up on their own as that is potetionally error prone and would instead prefer to streamline it into my Installer.
If i cannot do this, is Flat file/XML file my only other option?