<#@ 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; }        <#}#>            }                <#}#>               }