C# - Sql数据类型的对应关系
<Language From="SQL" To="C#"> <Type From="bigint" To="long" /> <Type From="binary" To="object" /> <Type From="bit" To="bool" /> <Type From="char" To="string" /> <Type From="datetime" To="DateTime" /> <Type From="decimal" To="decimal" /> <Type From="float" To="double" /> <Type From="image" To="byte[]" /> <Type From="int" To="int" /> <Type From="money" To="decimal" /> <Type From="nchar" To="string" /> <Type From="ntext" To="string" /> <Type From="numeric" To="decimal" /> <Type From="nvarchar" To="string" /> <Type From="real" To="float" /> <Type From="smalldatetime" To="DateTime" /> <Type From="smallint" To="short" /> <Type From="smallmoney" To="decimal" /> <Type From="text" To="string" /> <Type From="timestamp" To="byte[]" /> <Type From="tinyint" To="byte" /> <Type From="uniqueidentifier" To="Guid" /> <Type From="varbinary" To="byte[]" /> <Type From="varchar" To="string" /> <Type From="xml" To="string" /> <Type From="sql_variant" To="object" /> </Language> <Language From="SQL" To="C# System Types"> <Type From="bigint" To="System.Int64" /> <Type From="binary" To="System.Object" /> <Type From="bit" To="System.Boolean" /> <Type From="char" To="System.String" /> <Type From="datetime" To="System.DateTime" /> <Type From="decimal" To="System.Decimal" /> <Type From="float" To="System.Double" /> <Type From="image" To="System.Byte[]" /> <Type From="int" To="System.Int32" /> <Type From="money" To="System.Decimal" /> <Type From="nchar" To="System.String" /> <Type From="ntext" To="System.String" /> <Type From="numeric" To="System.Decimal" /> <Type From="nvarchar" To="System.String" /> <Type From="real" To="System.Single" /> <Type From="smalldatetime" To="System.DateTime" /> <Type From="smallint" To="System.Int16" /> <Type From="smallmoney" To="System.Decimal" /> <Type From="text" To="System.String" /> <Type From="timestamp" To="System.Byte[]" /> <Type From="tinyint" To="System.Byte" /> <Type From="uniqueidentifier" To="System.Guid" /> <Type From="varbinary" To="System.Byte[]" /> <Type From="varchar" To="System.String" /> <Type From="xml" To="System.String" /> <Type From="sql_variant" To="System.Object" /> </Language>
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。