Type mapping rules from this table are used when SQL Server table columns are mapped to the entity properties of LinqConnect model.
| SQL Server data type | CLR data type |
|---|---|
| bit | System.Boolean |
| tinyint | System.Byte |
| smallint | System.Int16 |
| int | System.Int32 |
| bigint | System.Int64 |
| real | System.Single |
| float | System.Double |
| 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 |
| smalldatetime, datetime | System.DateTime |
| image, binary, varbinary, timestamp | System.Byte[] |
| uniqueidentifier | System.Guid |