Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Quino resp. ECUI unterstützt die folgenden Datenbanken vollständig (Model- und DB-First):

  • MS SQL Server ab Version 2008 (besser neuer)

  • PostgreSQL Server ab Version 10

und die folgende Datenbank kann für DB-First Atlas Modelle 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

-

  • No labels