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