simplest ways to keep a local database

Question

I'm fairly new to c# and I was wondering what different options there are for keeping a database on the user's PC.

It's basically for saving favorites and being able to add a note on each favorite, and then i'd be able to show a list with all favorites and their note. But I honestly have no clue how to even do that, I've worked with mySQL but I can't do that here.

Thanks

Edit: The program is comparable to an internet browser but for a specific website, so it won't be that big of a database

Answer 1

SQLite is a simple and common way to bundle a local relational database with an application. It has ADO.NET (C# database bindings) at System.Data.SQLite.

However, if you're just storing a simple set of tuples, wouldn't a comma-separated list saved as a regular text file on disk work just fine?

Answer 2

In .NET, the path least annoying will likely be SQL Server Compact or VistaDB