I've created a database on .\SQLEXPRESS in SSMS.

How do I connect to the database in Visual Studio 2010? I know this is potentially a big question but my main concern is with how I'd construct the connection string. I'd right click in solution explorer and add the database file myself but I can't seem to find where the file is!?

Also, this project is to give to someone else upon completion; if I were to connect to this database how would I deploy it so that the recipient could also run it locally?

Thanks.