Data type mapping
- Last UpdatedFeb 12, 2024
- 1 minute read
The following table lists the conversion of BI Gateway model field types into .NET data types and from .NET data types into SQL data types in the datastore.
|
Field type in BI Gateway model |
.NET data type |
SQL data type |
|---|---|---|
|
Boolean |
System.Boolean |
[bit] |
|
Int16 |
System.Int16 |
[smallint] |
|
Int32 |
System.Int32 |
[int] |
|
Decimal |
System.Decimal |
[decimal](18, 0) |
|
Int64 |
System.Int64 |
[bigint] |
|
Float (not supported) |
[real] |
|
|
Guid |
System.Guid |
[uniqueidentifier] |
|
Double |
System.Double |
[float] |
|
String |
System.String |
[nvarchar](4000) |
|
DateTime |
System.DateTime |
[datetime2] (7) |
|
Byte |
System.Byte |
[tinyint] |
|
System.Byte[] |
[varbinary](max) |
|
|
Other |
SQLVariant |