Quino resp. ECUI unterstützt die folgenden Datenbanken vollständig (im Model- und DB-First )Modus:
MS SQL Server ab Version 2008 (besser neuer)
PostgreSQL Server ab Version 10
und die folgende Datenbank kann für DB-First Atlas 1 Modelle mit altem oder neuem Metadaten-Fomat verwendet werden:
SQL Anywhere
Mapping von Datentypen
MS SQL Server
...
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 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
...
-
PostgreSql
...
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
...
-
...
ab Version 17 (ältere Versionen nicht getestet)
Weitere Details sind im Entwicklerbereich dokumentiert: Datenbanken