i'm toying around with doing a text-based game in a GUI format using C#. I'd like to use data tables from a server.
I used SQLite with C in the past. It was okay. Since SQLite is meant to be read locally, I was able to download the database from the server and read it locally. As you can imagine, that can be a security issue when there's quite a few players downloading the latest database to the local machine. It was nice for my purpose before.
I'm wanting an easy way to keep the data tables on the server, and that I can read/write to it. I'm using Visual C# 2010 Professional (VS 2013 Express also available).
To start with, I just basically want a database file on my website, have a few tables with a few columns, access it with a password, and read/write using queries. What are some good options?