Customers.tt 1.2 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <#@ assembly name="System.Core.dll" #>
  2. <#@ assembly name="System.Data.dll" #>
  3. <#@ assembly name="System.Data.DataSetExtensions.dll" #>
  4. <#@ assembly name="System.Xml.dll" #>
  5. <#@ import namespace="System" #>
  6. <#@ import namespace="System.Xml" #>
  7. <#@ import namespace="System.Linq" #>
  8. <#@ import namespace="System.Data" #>
  9. <#@ import namespace="System.Data.SqlClient" #>
  10. <#@ import namespace="System.Collections.Generic" #>
  11. <#@ import namespace="System.IO" #>
  12. <#@ include file="$(ProjectDir)DbHelper.ttinclude" #>
  13. using System;
  14. namespace T4ConsoleApplication.Entities
  15. {
  16. public class <#=config.TableName#>
  17. {
  18. <# foreach(DbColumn column in DbHelper.GetDbColumns(config.ConnectionString, config.DbDatabase, config.TableName)){#>
  19. public <#= column.CSharpType#><# if(column.CommonType.IsValueType && column.IsNullable){#>?<#}#> <#=column.ColumnName#> { get; set; }
  20. <#}#>
  21. }
  22. }
  23. <#+
  24. public class config
  25. {
  26. //修改要生成的数据库表
  27. public static readonly string ConnectionString="Server=11.168.39.6; Database=CN00002273; user Id=hrnet;password=Passw0rd@123;";
  28. public static readonly string DbDatabase="Inferno";
  29. public static readonly string TableName="RepositoryModel";
  30. }
  31. #>