P3.NET

Creating an SSIS Custom Task, Updated

Last year I posted a series of articles about creating custom SSIS tasks to cleanly wrap some common work you may find yourself doing in SSIS. You could do this with script tasks but if you need this same functionality everywhere then it becomes a maintenance issue. In that series of articles we created a framework for adding new tasks easily and created one task to generate SSRS reports. Since that time my company has been using these tasks successfully but we did identify a couple of issues. Since that series of blog posts was based upon the lessons we learned it makes sense to update the code with the changes we’ve made over the past year.

Read More

Creating Item Templates in Visual Studio 2017

Many times when you are adding a new item to a project you probably find yourself changing the generated item to line up with your coding or company styles. Often this includes a copyright, perhaps the ordering of members in a type or even completely replacing the item with something else, like an enum. Visual Studio is designed to be extensible. Item templates allow you to create your own templates and have them available in VS so you don’t have to keep making the same changes over and over again. In VS 2017 templates are even easier to create than before. I will discuss how easy it is to add new templates in this article.

Item Templates

Before creating an item template you need to understand what it is. Open any projects in VS and then right click the project and select Add and then any item under there (eg. New Item). What pops up is Add New Item dialog. Each of these is an item template. Item templates can come from anywhere including the core VS installation, extensions you install later and from the file system. Under your Documents folder where VS stores your information is a folder where it looks for your custom item templates (default for VS 2017 is Visual Studio 2017\Templates\ItemTemplates.

Templates are designed to quickly allow you to add new files to your projects without having to redo the same changes each time. While you can edit the provided templates I would not recommend it for several reasons. Firstly the changes may get lost on the next update. Secondly reinstalling VS would wipe the templates and templates between versions may change. Thirdly, sometimes you really do want the original templates available so replacing them is not a good idea.

Creating a new template really just involves creating the skeleton file(s) with the content you want and adding some metadata so VS knows what to display. Unfortunately templates are very limited in what they can do. Any sort of programmatic changes will require using a wizard instead.

Extension Class Template

Extension classes are pretty common in code these days so we’ll create a template that handles this for us. The easiest way to get started is to take an existing extension class and make it generic.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    /// <summary>Provides extension methods for SomeType.</summary>
    public static class SomeTypeExtensions
    {
        public static void DoSomething ( this SomeType source )
        {
        }
    }
}

Now to make it reusable. Firstly the user will provide a name for the new item when they create it so we want to use that as the class name. In a template you can use the $safeitemname$ value. Find all places in the file that use the class name and replace them. Notice the parameter is called –safe. VS will remove characters from the name that are not valid as identifiers.

The namespace should follow the default project namespace. Additionally the folder in which the item is dropped into should be included to follow convention. Fortunately there is a parameter for that as well $rootnamespace$. Replace the namespace name with this as well. Sidenote that MSDN mentions that you can use $safeprojectname$ for the namespace but this does not appear accurate. When used in an item template it does nothing. The documentation for the parameter mentions it is for the New Project dialog and therefore isn’t valid for item templates.

Finally, just for fun we’ll add a copyright notice. This time we’ll use the $year$ parameter which puts the current year in the file. The full list of available template parameters is defined here. Here’s the final template.

/*
 * Copyright © $year$ My Company
 * All Rights Reserved
 */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace $rootnamespace$
{
    /// <summary>Provides extension methods for SomeType.</summary>
    public static class $safeitemname$
    {
        public static void DoSomething ( this SomeType source )
        {
        }
    }
}

VSTemplate File

Now that the item skeleton is complete we need to let VS know about it. To do that we need to create a vstemplate file. A vstemplate file is an XML file that describes the template, where it should be placed and what file(s) make it up. Here’s a standard example.

<?xml version="1.0"?>
<VSTemplate Type="Item" Version="3.0.0" xmlns="http://schemas.microsoft.com/developer/vstemplate/2005">
  <TemplateData>
    <Name>Extension Class</Name>
    <Description>Creates an extension class.</Description>
    <Icon></Icon>
    <ProjectType>CSharp</ProjectType>
    <DefaultName>MyExtension</DefaultName>    
  </TemplateData>
  <TemplateContent>
    <ProjectItem ReplaceParameters="true" TargetFileName="$fileinputname$.cs">ExtensionClass.cs</ProjectItem>
  </TemplateContent>
</VSTemplate>

Let’s take this file apart. The VSTemplate element identifies whether this is a project or item template. Within this element is the template metadata and content. The TemplateData element defines the metadata for the template. The TemplateContent element defines the file(s) that make up the template.

Name (required)
The name of the template as shown to the user
Description (required)
The description of the template as shown to the user
Icon (required)
The icon file of the template
ProjectType (required)
The type of project the template works with (CSharp, VisualBasic, VC or Web)
ProjectSubtype
The subtype of project the template works with

The documentation for vstemplate files is defined here but be aware that this file is used for both item and project templates. Some elements are only meaningful for one or the other. Read the documentation carefully to ensure you can use an element.

Note that previous versions of VS supported using a resource DLL for some of the values. For performance reasons it is recommended that you do not do this going forward.

The project type and subtype values are tied together. For a C# project you can specify a type of CSharp and leave subtype off. But for a web project you need to specify the type as Web and the subtype as CSharp. A full discussion is available in MSDN.

Template Content

Under the TemplateContent is a ProjectItem element for each file that is part of the template. Yes you can have multiple files in a template. The value of the element is the name of the file inside the template. All attributes are optional.

TargetFileName
The filename to use in the project (generally set to $fileinputname$.cs or similar)
ReplaceParameters
Indicates whether the file contains template parameters that should be replace (generally set to true)
Subtype
The optional editor to use for the file (generally only used for nested files)
CustomTool
The optional custom tool to associate with the file

While not needed here, you can also have a References element which child Reference elements. You can use this to add assembly references to a project when the item is added. You can read more about them here.

The last thing you’ll want to do is create an icon file (or copy one) for the template. Ensure the filename matches what is in the template. Note that if you leave the icon element empty then a generic icon is used instead.

Installing the Template

Prior to VS 2017 you would need to zip up the vstemplate and content files and put them into one of the searched template paths. With VS 2017 not only do you not need to zip them up anymore but you are encouraged not to for performance reasons. Instead all you need to do is drop the files into a folder in one of the search paths and VS will find them.

For local templates you can put them in the documents folder as mentioned earlier. For shared templates place them someplace everyone on the template has access to and ensure VS is updated to use the shared template location. When looking at the template structure that is generated by VS you’ll notice it is broken up by language. For a C# template you’ll want to put your templates in the Visual C# folder. The same goes for the other languages.

Create a folder for your template (e.g. ExtensionClass). Now copy your content files, icon file and vstemplate file into the folder. In my experience VS will only look for templates once so restart VS after dropping the template into the folder and then open a project and select Add\New Item again. You will probably need to scroll but you should find your template. Select it, enter an item name and verify the item is added properly.

Now that you have one template working, it becomes easy to simply copy/paste the folder structure, change the template contents and update the vstemplate file to create new ones. Using your own custom templates should greatly speed up your development.

A final note on the folder structure. The documentation mentions that you can create template categories to group your templates together by creating a category folder in the root of the language template folder and then create your template folders under that. It indeed does work for extensions but custom templates don’t appear to work. If you put an intermediate category folder under the language folder then VS will ignore your template. Whether this is a bug or not I cannot say.

Template Wizards

The templating engine built into VS is pretty limiting. If you want to make more complex templates then you will have to define a template wizard. Creating a wizard is beyond the scope of this post but I created one a while back in my series on creating environmental config transforms using T4. The vstemplate file needs to be updated to point to the wizard if you go this route.

Exporting Templates

The approach I talked about here is a completely manual process for creating templates. If you already have a file defined in a project that you want to reuse elsewhere then you can export the file (or even the project) using the Project\Export Template option. Note that this generates a template but does so following the older rules. You can read more about exported templates in MSDN.

DbLimitExpression Exception

Recently I was writing some code for one of my personal projects and I ran across this error in the first Entity Framework call I made – System.ArgumentException ‘DbLimitExpression’ requires a collection argument. Haven’t seen that one before. For anyone running into this issue here’s how I figured it out.

Read More

Office 2016: Selective Installation

A while back I posted about the Office 2016 release and why I wasn’t going to run it. One of the biggest complaints I had was the fact that there were no setup options. It installs everything whether you use it or not. Fortunately that has now changed, sort of. This post is discussing the steps you can take to install only the apps you want to install. It still is not perfect, it still makes no sense whatsoever and it still doesn’t make me want to recommend Office 2016. But at least I can now run it without all the wasted space.

Read More

Writing a Context Provider for CodeRush for Roslyn

Several years ago I wrote an article about creating a custom context provider for CodeRush. In that time CodeRush Classic, as it is called, has been replaced by CodeRush for Roslyn which relies on Roslyn. Now seems like a good time to update the provider. Rather than having to read both articles I’m going to repost the old article with updated changes for Roslyn. The code is semantically similar but had to be rewritten to use Roslyn.

Read More

Generating _PublishedWebsites in TFBuild

We have slowly been migrating our XAML builds to TFBuild. After having blogged about how we created custom build tasks we were finally ready to start transitions our builds. At our company we have basically 3 different kinds of builds – ASP.NET apps, console applications and REST APIs. Using XAML builds our deployment process was configured to look for the _PublishedWebsites directory for ASP.NET apps but that doesn’t get created in TFBuild. Hence I spent some time looking for a solution.

Read More

Create a Build Task for TFBuild, Part 2

In the last post I demonstrated how to create a build task for TFBuild that showed the build variables. I also demonstrated how to wrap the task in a build extension that could be installed in TFS, on-premise. In this post we’ll add another task to the extension. This serves two purposes. Firstly it demonstrates hosting multiple tasks in a single extension. Secondly it demonstrates a more common build task, versioning assemblies.

Read More

Custom Naming Styles in Visual Studio 2017

One of the great new features in Visual Studio 2017 is the ability to define naming rules for code and then let the IDE notify you when they are violated. Depending upon what options you choose the IDE can suggestion, warn or flat out fail compilation because of violations. In this release the options are limited but since the rules are using Roslyn, the options can only improve in later releases.

Read More