CodeSmith,SqlServer,C#中的类型对照

CodeSmith,SqlServer,C#中的类型对照  

类型对照

CodeSmith      SqlServer                                       C#

SqlServer         CodeSmith                                   csbigint                  Int64                                        Int64binary                 Binary                               System.Byte[]bit                      Boolean                                    boolchar                  AnsiStringFixedLength              stringdatetime             DateTime                                   stringdecimal              Decimal                                    Decimalfloat                   Double                                        Doubleimage                 Binary                                System.Byte[]int                      Int32                                            intmoney               Currency                                   Singlenchar                 StringFixedLength                          stringntext                  String                                            stringnumeric             Decimal                                    Decimalnvarchar            String                                            stringreal                   Single                                            Singlesmalldatetime     DateTime                                       stringsmallint               Int16                                            Int16smallmoney         Currency                                   Singlesql_variant          Object                                        Objecttext                     AnsiString                                   stringtimestamp           Binary                                    System.Byte[]tinyint                  Byte                                            Byteuniqueidentifier     Guid                                       System.Guidvarbinary             Binary                                    System.Byte[]varchar                AnsiString                                   string

其中有些类型为了处理简便，做了一些调整。如：DataTime类型转成string型处理