代码生成器 CodeSmith 的使用（六）

最新推荐文章于 2022-01-13 14:16:23 发布

SpringFiled

最新推荐文章于 2022-01-13 14:16:23 发布

阅读量726

点赞数

分类专栏： CodeSmith ORM

本文链接：https://blog.csdn.net/SpringFileld/article/details/39209001

版权

ORM 同时被 2 个专栏收录

9 篇文章

订阅专栏

CodeSmith

6 篇文章

订阅专栏

本文介绍如何使用不同的命名规则（Camel、Pascal 和原生）来生成针对特定数据库表的 PetaPoco ORM 映射类。通过代码模板的方式，实现了属性名的转换，并展示了具体的生成效果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在上一篇的版本中，我们生成了数据库所有表中的字段，如果要使数据库中的单个表 生成 PetaPoco 构架下的 ORM 映射，使那怎么办。这是这篇博客的主要内容。



首先来看完整的 Camel 规则模板：

<%--
Name:  Copyright © Sun 2013-2014 All rights reserved
Contact me:  Sunnydayhu@163.com
Author:  SpringFileld
Description: 遍历数据库中指定的表，并映射成 PetaPoco类的 orm
DateTime: 2014-07-31
--%>

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Debug="False" Description="Create a list of properties from database table." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>
<%@ Map Name="CSharpAlias" Src="System-CSharpAlias" Description="System to C# Type Map" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Assembly  Name="xftwl.Infrastructure" %>
<%@ Import  Namespace="xftwl.Infrastructure" %>


[TableName("<%=SourceTable.Name %>")]
<%foreach (var pk in SourceTable.PrimaryKey.MemberColumns){ %>
[PrimaryKey("<%= pk.Name%>")]
<%} %>
[ExplicitColumns]
public partial class  <%=SourceTable.Name %>
  {
    <%foreach( var cl in SourceTable.Columns) {%>
     [Column]
     public <%=CSharpAlias[cl.SystemType.FullName]%> <%=StringUtil.ToCamelCase(cl.Name) %> { get; set; }
    <%} %>
  }



生成的效果如下：


[TableName("acc_card_account")]
[PrimaryKey("Id")]
[ExplicitColumns]
public partial class  acc_card_account
  {
     [Column]
     public int id { get; set; }
     [Column]
     public System.DateTime dateCreate { get; set; }
     [Column]
     public string card { get; set; }
     [Column]
     public decimal balance { get; set; }
     [Column]
     public decimal interest { get; set; }
     [Column]
     public decimal interestRates { get; set; }
     [Column]
     public string remark { get; set; }
  }


Pascall 规则：

<%--
Name:  Copyright © Sun 2013-2014 All rights reserved
Contact me:  Sunnydayhu@163.com
Author:  SpringFileld
Description: 遍历数据库中指定的表，并映射成 PetaPoco类的 orm
DateTime: 2014-07-31
--%>

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Debug="False" Description="Create a list of properties from database table." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>
<%@ Map Name="CSharpAlias" Src="System-CSharpAlias" Description="System to C# Type Map" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Assembly  Name="xftwl.Infrastructure" %>
<%@ Import  Namespace="xftwl.Infrastructure" %>


[TableName("<%=SourceTable.Name %>")]
<%foreach (var pk in SourceTable.PrimaryKey.MemberColumns){ %>
[PrimaryKey("<%= pk.Name%>")]
<%} %>
[ExplicitColumns]
public partial class  <%=SourceTable.Name %>
  {
    <%foreach( var cl in SourceTable.Columns) {%>
     [Column]
     public <%=CSharpAlias[cl.SystemType.FullName]%> <%=StringUtil.ToPascalCase(cl.Name) %> { get; set; }
    <%} %>
  }



生成的效果如下：

[TableName("acc_card_account")]
[PrimaryKey("Id")]
[ExplicitColumns]
public partial class  acc_card_account
  {
     [Column]
     public int Id { get; set; }
     [Column]
     public System.DateTime DateCreate { get; set; }
     [Column]
     public string Card { get; set; }
     [Column]
     public decimal Balance { get; set; }
     [Column]
     public decimal Interest { get; set; }
     [Column]
     public decimal InterestRates { get; set; }
     [Column]
     public string Remark { get; set; }
  }


 原生的：

<%--
Name:  Copyright © Sun 2013-2014 All rights reserved
Contact me:  Sunnydayhu@163.com
Author:  SpringFileld
Description: 遍历数据库中指定的表，并映射成 PetaPoco类的 orm
DateTime: 2014-07-31
--%>

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Debug="False" Description="Create a list of properties from database table." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>
<%@ Map Name="CSharpAlias" Src="System-CSharpAlias" Description="System to C# Type Map" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Assembly  Name="xftwl.Infrastructure" %>
<%@ Import  Namespace="xftwl.Infrastructure" %>


[TableName("<%=SourceTable.Name %>")]
<%foreach (var pk in SourceTable.PrimaryKey.MemberColumns){ %>
[PrimaryKey("<%= pk.Name%>")]
<%} %>
[ExplicitColumns]
public partial class  <%=SourceTable.Name %>
  {
    <%foreach( var cl in SourceTable.Columns) {%>
     [Column]
     public <%=CSharpAlias[cl.SystemType.FullName]%> <%=cl.Name %> { get; set; }
    <%} %>
  }


生成的效果：

[TableName("acc_card_account")]
[PrimaryKey("Id")]
[ExplicitColumns]
public partial class  acc_card_account
  {
     [Column]
     public int Id { get; set; }
     [Column]
     public System.DateTime DateCreate { get; set; }
     [Column]
     public string Card { get; set; }
     [Column]
     public decimal Balance { get; set; }
     [Column]
     public decimal Interest { get; set; }
     [Column]
     public decimal InterestRates { get; set; }
     [Column]
     public string Remark { get; set; }
  }