Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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

...

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)

...

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