T4 automatically generate a database C # entity class Learning (1)

Demo of the first Test

1<#@ Template language="C #"debug="True"Hostspecific="True"#>2<#@ Output extension=". CS"#>3<#@ Assembly Name="System.Data"#>4 5<#@ Assembly Name="System.Xml"#>6<#@ Assembly Name="System.Data.OracleClient"#>7<#@ Importnamespace="System.Collections.Generic"#>8<#@ Importnamespace="System.Data.OracleClient"#>9<#@ Importnamespace="System.Data"#>Ten  One usingSystem; A usingSystem.Xml; - usingSystem.Data; - usingSystem.Data.OracleClient; the  - namespacemyproject.entities - {     -<# +         stringConnectionString ="Data SOURCE=ORCL; User Id=sde; PASSWORD=SDE";  -OracleConnection conn =NewOracleConnection (connectionString); + Conn. Open ();  A         stringTablename="T_user"; at         stringSelectQuery ="SELECT * from @tableName";  -OracleCommand command =NewOracleCommand (Selectquery,conn);  -System.Data.DataSet ds =NewDataSet ();  -#> -              -          Public class<#= tablename#> in         { -<#                                      to ds. Tables.clear (); +OracleDataAdapter ad=Neworacledataadapter (command); -Command.commandtext = Selectquery.replace ("@tableName", TableName);  the                       * AD. FillSchema (ds, schematype.mapped, tableName); $                     Panax Notoginseng                 foreach(DataColumn DCinchDs. tables[0]. Columns) -                 { the#> +                          A                 Private<#= DC. Datatype.name #> _<#= DC. Columnname.replace (DC. columnname[0]. ToString (), DC. columnname[0]. ToString (). ToLower ()) #>; the                      +                      -                  Public<#= DC. Datatype.name #> <#= DC. ColumnName #> $                 { $                     Get{return_<#= DC. Columnname.replace (DC. columnname[0]. ToString (), DC. columnname[0]. ToString (). ToLower ()) #>; }  -                     Set{_<#= DC. Columnname.replace (DC. columnname[0]. ToString (), DC. columnname[0]. ToString (). ToLower ()) #> =value;} -                 }                     the                                  -<#    Wuyi                 }                  the#> -                  Wu                  -             }                 About              $<#     -#> -}

T4 automatically generate a database C # entity class Learning (1)