T4 template to Generate Enums

by

I have written one for my needs that converts a lookup table of your choice to an enum:
Put this code inside an EnumGenerator.ttinclude file:

<#@ template debug="true" hostSpecific="true" #>
<#@ output extension=".generated.cs" #>
<#@ Assembly Name="System.Data" #>
<#@ import namespace="System.Data" #>
<#@ import namespace="System.Data.SqlClient" #>
<#@ import namespace="System.IO" #>
<#@ import namespace="System.Text.RegularExpressions" #>
<#
    string tableName = Path.GetFileNameWithoutExtension(Host.TemplateFile);
    string path = Path.GetDirectoryName(Host.TemplateFile);
    string columnId = tableName + "ID";
    string columnName = "Name";
    string connectionString = "data source=.;initial catalog=DBName;integrated security=SSPI";
#>
using System;
using System.CodeDom.Compiler;

namespace Services.<#= GetSubNamespace() #>
{
    /// <summary>
    /// <#= tableName #> auto generated enumeration
    /// </summary>
    [GeneratedCode("TextTemplatingFileGenerator", "10")]
    public enum <#= tableName #>
    {
<#
    SqlConnection conn = new SqlConnection(connectionString);
    string command = string.Format("select {0}, {1} from {2} order by {0}", columnId, columnName, tableName);
    SqlCommand comm = new SqlCommand(command, conn);

    conn.Open();

    SqlDataReader reader = comm.ExecuteReader();
    bool loop = reader.Read();

    while(loop)
    {
#>      /// <summary>
        /// <#= reader[columnName] #> configuration setting.
        /// </summary>
        <#= Pascalize(reader[columnName]) #> = <#= reader[columnId] #><# loop = reader.Read(); #><#= loop ? ",\r\n" : string.Empty #>
<#
    }
#>  }
}
<#+
    private string Pascalize(object value)
    {
        Regex rx = new Regex(@"(?:[^a-zA-Z0-9]*)(?<first>[a-zA-Z0-9])(?<reminder>[a-zA-Z0-9]*)(?:[^a-zA-Z0-9]*)");
        return rx.Replace(value.ToString(), m => m.Groups["first"].ToString().ToUpper() + m.Groups["reminder"].ToString().ToLower());
    }

    private string GetSubNamespace()
    {
        Regex rx = new Regex(@"(?:.+Services\s)");
        string path = Path.GetDirectoryName(Host.TemplateFile);
        return rx.Replace(path, string.Empty).Replace("\\", ".");
    }
#>

Then whenever you’d like an enum to be generated, just create a tt file with the same name as database table like UserType.tt and put this code in:

<#@ include file="..\..\T4 Templates\EnumGenerator.ttinclude" #>

An even more advanced template is now available in my blog post.

More Related Contents:

  1. Is LINQ to SQL Dead or Alive?
  2. Does AutoMapper support Linq?
  3. How to do a join in linq to sql with method syntax?
  4. How do I update a Linq to SQL dbml file?
  5. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  6. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  7. Explicit construction of entity type ‘###’ in query is not allowed.
  8. NOLOCK with Linq to SQL
  9. Common Table Expression (CTE) in linq-to-sql?
  10. Convert SQL to LINQ to SQL
  11. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  12. Using System.Data.Linq in a Razor view
  13. linq to sql: join multiple columns from the same table
  14. LINQ-to-SQL vs stored procedures? [closed]
  15. How can I conditionally apply a Linq operator?
  16. efficient way to implement paging
  17. LINQ to SQL – Left Outer Join with multiple join conditions
  18. Understanding SQL Server LOCKS on SELECT queries
  19. TransactionScope vs Transaction in LINQ to SQL
  20. Get SQL query from LINQ to SQL?
  21. How to write Asynchronous LINQ query?
  22. How do you perform a CROSS JOIN with LINQ to SQL?
  23. How can I reject all changes in a Linq to SQL’s DataContext?
  24. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  25. Get all associate/composite objects inside an object (in Abstract way)
  26. Is there a difference between Select * and Select [list each col] [duplicate]
  27. Linq To Sql – Dynamic OrderBy – Case When
  28. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  29. LinqToSql declare and instantiate DataContext best practice?
  30. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?

Leave a Comment