T4生成实体类

<#@ template language="C#" debug="True" hostspecific="True" #>
 
<#@ output extension=".cs" #>
 
<#@ assembly name="System.Data" #>
 
  
 
<#@ assembly name="System.xml" #>
 
<#@ import namespace="System.Collections.Generic" #>
 
<#@ import namespace="System.Data.SqlClient" #>
 
<#@ import namespace="System.Data" #>
 
 using System;
 
namespace MyProject.Entities
 
{     
 
      <#
 
           string connectionString = "Data Source=.;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=850414";
 
           SqlConnection conn = new SqlConnection(connectionString);
 
           conn.Open();
 
           System.Data.DataTable schema = conn.GetSchema("TABLES");
 
           string selectQuery = "select * from @tableName";
 
           SqlCommand command = new SqlCommand(selectQuery,conn);
 
           SqlDataAdapter ad = new SqlDataAdapter(command);
 
           System.Data.DataSet ds = new DataSet();        
 
           foreach(System.Data.DataRow row in schema.Rows)
 
           {  #>  
 
           public class <#= row["TABLE_NAME"].ToString().Trim('s') #>                   
 
           {    <#                     
                   ds.Tables.Clear();
 
                  command.CommandText = selectQuery.Replace("@tableName",row["TABLE_NAME"].ToString());
 
                  ad.FillSchema(ds, SchemaType.Mapped, row["TABLE_NAME"].ToString());         
 
                  foreach (DataColumn dc in ds.Tables[0].Columns)
 
                  {    #>                    
 
                  private <#= dc.DataType.Name #> _<#= dc.ColumnName.Replace(dc.ColumnName[0].ToString(), dc.ColumnName[0].ToString().ToLower())      #>;                      
 
                  public <#= dc.DataType.Name #> <#= dc.ColumnName #>
 
                  {
 
                     get { return _<#= dc.ColumnName.Replace(dc.ColumnName[0].ToString(), dc.ColumnName[0].ToString().ToLower()) #>; }
 
                     set { _<#= dc.ColumnName.Replace(dc.ColumnName[0].ToString(), dc.ColumnName[0].ToString().ToLower()) #> = value; }
 
                  }                                                
 
              <# }  #>         
 
           }                  
 
           <# 
 
           } #>                
 
}

转子：http://www.cnblogs.com/osamede/archive/2009/07/19/T4_Tutorial.html