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 | System.Data.Linq.Binary |
| ntext, text, nvarchar, varchar, nchar, char | System.String |
| ntext(1), text(1), nvarchar(1), varchar(1), nchar(1), char(1) | System.Char |