CodeSmith生成MySQL实体模板
替换解压或安装后的目录CodeSmith_jb51\v7.0\SchemaProviders中的SchemaExplorer.MySQLSchemaProvider.dll文件为本文件夹里修改过的dll
打开CodeSmith_jb51\v7.0目录中的TemplateEditor.exe程序,在My Templates上右键新建CodeSmith Generator Template (CSharp)类型文件,并分别复制以下两个文件:
- AutoGenDOTemplate.cst用于生成数据库实体
- AutoGenDTOTemplate.cst用于生成传输层实体或展示层实体
server=...;port=3306;User Id=...;database=...;password=...
using System;
using System.Collections.Generic;
using System.Text;
namespace NetCoreApiDemo.Dal.Model
{
[Table("order")]
public class OrderDO
{
/// <summary>
/// 主订单自增主键
/// </summary>
[Key]
[Column("id")]
public ulong Id { get; set; }
/// <summary>
/// 用户Id
/// </summary>
[Column("user_id")]
public string UserId { get; set; }
/// <summary>
/// 用户姓名
/// </summary>
[Column("user_name")]
public string UserName { get; set; }
/// <summary>
/// 用户联系电话
/// </summary>
[Column("user_tel")]
public string UserTel { get; set; }
/// <summary>
/// 创建人
/// </summary>
[Column("create_by")]
public string CreateBy { get; set; }
/// <summary>
/// 创建时间
/// </summary>
[Column("create_time")]
public DateTime CreateTime { get; set; }
/// <summary>
/// 修改人
/// </summary>
[Column("modify_by")]
public string ModifyBy { get; set; }
/// <summary>
/// 修改时间
/// </summary>
[Column("modify_time")]
public DateTime ModifyTime { get; set; }
}
}