Database Type Mapping

SQL Server Type C# Type
bigint long
binary byte[]
bit bool
char string
date DateTime
datetime DateTime
datetime2 DateTime
datetimeoffset DateTimeOffset
decimal decimal
float double
image byte[]
int int
money decimal
nchar string
ntext string
numeric decimal
nvarchar string
real float
smalldatetime DateTime
smallint short
smallmoney decimal
sql_variant object
text string
time TimeSpan
tinyint byte
uniqueidentifier Guid
varbinary byte[]
varchar string
xml string
PostgreSQL Type C# Type
bigint long
bigserial long
bit BitArray
boolean bool
box string
bytea byte[]
char string
cidr string
circle string
date DateTime
decimal decimal
double precision double
inet string
integer int
interval TimeSpan
json string
jsonb string
line string
lseg string
macaddr string
money decimal
numeric decimal
path string
pg_lsn string
point string
polygon string
real float
serial int
smallint short
smallserial short
text string
time TimeSpan
timestamp DateTime
tsquery string
tsvector string
uuid Guid
varbit BitArray
varchar string
xml string
MySQL Type C# Type
bigint long
binary byte[]
bit bool
blob byte[]
bool bool
boolean bool
char string
date DateTime
datetime DateTime
decimal decimal
double double
enum string
float float
geometry string
geometrycollection string
int int
json string
linestring string
longblob byte[]
longtext string
mediumblob byte[]
mediumint int
mediumtext string
multilinestring string
multipoint string
multipolygon string
numeric decimal
point string
polygon string
real float
set string
smallint short
text string
time TimeSpan
timestamp DateTime
tinyblob byte[]
tinyint byte
tinytext string
varbinary byte[]
varchar string
year int
Oracle Type C# Type
bfile byte[]
binary_double double
binary_float float
blob byte[]
char string
clob string
date DateTime
decimal decimal
double precision double
float double
interval day to second TimeSpan
interval year to month int
long string
long raw byte[]
nclob string
nchar string
number decimal
nvarchar2 string
raw byte[]
real float
rowid string
timestamp DateTime
timestamp with local time zone DateTime
timestamp with time zone DateTimeOffset
urowid string
varchar2 string
xmltype string