Building an application that includes a DB, and need recommendations

Question

I'm going to build a little system for personal use, and I want it to save data to a database.
The language is going to be C#, and so I'd like to use this opportunity to get my head around LINQ to SQL.
I have some DB experience and I know my SQL, but it was all in school using Access, which is giving me trouble, and so I'd like to use another DB, something that is small in size, easy to install, and should work with LINQ to SQL.
The problem is: I don't know any except Access, and am looking for recommendations.

To sum it up: I need a lightweight, easy to install, linq-to-sql supporting database for a small system on a home computer, any recommendations?

Answer 1

If you're willing to use a LINQ provider, you can use SQLLite and many other databases, but the only supported 'out of the box' choice is SQL Server Express (and other SQL Server variants).

Answer 2

Try Microsoft SQL Server Express - its free and allows up to 4Gb data

Answer 3

I like MySQL even with C#