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

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.

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

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.

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

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