LinqConnect Documentation
Data Type Mapping

Type mapping rules from this table are used when MySQL Server table columns are mapped to the entity properties of LinqConnect model.

MySQL data type CLR data type
tinyint System.Byte
smallint, year System.Int16
tinyint unsigned, int, integer, mediumint, smallint unsigned System.Int32
int unsigned, bigint, long, bit System.Int64
real, float System.Single
bit(1) System.Boolean
double, double precision System.Double
bigint unsigned, numeric, decimal, dec, fixed System.Decimal
varchar, varcharacter, char, test, char varying, character, character varying, longtext, mediumtext, national char, nchar, text, tinytext, set, enum, binary, varbinary, json System.String
date, datetime, timestamp System.DateTime
time System.TimeSpan
tinyblob, blob, mediumblob, longblob System.Byte[]