Type mapping rules from this table are used when SQL Server Compact table columns are mapped to the entity properties of LinqConnect model.
| SQL Server Compact data type | CLR data type |
|---|---|
| int | System.Int32 |
| tinyint | System.Byte |
| smallint | System.Int16 |
| bit | System.Boolean |
| bigint | System.Int64 |
| float | System.Double |
| real | System.Single |
| decimal, numeric, money, smallmoney | System.Decimal |
| ntext, text, nvarchar, varchar, nchar, char | System.String |
| ntext(1), text(1), nvarchar(1), varchar(1), nchar(1), char(1) | System.Char |
| datetime, smalldatetime | System.DateTime |
| uniqueidentifier | System.Guid |
| varbinary, image, binary, timestamp | System.Bytes[] |