Skip to content

Template pack

Compare
Choose a tag to compare
@jmezach jmezach released this 31 Aug 19:17

Starting with 1.4.0 we are now also shipping a set of templates that can be used with dotnet new. These ship as a separate NuGet package that can be installed using dotnet new --install MSBuild.Sdk.SqlProj.Templates. After that you can create new projects using dotnet new sqlproj. We've also included item templates for some of the most common SQL object types such as Tables, Views, Stored Procedures and Functions. If you feel a particular object type is missing please don't hesitate to file an issue or submit a PR. Eventually these templates will also start showing up in Visual Studio. This feature is currently in preview and we've already identified an issue that the Visual Studio team will be looking into.

Note that the version of the templates is updated in lock-step with the main package itself, meaning that when a new version of MSBuild.Sdk.SqlProj ships a new version of MSBuild.Sdk.SqlProj.Templates is also shipping and the template will reference the new version of MSBuild.Sdk.SqlProj. You can update your installed version of the templates using dotnet new --update-apply. Although we've also shipped a new version of MSBuild.Sdk.SqlProj with this release no changes have been made to its functionality. We've merely added the templates.