Pre-Requisites
To follow the T4 Toolbox tutorial you will need latest versions of:
A local instance of SQL Server should be installed with SQL Server Data Tools. This tutorial assumes that SQL Server 2016 (v13) is running. You should be able to use earlier and, presumably, later versions by using the appropriate server instance.
Install the Northwind sample database.
* Install the SQL2000SampleDb.msi.
* Open the C:\SQL Server 2000 Sample Databases\instnwnd.sql script in Visual Studio and execute it.
* When prompted, select the appropriate local SQL server instance, such as (localdb)\ProjectsV13 for SQL Server 2016.
* Verify that the database was created successfully using the SQL Server Object Explorer.