Good alternative to a database in a C# program
c#, database, sql, xml
Solution
If your application is really simple, you can use sqlite-net as a simple object-relation mapping layer to manage your objects/tables,
https://github.com/praeclarum/sqlite-net
And then connect to C#-SQLite,
http://code.google.com/p/csharp-sqlite/
Using them, your application can be "portable" (no installation to Windows system). Just copy the binary to a machine with .NET installed, it will work.
Problem
I have to make a small program for my job, my position is really not IT related, and I'm making this for our personal-professional use. I've already made it in Access, and it's working okay, but I personally don't like it. It's really simple, there is a list of different places (about 300) containing about 10 columns. This is in a DataGridView, and when we select some place, we can print the report of visits to that place. Problem: I want to do it in C#, so I thought about using a simple Access database but I get an "OLEDB database driver is not in the system" or something like that. We work on a restricted WIZE client, and nothing can be changed in the Windows configuration. So I was looking for an alternative for my database. Can I use a simple XML file and store it there, or is there is any simpler alternative that can allow my to make SQL-like requests and insert/delete/update in the database? Sorry for my English, it is not my primary language :) Edit: Thank you all for this help, it's greatly appreciated. I'll look into SQLite.