Type mapping rules from this table are used when SQLite table columns are mapped to the entity properties of LinqConnect model.
| SQLite data type | CLR data type | 
|---|---|
| tinyint | System.Byte | 
| bool, bit | System.Boolean | 
| int(2), integer(2), smallint, int16, smallint | System.Int16 | 
| int32 | System.Int32 | 
| decimal, numeric | System.Decimal | 
| int(8), integer(8), int64, bigint, | System.Int64 | 
| double, float | System.Double | 
| decimal | System.Double | 
| real | System.Single | 
| date, time, timestamp, datetime | System.DateTime | 
| image, blob | Devart.Data.Linq.Binary | 
| guid | System.Guid | 
| ntext, text, nvarchar, varchar, nchar, char | System.String | 
| ntext(1), text(1), nvarchar(1), varchar(1), nchar(1), char(1) | System.Char |