SQL Database In App_Data Folder

I'd be interested to know what the recommended methods are of implementing a SQL database using VS2005 standard and SQLExpress.

I previously used VS2003 and MSDE which allowed me to create a .sql script to create and populate a database.

Correct me if I'm wrong, but it now appears that in VS2005 the preferred way of doing this is to create a SQLExpress database in the App_Data folder. This is fine, except that I can't seem to connect to this 'detached' database using SQLCMD when I need to run my .sql scripts to create the tables.

When I used MSDE, I used a command similar to the following:

osql -E -S(local)
etsdk -dMyDatabase

Which connected to the 'MyDatabase' database. Now, with VS2005, if I create MyDatabase.mdf in the App_Data folder how would I connect to it using SQLCMD? I've tried:

sqlcmd -E -S(local)SQLEXPRESS -dMyDatabase.mdf

but this just tries to open a database in the SSQL.1MSSQLData folder.

I guess I'd like to store the database in the App_Data folder as it keeps everything together and will be easier when deploying a site to a remote host.

Thanks,
Wayne.