I need MySQL datatypes mapping to .net (CLR) datatypes

Question

Does anyone have a complete table of MySQL datatypes mapping to .Net (CLR) datatypes. There are question on the same topic on StackOverflow but the information given is inconsistent rather useless.

wonea · Accepted Answer · 2015-09-02 16:50:50Z

3

Here is a mapping to Java types, it is easy to convert this to .NET mapping...

http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html

edited Sep 2, 2015 at 16:50

wonea

4,99917 gold badges91 silver badges144 bronze badges

answered Mar 9, 2011 at 9:42

Tobias Schittkowski

2,2612 gold badges16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

grizzly · Accepted Answer · 2011-03-09 09:43:31Z

1

Just a tip: You may easily create the mapping table by creating a MySql table with MySqltyped columns and then retrieving it from the .net provider. Then just introspect the .net type (in the DataReader or DataTable) of the column.

answered Mar 9, 2011 at 9:43

grizzly

1,1561 gold badge13 silver badges28 bronze badges

Comments

MrCalvin · Accepted Answer · 2016-01-25 22:34:11Z

0

I found this mapping, seems to be from 2013 (blogspot.dk)

mapping

And I can add that MySql tinyint(1) is mapped automatically to boolean in .Net

edited Jan 25, 2016 at 22:34

answered Jan 25, 2016 at 22:27

MrCalvin

1,8591 gold badge21 silver badges33 bronze badges

Collectives™ on Stack Overflow

I need MySQL datatypes mapping to .net (CLR) datatypes

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related