SQL Server to Entity Framework data type mapping

Question

SQL Server to Entity Framework data type mapping

.net asp.net c# entity-framework sql-server

Question

I need to know the equivalent SQL Server data types for EF. I found 2 similar online references, but their definitions appear inconsistent. Which reference should I refer to if I'm using Entity Framework?

1) Data Type Mappings in ADO.NET

http://msdn.microsoft.com/en-us/library/cc716729%28v=vs.110%29.aspx

2) SQL Server Data Types in the .NET Framework

http://msdn.microsoft.com/en-us/library/ms131092.aspx

Blastercloud

View more on Stack Overflow

Heinzi · Accepted Answer · 7/27/2016 10:02:33 AM

Neither of those.

Entity Framework maps SQL Server data types to conceptual model types ("Edm types"). The mapping can be found here:

SqlClient for Entity FrameworkTypes

Edm types in turn translate to .NET types in a straightforward way (Boolean -> Boolean, Int32 -> Int32, Binary -> Byte array, etc.) and can be found in the reference code:

Source for PrimitiveType.ClrEquivalentType

SQL Server to Entity Framework data type mapping

Question

Fastest Entity Framework Extensions

Popular Answer

Performance

Expression Evaluator

Related