...
MetaType | .Net Type | DB Type | Wertebereich | Bemerkungen |
|---|---|---|---|---|
Boolean | bool | bit | false / true | |
TinyInteger | byte | tinyint | 0..255 | |
SmallInteger | short | smallint | -32,768 to 32,767 | |
Integer | int | int | -2,147,483,648 to 2,147,483,647 | |
LargeInteger | long | bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | |
Double | double | float | Max-Werte von .Net und DB MS SQL unterschiedlich | |
Decimal | decimal | decimal(29,4) | War “decimal(33,4)” vor 10.0 Final | |
Date | DateTime | date | ||
Time | DateTime | time(7) | ||
DateTime | DateTime | datetime2(7) | ||
TimeSpan | TimeSpan | bigint | ||
Text | string | nvarchar(n) | - | |
Binary | byte[] | varbinary(n) | - | |
Stream | Stream | varbinary(n) | - | |
Guid | Guid | unqiueidentifier | - |
...
MetaType | .Net Type | DB Type | Wertebereich | Bemerkungen |
|---|---|---|---|---|
Boolean | bool | boolean | false / true | |
TinyInteger | byte | smallint | 0..255 | |
SmallInteger | short | smallint | -32,768 to 32,767 | |
Integer | int | integer | -2,147,483,648 to 2,147,483,647 | |
LargeInteger | long | bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | |
Double | double | double precision | ||
Decimal | decimal | decimal(29,4) | War “decimal” vor 10.0 Final | |
Date | DateTime | date | ||
Time | DateTime | time without time zone | ||
DateTime | DateTime | timestamp without time zone | ||
TimeSpan | TimeSpan | interval | ||
Text | string | character varying | - | |
Binary | byte[] | bytea | - | |
Stream | Stream | bytea | - | |
Guid | Guid | uuid | - | War “bpchar” vor 10.0 Final |