CodeSmith(9)访问数据库多个表

模版源代码;

<%@ CodeTemplate Language="C#" TargetLanguage="Text"  Debug="True" Description="Template description here." %>
<%@ Property Name="Tables" Type="SchemaExplorer.TableSchemaCollection" Category="Source" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="CodeSmith.CustomProperties" %> 

<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="SchemaExplorer" %>


<% 
//Render Files
for (int i = 0; i < Tables.Count; i++)
{%>
  <%=Tables[i].Name%>;
     <%=Tables[i]%>;
<%}%>

其实主要是声明一个Type的属性SchemaExplorer.TableSchemaCollection.
Tables[i].Name:取得第i个表的表名
Tables[i]:取得第i个表.
生成结果为:

  RB_NYB_NJ_Output;
     dbo.RB_NYB_NJ_Output;
  RB_NYB_NJ_Used;
     dbo.RB_NYB_NJ_Used;
  RB_NYB_SB_Equipment;
     dbo.RB_NYB_SB_Equipment;
  RB_NYB_SB_MainTable;
     dbo.RB_NYB_SB_MainTable;
  RB_NYZX_SC_Acount;
     dbo.RB_NYZX_SC_Acount;
  RB_NYZX_SC_Equipment;
     dbo.RB_NYZX_SC_Equipment;
  RB_NYZX_SC_MainTable;
     dbo.RB_NYZX_SC_MainTable;
  RB_NYZX_SC_Summation;
     dbo.RB_NYZX_SC_Summation;
  RB_NYZX_SC_WorkShift;
     dbo.RB_NYZX_SC_WorkShift;
  RB_SCL_SC_WorkShift;
     dbo.RB_SCL_SC_WorkShift;
  RB_SCL_ZH_Acount;
     dbo.RB_SCL_ZH_Acount;