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 CZBK.ItcastOA.Model
{       
<#  
string connectionString = "Data Source=.;Initial Catalog=OA;User ID=sa;Password=123456;";  
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)  
{ 
#>  
[Serializable]  
public class Ex<#= row["TABLE_NAME"].ToString()#>                     
{  
<#                       
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)  
{
#>  
public <#= dc.DataType.Name #> <#= dc.ColumnName #>  { get; set; }  
<#
}
#>  
}  
<#
}
#>  
}