Sample of using T4 templates for creating T-SQL procedures
T4TemplatesInPractice is the main project which contains 5 samples with increasing complexity.
DatabaseSchemaReader.Extensions has quite dirty code without comments, because it was made only for this samples.