StringBuilder sb = new StringBuilder();

sb.AppendLine("using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\n ");

sb.AppendLine("namespace Model\n{");

sb.AppendLine($"    public class {dt.TableName}");

sb.AppendLine("    {");

/*将sql类型转换成c#类型*/

foreach (DataColumn column in dt.Columns)

{

    var colName = column.ColumnName;

    var colType = column.DataType.Name;

    //Console.WriteLine(colName + ":" + colType);

    string propertyType = MapSqlTypeToCSharpType(colType);

    sb.AppendLine($"        public {propertyType} {colName} {{ get; set; }}");

}

sb.AppendLine("    }\n}");

return sb.ToString();