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 name Entity framework Type name
bit Edm.Boolean
tinyint Edm.Byte
smallint Edm.Int16
int Edm.Int32
bigint Edm.Int64
float Edm.Double
real Edm.Double
decimal Edm.Decimal
numeric Edm.Decimal
smallmoney Edm.Decimal
money Edm.Decimal
binary Edm.Binary
varbinary Edm.Binary
varbinary(max)
(Not supported in SQL Server 2000)
Edm.Binary
image Edm.Binary
timestamp Edm.Binary
rowversion Edm.Binary
smalldatetime Edm.DateTime
datetime Edm.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
char Edm.String
nchar Edm.String
varchar(max) Edm.String
nvarchar(max) Edm.String
ntext Edm.String
text Edm.String
Unique
identifier
Edm.Guid
xml Edm.String