CodeSmith .NET三层架构模板

Model模板文件：

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text" %>
<%@ Property Name="NameSpace" Type="String" Category="Context" Description="The namespace to use for this class" %>
<%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %>
<%@ Property Name="Author" Type="String" Category="Context"  Description="Author" %>
<%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %>
/*------------------------------------------------
// File Name:<%=ClearPrefix(TableName.Name) %>Info.cs
// File Description:<%=ClearPrefix(TableName.Name) %> DataBase Entity
// Author:<%=Author%>
// Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%>
//------------------------------------------------*/

using System;

namespace <%=NameSpace%>.Model
{
   /// <summary>
   /// Description <%=TableName.Description %>
   /// </summary>
   [Serializable]
   public class <%=ClearPrefix(TableName.Name) %>Info
   {
  		#region Private Protery
  		<%for(int i=0;i<TableName.Columns.Count;i++){%>
  		private <%=CSharpType(TableName.Columns[i])%> _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>;
  		<%}%>
  		#endregion
  
  		#region Constructor	
  		/// <summary>
  		/// <%=ClearPrefix(TableName.Name) %> Constructor
  		/// </summary>
    	public <%=ClearPrefix(TableName.Name) %>Info()
    	{
    	}
		
  		/// <summary>
  		/// <%=ClearPrefix(TableName.Name) %> Constructor With Parameters
  		/// </summary>
  		<%for(int i=0;i<TableName.Columns.Count;i++){%>
  		///<param name="<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>"><%if(TableName.Columns[i].Description.Length>0){%><%=TableName.Columns[i].Name+"  "+TableName.Columns[i].Description%><%}else{%><%=TableName.Columns[i].Name%><%}%></param>
  		<%}%>
  		public <%=ClearPrefix(TableName.Name) %>Info(<%for(int i=0;i<TableName.Columns.Count;i++){%><%=CSharpType(TableName.Columns[i])%> <%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%><% if (i < TableName.Columns.Count - 1) { %>,<%}%><%}%>)
  		{
  		<%for(int i=0;i<TableName.Columns.Count;i++){%>
   		this._<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%> = <%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>;
  		<%}%>
  		}
  		#endregion
    
  		#region Public Property
        <%for(int i=0;i<TableName.Columns.Count;i++){%>
  		///<Summary>
  		/// <%=TableName.Columns[i].Name%><%if(TableName.Columns[i].Description.Length>0){%>
  		/// <%=TableName.Columns[i].Description%><%}%>
  		///</Summary>
 		public <%=CSharpType(TableName.Columns[i]).Trim()%> <%=TableName.Columns[i].Name%>
  		{
  		get { return _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>; }
   		set {  _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%> = value; }
  		}
		<%}%>
  		#endregion  
   }
}
<script runat="template">
public string CSharpType(ColumnSchema column)
{
 if (column.Name.EndsWith("TypeCode")) return column.Name;
 switch (column.DataType)
 {
  case DbType.AnsiString:
  case DbType.String:
  case DbType.StringFixedLength:
  case DbType.AnsiStringFixedLength: return "string";

  case DbType.VarNumeric:
  case DbType.Currency:
  case DbType.Decimal: return "decimal";

  case DbType.Binary: return "byte[]";
  case DbType.Boolean: return "bool";
  case DbType.Byte: return "byte";
  case DbType.Date: return "DateTime";
  case DbType.DateTime: return "DateTime";
  case DbType.Double: return "double";
  case DbType.Guid: return "Guid";
  case DbType.Int16: return "short";
  case DbType.Int32: return "int";
  case DbType.Int64: return "long";
  case DbType.Object: return "object";
  case DbType.SByte: return "sbyte";
  case DbType.Single: return "float";
  case DbType.Time: return "TimeSpan";
  case DbType.UInt16: return "ushort";
  case DbType.UInt32: return "uint";
  case DbType.UInt64: return "ulong";
  default:
  {
   return "__UNKNOWN__" + column.NativeType;
  }
 }
}
public string ClearPrefix(string name)
{
    int mIndex=name.IndexOf(TablePrefix);
    string strResult=name.Remove(0,TablePrefix.Length);
    return strResult;
}
</script>

IDAL模板文件：

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text" %>
<%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %>
<%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %>
<%@ Property Name="Author" Type="String" Category="Context"  Description="Author" %>
<%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %>
/*------------------------------------------------
// File Name:I<%=ClearPrefix(TableName.Name) %>.cs
// File Description:<%=ClearPrefix(TableName.Name) %> Interface
// Author:<%=Author%>
// Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%>
//------------------------------------------------*/

using System;
using System.Text;
using System.Collections.Generic;
using <%=Namespace%>.Model;

namespace <%=Namespace%>.IDAL
{
	/// <summary>
    /// <%=ClearPrefix(TableName.Name) %> Interface
    /// </summary>
	public interface I<%=ClearPrefix(TableName.Name) %>
	{
		/// <summary>
        /// Add <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		bool Add(<%=ClearPrefix(TableName.Name) %>Info model);
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns>True or False</returns>
		bool DeleteByID(int id);
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		bool DeleteByName(string name);
		
		/// <summary>
        /// Update <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		bool Update(<%=ClearPrefix(TableName.Name) %>Info model);
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		<%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id);
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		<%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name);
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> List
        /// </summary>
        /// <returns><%=ClearPrefix(TableName.Name) %> List</returns>
		IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage();
		
		/// <summary>
        /// Check If <%=ClearPrefix(TableName.Name) %> Exist
        /// </summary>
		/// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name);
	}
}
<script runat="template">
public string ClearPrefix(string name)
{
    int mIndex=name.IndexOf(TablePrefix);
    string strResult=name.Remove(0,TablePrefix.Length);
    return strResult;
}
</script>

SQLServerDAL模板文件：

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text" %>
<%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %>
<%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %>
<%@ Property Name="Author" Type="String" Category="Context"  Description="Author" %>
<%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %>
/*------------------------------------------------
// File Name:<%=ClearPrefix(TableName.Name) %>.cs
// File Description:<%=ClearPrefix(TableName.Name) %> SQL Server DataBase Access
// Author:<%=Author%>
// Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%>
//------------------------------------------------*/

using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using <%=Namespace%>.Model;
using <%=Namespace%>.IDAL;

namespace <%=Namespace%>.DAL
{
	/// <summary>
    /// <%=ClearPrefix(TableName.Name) %>
    /// </summary>
	public class <%=ClearPrefix(TableName.Name) %>:I<%=ClearPrefix(TableName.Name) %>
	{
		public <%=ClearPrefix(TableName.Name) %>(){}
		
		#region <%=ClearPrefix(TableName.Name) %> Interface Implement
		/// <summary>
        /// Add <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		public bool Add(<%=ClearPrefix(TableName.Name) %>Info model){
			SqlParameter[] param = new SqlParameter[<%=TableName.Columns.Count-1 %>];
        	<%for(int i=0;i<TableName.Columns.Count;i++){
			if(((bool)TableName.Columns[i].ExtendedProperties["CS_IsIdentity"].Value) == true) 
			{ 
				continue;
			}%>
			param[<%=i %>] = new SqlParameter("@<%=TableName.Columns[i].Name%>",model.<%=TableName.Columns[i].Name%>);
  			<%}%>
			
        	try
			{
				SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Add<%=ClearPrefix(TableName.Name) %>", param);
				return true;
			}catch
			{
				return false;
			}
		}
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns>True or False</returns>
		public bool DeleteByID(int id){
			SqlParameter[] param = new SqlParameter[1];
			param[0] = new SqlParameter("@id", id);
			try
			{
				SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Del<%=ClearPrefix(TableName.Name) %>ByID", param);
				return true;
			}catch
			{
				return false;
			}
		}
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		public bool DeleteByName(string name){
			SqlParameter[] param = new SqlParameter[1];
			param[0] = new SqlParameter("@name",name);
			try
			{
				SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Del<%=ClearPrefix(TableName.Name) %>ByName", param);
				return true;
			}catch
			{
				return false;
			}
		}
		
		/// <summary>
        /// Update <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		public bool Update(<%=ClearPrefix(TableName.Name) %>Info model){
			SqlParameter[] param = new SqlParameter[<%=TableName.Columns.Count-1 %>];
        	<%for(int i=0;i<TableName.Columns.Count;i++){%>
			param[<%=i %>] = new SqlParameter("@<%=TableName.Columns[i].Name%>",model.<%=TableName.Columns[i].Name%>);
  			<%}%>
        	try
			{
				SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Update<%=ClearPrefix(TableName.Name) %>", param);
				return true;
			}catch
			{
				return false;
			}
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id){
			SqlParameter[] param = new SqlParameter[1];
			param[0] = new SqlParameter("@id", id);
			<%=ClearPrefix(TableName.Name) %>Info model = null;
            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,"SP_Get<%=ClearPrefix(TableName.Name) %>ByID", param))
            {
                while (dr.Read())
                {
                    model = Get<%=ClearPrefix(TableName.Name) %>Model(dr);
                }
                return model;
            }
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name){
			SqlParameter[] param = new SqlParameter[1];
			param[0] = new SqlParameter("@name", name);
			<%=ClearPrefix(TableName.Name) %>Info model = null;
            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,"SP_Get<%=ClearPrefix(TableName.Name) %>ByName", param))
            {
                while (dr.Read())
                {
                    model = Get<%=ClearPrefix(TableName.Name) %>Model(dr);
                }
                return model;
            }
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> List
        /// </summary>
        /// <returns><%=ClearPrefix(TableName.Name) %> List</returns>
		public IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage(){
			using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure, "SP_Get<%=ClearPrefix(TableName.Name) %>ListByPage", null))
            {
                IList<<%=ClearPrefix(TableName.Name) %>Info> list = new List<<%=ClearPrefix(TableName.Name) %>Info>();
                while(dr.Read())
                {
                    list.Add(Get<%=ClearPrefix(TableName.Name) %>Model(dr));
                }
                return list;
            }
		}
		
		/// <summary>
        /// Check If <%=ClearPrefix(TableName.Name) %> Exist
        /// </summary>
		/// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		public bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name){
			SqlParameter[] param = new SqlParameter[1];
			param[0] = new SqlParameter("@name", name);
			return Convert.ToBoolean(SQLHelper.ExecuteScalar(CommandType.StoredProcedure,"SP_Is<%=ClearPrefix(TableName.Name) %>Exist", param));
		}
		#endregion
		
		#region Private Methods	
		private <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>Model(SqlDataReader dr){
			<%=ClearPrefix(TableName.Name) %>Info model=new <%=ClearPrefix(TableName.Name) %>Info();
			<%for(int i=0;i<TableName.Columns.Count;i++){%>
			model.<%=TableName.Columns[i].Name%>=SQLDataHelper.<%=CSharpType(TableName.Columns[i])%>(dr, "<%=TableName.Columns[i].Name%>");
  			<%}%>
			return model;
		}
		
		private IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>List(SqlDataReader dr){
			IList<<%=ClearPrefix(TableName.Name) %>Info> list = new List<<%=ClearPrefix(TableName.Name) %>Info>();
            while (dr.Read())
            {
                list.Add(Get<%=ClearPrefix(TableName.Name) %>Model(dr));
            }
            return list;
		}
		#endregion
	}
}
<script runat="template">
public string CSharpType(ColumnSchema column)
{
 if (column.Name.EndsWith("TypeCode")) return column.Name;
 switch (column.DataType)
 {
  case DbType.AnsiString:
  case DbType.String:
  case DbType.StringFixedLength:
  case DbType.AnsiStringFixedLength: return "GetString";

  case DbType.Int16:
  case DbType.Int32:
  case DbType.Int64:
  case DbType.UInt16:
  case DbType.UInt32:
  case DbType.UInt64: return "GetInt";

  case DbType.Time:
  case DbType.Date:
  case DbType.DateTime: return "GetDateTime";

  case DbType.Binary:
  case DbType.SByte:
  case DbType.Byte: return "GetBytes";

  case DbType.VarNumeric:
  case DbType.Currency:
  case DbType.Decimal: return "GetDecimal";

  case DbType.Single:
  case DbType.Double: return "GetDouble";

  case DbType.Boolean: return "GetBoolean";
  case DbType.Guid: return "GetGuid";
  case DbType.Object: return "GetObject";
  default:
  {
   return "__UNKNOWN__" + column.NativeType;
  }
 }
}
public string ClearPrefix(string name)
{
    int mIndex=name.IndexOf(TablePrefix);
    string strResult=name.Remove(0,TablePrefix.Length);
    return strResult;
}
</script>

BLL模板文件：

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text" %>
<%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %>
<%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %>
<%@ Property Name="Author" Type="String" Category="Context"  Description="Author" %>
<%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %>
/*------------------------------------------------
// File Name:<%=ClearPrefix(TableName.Name) %>BLL.cs
// File Description:<%=ClearPrefix(TableName.Name) %> Business Logic
// Author:<%=Author%>
// Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%>
//------------------------------------------------*/

using System;
using System.Text;
using System.Collections.Generic;
using <%=Namespace%>.Model;
using <%=Namespace%>.IDAL;

namespace <%=Namespace%>.BLL
{
	/// <summary>
    /// <%=ClearPrefix(TableName.Name) %>BLL
    /// </summary>
	public class <%=ClearPrefix(TableName.Name) %>BLL
	{
		//Get <%=ClearPrefix(TableName.Name) %> Entity Class from Factory Layer
        private static readonly I<%=ClearPrefix(TableName.Name) %> dal = <%=Namespace%>.DALFactory.DataAccess.<%=ClearPrefix(TableName.Name) %>();
		
		/// <summary>
        /// Add <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		public bool Add(<%=ClearPrefix(TableName.Name) %>Info model){
			return dal.Add(model);
		}
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns>True or False</returns>
		public bool DeleteByID(int id){
			return dal.DeleteByID(id);
		}
		
		/// <summary>
        /// Delete <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		public bool DeleteByName(string name){
			return dal.DeleteByName(name);
		}
		
		/// <summary>
        /// Update <%=ClearPrefix(TableName.Name) %>
        /// </summary>
        /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param>
        /// <returns>True or False</returns>
		public bool Update(<%=ClearPrefix(TableName.Name) %>Info model){
			return dal.Update(model);
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By ID
        /// </summary>
        /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id){
			return dal.Get<%=ClearPrefix(TableName.Name) %>InfoByID(id);
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> By Name
        /// </summary>
        /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns>
		public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name){
			return dal.Get<%=ClearPrefix(TableName.Name) %>InfoByName(name);
		}
		
		/// <summary>
        /// Get <%=ClearPrefix(TableName.Name) %> List
        /// </summary>
        /// <returns><%=ClearPrefix(TableName.Name) %> List</returns>
		public IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage(){
			return dal.Get<%=ClearPrefix(TableName.Name) %>ListByPage();
		}
		
		/// <summary>
        /// Check If <%=ClearPrefix(TableName.Name) %> Exist
        /// </summary>
		/// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param>
        /// <returns>True or False</returns>
		public bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name){
			return dal.Is<%=ClearPrefix(TableName.Name) %>Exist(name);
		}
	}
}
<script runat="template">
public string ClearPrefix(string name)
{
    int mIndex=name.IndexOf(TablePrefix);
    string strResult=name.Remove(0,TablePrefix.Length);
    return strResult;
}
</script>