stand-alone single user db

[Jape]

When I go to add a new data source in C# Express i can only choose mdb or mdf, not sdf, the SQLCE format, - are you able to choose it in your VB.Net Express version?

I've never actually created it in Express, only edited the tables, but if i can edit the tables i should also be able to add a new SQLCE DB i assume. What i do know is that you first need to switch the data source when you're in the add connection dialog. Instead of 'SQL Server (SqlClient)' you need to pick the 'SQL Server Compact Edition' first before being able to add .sdf to your project.