dotConnect for MySQL Documentation
In This Topic
    LinqConnect Data Type Mapping
    In This Topic

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