Type mapping rules from this table are used when generating a model from a database with Entity Data Model Wizard in Visual Studio 2008/2010/2012 and Create Model Wizard in Entity Developer.
Provider Data Type | SSDL1 | CSDL1 | .NET |
|---|---|---|---|
| BOOLEAN | boolean | Boolean | System.Boolean |
| INT | int | Int32 | System.Int32 |
| BYTE | byte | Byte | System.Byte |
| DOUBLE | double precision | Double | System.Double |
| DATE | date | DateTime | System.DateTime |
| TIME | time | Time | System.DateTime |
| DATETIME | datetime | DateTime | System.DateTime |
| STRING | string | String | System.String |
| BINARY | binary | Binary | System.Byte[] |
1 Applicable only to Entity Framework v1 - v6. Not applicable to Entity Framework Core, because Entity Framework Core does not support XML mapping.