Marc Rufer 19 Jan 2017 SQL VisualStudio
If you are using LocalDB and want to create an empty database you should perform the following steps.
Server Explorer
> Data Connections
Add Connection
from the context menuData Source
to Microsoft SQL Server Database File
(i.e. LocalDB)Database file name
by entering a database name and path that corresponds to the name in the web.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 string
Data Source=(localdb)\v11.0; Initial Catalog=Arbitrary; Integrated Security=True; MultipleActiveResultSets=True; AttachDbFilename=C:\PATH\TO\Arbitrary.mdf