Supported Data Types
Posted by Gerhard Stephan on July 4th, 2007
The AdFactum ObjectMapper .NET supports most Data Types that are available when using the Microsoft .NET Framework. For a better overview how data types are mapped against the different database types, the following tables shows the mapping details.
| Oracle | ||
| System.Boolean | NUMBER(1,0) DEFAULT 0 NOT NULL | |
| System.Byte | NUMBER(3) | |
| System.DateTime | DATE | |
| System.Decimal | NUMBER(*,12) | |
| System.Double | FLOAT({0}) | |
| System.Guid | RAW(16) | |
| System.Int16 | NUMBER(6) | |
| System.Int32 | INTEGER | |
| System.Int64 | INTEGER | |
| System.Single | FLOAT({0}) | |
| System.String | VARCHAR2({0}) | |
| System.TimeSpan | DATE | |
| System.Enum | NUMBER(4) DEFAULT -1 NOT NULL | |
| System.IO.Stream | BLOB | |
| System.Byte[] | BLOB | |
| System.Char | CHAR(1) | |
| Special case for unlimited string length | CLOB | |
| Microsoft SQL Server | ||
| System.Boolean | BIT DEFAULT 0 NOT NULL | |
| System.Byte | TINYINT | |
| System.DateTime | DATETIME | |
| System.Decimal | DECIMAL(28,12) | |
| System.Double | FLOAT | |
| System.Guid | UNIQUEIDENTIFIER | |
| System.Int16 | SMALLINT | |
| System.Int32 | INT | |
| System.Int64 | BIGINT | |
| System.Single | REAL | |
| System.String | VARCHAR({0}) | |
| System.TimeSpan | BIGINT | |
| System.Enum | SMALLINT NOT NULL | |
| System.IO.Stream | IMAGE | |
| System.Byte[] | IMAGE | |
| System.Char | CHAR(1) | |
| Special case for unlimited string length | TEXT | |
| Microsoft SQL Server CE | ||
| System.Boolean | BIT DEFAULT 0 NOT NULL | |
| System.Byte | TINYINT | |
| System.DateTime | DATETIME | |
| System.Decimal | FLOAT | |
| System.Double | FLOAT | |
| System.Guid | UNIQUEIDENTIFIER | |
| System.Int16 | SMALLINT | |
| System.Int32 | INT | |
| System.Int64 | BIGINT | |
| System.Single | REAL | |
| System.String | NVARCHAR({0}) | |
| System.TimeSpan | BIGINT | |
| System.Enum | SMALLINT NOT NULL | |
| System.IO.Stream | IMAGE | |
| System.Byte[] | IMAGE | |
| System.Char | NCHAR(1) | |
| Special case for unlimited string length | NTEXT | |
| Microsoft Access | ||
| System.Boolean | BIT DEFAULT 0 NOT NULL | |
| System.Byte | BYTE | |
| System.DateTime | DATETIME | |
| System.Decimal | DOUBLE | |
| System.Double | DOUBLE | |
| System.Guid | GUID | |
| System.Int16 | SMALLINT | |
| System.Int32 | INT | |
| System.Int64 | LONG | |
| System.Single | SINGLE | |
| System.String | VARCHAR({0}) | |
| System.TimeSpan | DATETIME | |
| System.Enum | SMALLINT NOT NULL | |
| System.IO.Stream | IMAGE | |
| System.Byte[] | IMAGE | |
| System.Char | CHAR(1) | |
| Special case for unlimited string length | MEMO | |
{0} = Replacement for the column length specified by the attribute PropertyLength.
(No Ratings Yet)
Loading ...