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

来源:互联网 发布:sql numeric报错 编辑:程序博客网 时间:2024/05/06 06:51
SQLServer          CodeSmith                            C#
bigint                    Int64                                 Int64
binary                   Binary                                System.Byte[]
bit                         Boolean                              bool
char                      AnsiString                          string
datetime              DateTime                            string
decimal                Decimal                              Decimal
float                      Double                               Double
image                   Binary                                System.Byte[]
int                          Int32                                 int
money                   Currency                            Single
nchar                    StringFixedLength             string
ntext                    String                                  string
numeric               Decimal                                Decimal
nvarchar              String                                   string
real                       Single                                  Single
smalldatetime     DateTime                              string
smallint                Int16                                   Int16
smallmoney         Currency                             Single
sql_variant          Object                                  Object
text                      AnsiString                           string
timestamp           Binary                                 System.Byte[]
tinyint                  Byte                                    Byte
uniqueidentifier  Guid                                    System.Guid
varbinary             Binary                                 System.Byte[]
varchar                AnsiString                           string