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 |