Page Comparison

...

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 unterschiedlich
Decimal	decimal	decimal(29,4)
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	-

PostgreSql

MetaType	.Net Type	DB Type	Wertebereich
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)
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	-