If you are using LocalDB and want to create an empty database you should perform the following steps.
- Go to Visual Studio
Server Explorer
|Data Connections
- Select
Add Connection
from the context menu - Change
Data Source
toMicrosoft SQL Server Database File
(i.e. LocalDB) - Set the
Database file name
by entering a database name and path that corresponds to the name in theweb.config
/app.config
connectionstring.
Replace|DataDirectory|
with path to the place the database file should be created at (i.e.App_Data
) - Select
Advanced
and set the properties according to the following example connection stringData Source=(localdb)\v11.0; Initial Catalog=Arbitrary; Integrated Security=True; MultipleActiveResultSets=True; AttachDbFilename=C:\PATH\TO\Arbitrary.mdf
Thanks for this update it was really helpful to me