Database for C# application

I'm working on a WinForms application which also has some WPF elements. Until now I used to store data in xml files but I'd like to try and use a database. What I want to store is objects of a couple of classes I have. How should I create the database and what database should it be? I want it to be transparent to the user.开发者_开发问答

For a couple of objects, if you don't have too much data, I recommend SQL Server Compact

Top features:

• Free to use and distribute
• Supports desktops and mobile devices
• Small footprint for easy deployment
• Fully embeddable architecture
• No administration required
• Single file, code-free database format
• Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options
• Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems
• Supports a rich subset of Transact-SQL syntax and SQL Server data types
• Microsoft Visual Studio 2008 integration
• Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework
• Supports multiple concurrent local connections

You can also use SQLite for ADO.NET.

Firebird have very good dot net driver and an embedded version is available