It seems that if you create a LinqConnect Model (.lqml) and set the Connection String parameter "Tiny As Boolean=True", it does not have the desired effect, rather the contrary.
In the XXXDataContext.Designer.cs tinyint columns are mapped as BOOLEAN which gives an error "Invalid Datatype: BOOLEAN" when trying to save entities to database.
Example from XXXXDataContext.Designer.cs:
Code: Select all
[Column(Storage = "_AllowOrderDiscount", CanBeNull = false, DbType = "BOOLEAN NOT NULL")]
Should have been:
Code: Select all
[Column(Storage = "_AllowOrderDiscount", CanBeNull = false, DbType = "TINYINT(3) NOT NULL")]
So, in fact, NOT setting the Connection String parameter "Tiny As Boolean=True" is the solution that seems to work.
I don't know if it is caused by your new datatype mapping options under Tools -> Entity Developer -> Options -> Server Options, where mappings are now specified, but I wanted to bring this to your attention in case you haven't noticed that this is a problem.
In fact the Connection String parameter "Tiny As Boolean=True" works fine with Entity Models (.edml).
I am currently on dotConnect for MySql Professional version 6.60.258.0.