复制代码 代码如下:

<#@ template debug="True" hostspecific="True" language="C#" #><#@ assembly name="System.Core" #>

<#@ assembly name="System.Data" #>

<#@ assembly name="System.xml" #>

<#@ import namespace="System.Collections.Generic" #>

<#@ import namespace="System.Data" #>

<#@ import namespace="System.Data.SqlClient" #>

<#@ import namespace="System.Linq" #>

<#@ import namespace="System.Text" #>

<#@ import namespace="System.Collections.Generic" #>

<#@ output extension=".cs" #>

using System;

using DotNet.Framework.DataAccess.Attribute;

using System.Data;

namespace MyProject.Entities

{

<#

string connectionString = "Data Source=localhost;Initial Catalog=EDNFramework;User ID=sa;pwd=as";

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()#>

{<#

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)

{#>

[DataMapping("<#= dc.ColumnName #>")]

public <#= dc.DataType.Name #> <#= dc.ColumnName #> { get; set; }

<#}#>

}

<#}#>

}