Data Type Mappings

SQLite type	.NET type	Remarks
INTEGER	Boolean	0 or 1
INTEGER	Byte
BLOB	Byte[]
INTEGER	Char	TEXT also supported
TEXT	DateTime	REAL (Julian day value) also supported
TEXT	DateTimeOffset	REAL also supported
TEXT	Decimal
REAL	Double
BLOB	Guid	TEXT also supported
INTEGER	Int16
INTEGER	Int32
INTEGER	Int64
INTEGER	SByte
REAL	Single
TEXT	String
TEXT	TimeSpan	REAL (days) also supported
INTEGER	UInt16
INTEGER	UInt32
INTEGER	UInt64	Via Int64 conversion