WPF and local databases

Hi,
I'm looking at building a windows app using WPF and it needs to have a local database.

I initially thought i'd use SQL Server compact 4 (or 3.5) but i cant seem to get this to work (it seems 4 only works with web apps....is 3.5 the same?)

Has anyone else built an application of this type?

What would be the best type of database to use?

thanks

You could use sql express, free and fast.

SQLite

Thanks for the replies.
I initially didnt want to use SQL Express as i didnt want to have to sort out bundling the installation and setup with my application deployment, but have decided that this will probably be the best solution so I will have to learn how to install and set up SQL express from my setup.

SQLite.....hmmmmmm, hadnt thought of that......might have to have a look. :)

thanks again.

Most, if not all, descent databases require to be installed.