Tuesday, February 14, 2006

Data Mapping in SQL Server Data in C# with ADO.NET

Accessing SQL Server Data in C# with ADO.NET: "SQLServer Type SQL-92 Compliant Type C# Type CLS-Compliant Type
binary + * binary byte[] Byte[]
bigint bigint long Int64
bit bit bool Boolean
char * character char Char
datetime ** datetime DateTime DateTime
decimal dec decimal Decimal
float double precision float Float
image *** varchar Image Image
int integer int Int32
money ++++ SqlMoney SqlMoney
nchar +++ * national character char Char
ntext +++ national text string String
nvarchar +++ **** national character varying char ArrayList Char ArrayList
numeric dec decimal Decimal
real double precision float Float
smalldatetime ** smalldatetime DateTime DateTime
smallint smallint short Int16
smallmoney ++++ SqlMoney SqlMoney
sql_variant sql_variant object Object
text text string String
timestamp ++ rowversion byte ArrayList Byte ArrayList
tinyint tinyint byte Byte
varbinary + **** binary varying byte ArrayList Byte ArrayList
varchar **** character varying char ArrayList Char ArrayList
uniqueidentifier uniqueidentifier byte[16] or Guid Byte[16] or Guid"

No comments: