Service-based database Missing In Visual Studio

Question

_{Monday, October 5, 2015 11:01 AM}

In VS2015 enterprise version I tried to build a windows form application with a localdb by adding a service-based database to my project.

This worked in VS2013 but somehow the file template for such a database is missing in my installation. How do I correct this ?

Modifying the installation of VS2015 doesn't give me such an option. (and neither does repair)

All replies (3)

_{Saturday, March 9, 2019 1:07 AM ✅Answered}

For VS 2017/2019 it seems that one has to add a winforms app/library project to the solution. Once that is added, I used the library, it allows one to add a Service-Based Database.

It is detailed here on MSDN Create a database and add tables in Visual Studio

Note in the preqs, one has to go through the installer:

"To complete this walkthrough, you must have the optional Data storage and processing workload installed in Visual Studio. To install it, open Visual Studio Installer and choose the Workloads tab. Under Web & Cloud, choose Data storage and processing. Choose the Modify button to add the workload to Visual Studio."

William Wegerson (www.OmegaCoder.Com)

_{Tuesday, October 6, 2015 1:49 AM | 1 vote}

Hi Andre van Dun,

Thank you for posting in MSDN forum.

I tested this issue on my visual studio 2015, when I go to the add a new item template, I could find this Service-based Database item, so please go to Control Panel -> Uninstall a Program, select visual studio 2015, right click, Change -> Modify, and check whether you have installed "Microsoft SQL Server Data Tools", if you didn't install it, please check it and follow the steps to install it.

If you have installed it, to make sure whether it is related to your corrupted templates, please take the following steps to reset your templates:

1) Open Windows Explorer, and navigate to <Visual Studio Installation Path>\Common7\IDE (by default is C:\Program Files or Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE);
2) Delete the ItemTemplatesCache, ProjectTemplatesCache folder;
3) Open Visual Studio Command Prompt under Start menu -> All Programs -> Microsoft Visual Studio -> Visual Studio Tools (run it with administrative privilege);
4) Run the devenv /InstallVSTemplates switch;
5) Run the devenv /Setup switch;

Hope this information is helpful.

Best Regards,

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

_{Tuesday, June 20, 2017 1:42 PM}

I performed this operation to resolve the missing template issue and it hasn't worked. Is there a manual way to add this?

Kind Regards,

Alex