Creating SQL CE4 databases
I've downloaded the RTM version of SQL CE (Compact Edition) and installed it. I've installed the SQL Server Compact Toolbox. I understand that SQL CE4 support within Visual Studio won't h开发者_如何学运维appen until SP1 drops.
The problem is, while I have tools to edit the CE Database, I can't find a way to actually create a SQL CE4 database. I figure I must be missing something obvious, but 20 minutes of searching hasn't turned up anything. How do I create a SQL CE4 database?
Thanks, Erick
Edit: I would rather avoid installing and running WebMatrix.
The SQL Server Compact Toolbox also allows you to create a database file (via the Add Connection dialog)
There's probably a better solution, but you could try out WebMatrix. With it I created an Orchard site, but after creating the site you can create new databases by clicking the 'New Database' button. Really easy. Don't think this is the best option though...
精彩评论