SQL corresponds to the ASP.net data type (MSDN referenced)

asp.net| Data | data type BigInt

Supported by the. NET Compact Framework.

Int64

A 64-bit signed integer.

Binary

Supported by the. NET Compact Framework.

Array type is Byte

The fixed-length stream of binary data, ranging from 1 to 8, 000 bytes.

Bit

Supported by the. NET Compact Framework.

Boolean

Unsigned numeric value, which can be a 0, 1, or null reference (Nothing in Visual Basic).

Char

Supported by the. NET Compact Framework.

String

A fixed-length stream of non-Unicode characters ranging from 1 to 8,000 characters.

Datetime

Supported by the. NET Compact Framework.

Datetime

Date and time data, values range from January 1, 1753 to December 31, 9999, with a precision of 3.33 milliseconds.

Decimal

Supported by the. NET Compact Framework.

Decimal

Fixed precision and number of decimal digits, between 1038-1 and 10 38-1.

Float

Supported by the. NET Compact Framework.

Double

-1.79e +308 to 1.79E +308 floating-point numbers in range.

Image

Supported by the. NET Compact Framework.

Array type is Byte

Variable-length stream of binary data, ranging from 0 to 231-1 (or 2,147,483,647) bytes.

Int

Supported by the. NET Compact Framework.

Int32

A 32-bit signed integer.

Money

Supported by the. NET Compact Framework.

Decimal

A currency value ranging from 263 (i.e. -922,337,203,685,477.5808) to 2 63-1 (i.e. +922,337,203,685,477.5807) with a precision of 10 per thousand monetary units.

NChar

Supported by the. NET Compact Framework.

String

A fixed-length stream of Unicode characters ranging from 1 to 4,000 characters.

NText

Supported by the. NET Compact Framework.

String

Variable-length stream of Unicode data with a maximum length of 230-1 (or 1,073,741,823) characters.

NVarChar

Supported by the. NET Compact Framework.

String

A variable-length stream of Unicode characters ranging from 1 to 4,000 characters.

Note If the string is greater than 4,000 characters, the implicit conversion fails. When using a string longer than 4,000 characters, explicitly set the object.

Real

Supported by the. NET Compact Framework.

Single

-3.40e +38 to 3.40E +38 floating-point numbers in range.

smalldatetime

Supported by the. NET Compact Framework.

Datetime

Date and time data, values range from January 1, 1900 to June 6, 2079, with a precision of 1 minutes.

SmallInt

Supported by the. NET Compact Framework.

Int16

A 16-bit signed integer.

SmallMoney

Supported by the. NET Compact Framework.

Decimal

A currency value ranging from -214,748.3648 to +214,748.3647, with a precision of 10 per thousand monetary units.

Text

Supported by the. NET Compact Framework.

String

Variable-length stream of non-Unicode data with a maximum length of 231-1 (or 2,147,483,647) characters.

Timestamp

Supported by the. NET Compact Framework.

Array type is Byte

The number of automatically generated binaries and guarantees that they are unique in the database. Timestamp is typically used as a mechanism for labeling the versions of rows in a table. The storage size is 8 bytes.

TinyInt

Supported by the. NET Compact Framework.

Byte

A 8-bit unsigned integer.

uniqueidentifier

Supported by the. NET Compact Framework.

Guid

A globally unique identifier (or GUID).

VarBinary

Supported by the. NET Compact Framework.

Array type is Byte

Variable-length stream of binary data, ranging from 1 to 8, 000 bytes.

Note If the byte array is greater than 8,000 bytes, the implicit conversion fails. When using a byte array that is larger than 8, 000 bytes, set the object explicitly.

VarChar

Supported by the. NET Compact Framework.

String

A variable-length stream of non-Unicode characters ranging from 1 to 8,000 characters.

Variant

Supported by the. NET Compact Framework.

Object

A special data type that can contain numeric, string, binary, or date data, as well as SQL Server values Empty and Null, followed by two values that are not declared with other types.