AttachDBFileName
I never knew you could do the following with SQL Server connection strings! This should make unit testing DB code a whole lot easier...
AttachDBFileName=c:\MyFolder\MyDB.mdf
See connectionstrings.com or MSDN for more. Taken from the comments here.