See table: Type mapping between Entity framework and SqlClient types

When you use the ADO.Net Entity Data Model wizard to creating the model from the SQL Server database, wizard maps the SQL Server types according to following table:

SQL Server to Entity framework type mapping:

Sql Server type nameEntity framework Type name
bitEdm.Boolean
tinyintEdm.Byte
smallintEdm.Int16
intEdm.Int32
bigintEdm.Int64
floatEdm.Double
realEdm.Double
decimalEdm.Decimal
numericEdm.Decimal
smallmoneyEdm.Decimal
moneyEdm.Decimal
binaryEdm.Binary
varbinaryEdm.Binary
varbinary(max)
(Not supported in SQL Server 2000)
Edm.Binary
imageEdm.Binary
timestampEdm.Binary
rowversionEdm.Binary
smalldatetimeEdm.DateTime
datetimeEdm.DateTime
date
(Not supported in  SQL Server 2000, 2005)
Edm.DateTime
time
(Not supported in SQL Server 2000, 2005)
Edm.Time
datetime2
(Not supported in  SQL Server 2000, 2005)
Edm.DateTime
datetimeoffset
(Not supported in SQL Server 2000, 2005)
Edm.DateTimeOffset
nvarchar
(Not supported in SQL Server 2000)
Edm.String
varchar
(Not supported in SQL Server 2000)
Edm.String
charEdm.String
ncharEdm.String
varchar(max)Edm.String
nvarchar(max)Edm.String
ntextEdm.String
textEdm.String
Unique
identifier
Edm.Guid
xmlEdm.String