Create an empty database project programmatically using C#

Question

I wanted to create an empty database project from Visual Studio 2017 programmatically. I tried creating a console application programmatically and was successful. Here is the code with which I tried creating a Console Application.

 Solution2 soln = (Solution2)dte.Solution;
 string dbTemplatePath;
 string dbPrjPath = "C:\\source";
 dbTemplatePath = soln.GetProjectItemTemplate("ConsoleApplication.zip", "CSharp");
 soln.AddFromTemplate(dbTemplatePath, dbPrjPath, "New db project", false);

When I replace ConsoleApplication.zip with dbApplication.zip, I could not come up with a database project.

Also, I noticed the template for ConsoleApplication found in the location Microsoft Visual Studio 14.0\Common7\IDE\ProjectTemplates\CSharp\Windows Root\Windows\1033\ConsoleApplication whereas there is no such template for database project.

Any help would be appreciated. Thanks in advance

but we need project template to create an empty DB project, is there any project template like sqldatabase — Akshara, Mar 26 '18 at 08:49

score 1 · Accepted Answer · answered Apr 18 '18 at 10:28

To create an empty database project programmatically, you must need the template of an empty database project.

If such a template is not found in the Visual Studio folder, you can create an empty database project from visual studio and export the project as a template from Projects -> Export Template...

EnvDTE.DTE dte = (EnvDTE.DTE)obj;
dte.Solution.Create(path, name);
var solution = dte.Solution;
solution.AddFromTemplate(templateLocation, name);
dte.ExecuteCommand("File.SaveAll");

Create an empty database project programmatically using C#

1 Answers1