CodeSmith访问数据库

<%@ CodeTemplate Language="C#" TargetLanguage="C#" ResponseEncoding="UTF-8" Debug="False" Description="Creates a simplistic entity object." %> 

<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the stored procedures should be based on." %> 
<%@ Assembly Name="SchemaExplorer" %> 
<%@ Import Namespace="SchemaExplorer" %> 

using System; 
using System.Runtime.Serialization; 

namespace BE 
{ 
    /// <summary> 
    /// <%= SourceTable.Name %> 实体类 
    /// TerryFeng <%= DateTime.Now.ToString()%> 
    /// </summary> 
    [DataContract] 
    public class <%= SourceTable.Name %> 
    { 
        #region 私有成员 
        <% for (int i = 0; i < SourceTable.Columns.Count; i++) { %> 
        private <%= SourceTable.Columns[i].SystemType %> _<%= StringUtil.ToCamelCase(SourceTable.Columns[i].Name) %>; 
        <% } %> 
        #endregion 
        #region 数据契约属性 
        <% for (int i = 0; i < SourceTable.Columns.Count; i++) { %> 
        /// <summary> 
        /// <%= SourceTable.Columns[i].Description %> 
        /// </summary> 
        [DataMember] 
        public <%= SourceTable.Columns[i].SystemType %> <%= StringUtil.ToPascalCase(SourceTable.Columns[i].Name) %> 
        { 
            get 
            { 
                return this._<%= StringUtil.ToCamelCase(SourceTable.Columns[i].Name) %>; 
            } 
            set 
            { 
                this._<%= StringUtil.ToCamelCase(SourceTable.Columns[i].Name) %> = value; 
            } 
        } 
        <% } %> 
        #endregion 
    } 
}