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 | System.String |
date, datetime, timestamp | System.DateTime |
time | System.TimeSpan |
tinyblob, blob, mediumblob, longblob | System.Byte[] |