Geek Answers Handbook

Handle Tiny Like Booleans and Entity Framework 4

I have a situation where I need to treat TINYINT in a MySQL database as a numeric value, and not as TRUE / FALSE.

From what I understand, the MySQL.Net Connector is used to display TINYINT as a byte. Unfortunately for me it seems that this is no longer the case, and now TINYINT maps to Boolean. I need TINYINT to be a byte, as before. I know that the connection string parameter "Treat Tiny As Boolean = False" should be used for this problem. For some reason this does not work when using the Entity Framework. Any ideas?

+5
source share
1 answer

, , DustinDavis, . , "Connection Tiny As Boolean = False" , edmx , " SSDL" " CSDL".

SSDL, "bool", "tinyint" CSDL, "Boolean", "SByte". "int" "Int32", ; , MySQL "SByte". , Access, -1/0 True/False. SByte.

+3

More articles:


All Articles