|
Data type in SQL Server |
Data type in C# models |
Data type returned by PowerServer on SyntaxFromSQL |
|
bigint |
long |
decimal |
|
binary |
blob |
blob |
|
bit |
bool |
number |
|
char |
string |
char |
|
date |
datetime |
date |
|
datetime |
datetime |
datetime |
|
datetime2(7) |
datetime |
datetime |
|
datetimeoffset(7) |
DateTimeOffset |
char |
|
decimal(18, 2) |
decimal |
decimal |
|
float |
double |
number |
|
geography |
blob |
blob |
|
geometry |
blob |
blob |
|
hierarchyid |
blob |
blob |
|
image |
Blob |
|
|
int |
int |
long |
|
money |
decimal |
decimal |
|
nchar |
string |
char |
|
ntext |
string |
char |
|
numeric(18, 2) |
decimal |
decimal |
|
nvarchar |
string |
char |
|
real |
Single |
real |
|
smalldatetime |
DateTime |
datetime |
|
smallint |
short |
long |
|
smallmoney |
decimal |
decimal |
|
sql_variant |
object |
char |
|
text |
string |
char(32766) |
|
time(7) |
TimeSpan |
time |
|
timestamp |
byte[] |
timestamp |
|
tinyint |
byte |
long |
|
uniqueidentifier |
Guid |
char |
|
varbinary |
blob |
blob |
|
varchar |
string |
char |
|
xml |
string |
char(32766) |
