Hello I'm trying create local database with Visual Studio 2015, but in items list I have no any Local Database, there is only Dataset and Service-based Database and with Search Templates also nothing. Can you help me figure out, what I have to do, where and how to get it to use?
Asked
Active
Viewed 5,737 times
0
-
1Did you do a custom install? Are you sure that you installed "Microsoft SQL Server Data Tools" with your install? You may have to re-run the setup of Visual studio, select modify, and check that option. – Claies Aug 24 '16 at 21:43
-
@Claire but can I download it and just install ? https://msdn.microsoft.com/library/mt204009.aspx – Aug 24 '16 at 21:56
-
To quickly see if you are missing the installation you can check in View to see if you can open the SQL Server Object Explorer window (default shortcut is ctrl + /, ctrl + s) – Kolichikov Aug 24 '16 at 22:00
-
@Kolichikov yes I see it SQL Server Object Explorer, seems it is already there... – Aug 24 '16 at 22:02
-
See my answer below. See the answer [here](http://stackoverflow.com/questions/18598506/is-microsoft-dropping-support-for-sdf-database-files-in-visual-studio) for why the Local Database option is no longer available. Looks like Microsoft is dropping support for sdf databases (the Local Database option pre VS2013). – Kolichikov Aug 24 '16 at 22:03
1 Answers
3
It looks like in Visual Studio 2015, the way to add a local database is to select the Service Database option, and to set up a data source pointing to the resulting database file.
MSDN has a tutorial for this here. They also note here that not all projects support opening the data sources window. If you need to setup a local database with something like ASP.NET MVC, you can refer to this tutorial on setting up a localdb database.
Kolichikov
- 2,944
- 31
- 46