使用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 Tarkool.IncentiveSolution.BLLModel
{     
      <#
string connectionString = "Data Source=TARKOOL-REX\\SQLEXPRESS;Initial Catalog=WebShoppingMall;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;
        }
		<# }  #>


    }
<#}#>
}

注意：

1.数据库中的表名字不能为User,Role,Order等关键字母，否则会报错