Ing between SQL Server Type and DOTNET type

. NET Framework data provider for SQL Server

SQL Server Type	. NET Framework type	. NET Framework typed accessor	Sqltype typed accessor
Bigint	Int64	Getint64 ()	Getsqlint64 ()
Binary	Byte []	Getbytes ()	Getsqlbinary ()
Bit	Boolean	Getboolean ()	Getsqlbit ()
Char	String Char []	Getstring () Getchars ()	Getsqlstring ()
Datetime	Datetime	Getdatetime ()	Getsqldatetime ()
Decimal	Decimal	Getdecimal ()	Getsqldecimal ()
Float	Double	Getdouble ()	Getsqldouble ()
Image	Byte []	Getbytes ()	Getsqlbinary ()
Int	Int32	Getint32 ()	Getsqlint32 ()
Money	Decimal	Getdecimal ()	Getsqlmoney ()
Nchar	String Char []	Getstring () Getchars ()	Getsqlstring ()
Ntext	String Char []	Getstring () Getchars ()	Getsqlstring ()
Numeric	Decimal	Getdecimal ()	Getsqldecimal ()
Nvarchar	String Char []	Getstring () Getchars ()	Getsqlstring ()
Real	Single	Getfloat ()	Getsqlsingle ()
Smalldatetime	Datetime	Getdatetime ()	Getsqldatetime ()
Smallint	Int16	Getint16 ()	Getsqlint16 ()
Smallmoney	Decimal	Getdecimal ()	Getsqldecimal ()
SQL _variant	Object *	Getvalue ()*	Getsqlvalue ()*
Text	String Char []	Getstring () Getchars ()	Getsqlstring ()
Timestamp	Byte []	Getbytes ()	Getsqlbinary ()
Tinyint	Byte	Getbyte ()	Getsqlbyte ()
Uniqueidentifier	Guid	Getguid ()	Getsqlguid ()
Varbinary	Byte []	Getbytes ()	Getsqlbinary ()
Varchar	String Char []	Getstring () Getchars ()	Getsqlstring ()

If you want to know the relationship with other databases. See msdn: http://msdn2.microsoft.com/en-us/library/4e5xt97a (vs.71). aspx