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[] |