AdFactum ObjectMapper .NET Blog

Official blog of the AdFactum ObjectMapper .NET

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.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>