Mapping Bool mysql data types

jallderidge · Post by **jallderidge** » Tue 25 Nov 2008 16:39

There appears to be an issue when mapping mysql bool ( tinyint(1) ) data types. The following error is displayed in visual studio when compiling the model:

Code: Select all

Error	1	Error 2019: Member Mapping specified is not valid. The type 'Edm.Boolean[Nullable=False,DefaultValue=False]' of member 'IsPhysical' in type 'VisuLiveContext.Dashboard' is not compatible with 'Devart.Data.MySql.sbyte[Nullable=False,DefaultValue=]' of member 'IsPhysical'

Is there any way of having a code boolean property?

AndreyR · Post by **AndreyR** » Wed 26 Nov 2008 09:44

For proper work of mapping tinyint(1) to boolean you should manually (with XML Editor) edit the type of property in both SSDL and CSDL contents of the .edmx file, like in the following example:

Code: Select all

...

...
        
...
          
...
        
...

...
        
...
          
...

jallderidge · Post by **jallderidge** » Fri 28 Nov 2008 10:06

Thanks, that works.

The only issue is that each time the model is updated in Visual Studio the mapping is changed back to sbyte.

Is there a plan to add a converter for sbyte to boolean so that the manual fix isn't required?

AndreyR · Post by **AndreyR** » Fri 28 Nov 2008 10:34

We plan to solve this and similar mapping problems, but no details or timeframe can be provided at the moment.

Miros · Post by **Miros** » Tue 21 Jun 2011 11:27

AndreyR wrote:We plan to solve this and similar mapping problems, but no details or timeframe can be provided at the moment.

Has this been solved, and if so, how do I go about setting it up?

AndreyR · Post by **AndreyR** » Tue 21 Jun 2011 13:06

We have added Devart Entity model Visual Studio Item Template. It is edited in Entity Developer for dotConnect.
The Update from Database wizard for Devart Entity models does not influence the properties of the entities that were not selected in the wizard, so the type will persist. The Professional and Developer editions of dotConnect for MySQL contain Entity Developer for dotConnect.

Miros · Post by **Miros** » Tue 21 Jun 2011 14:47

AndreyR wrote:We have added Devart Entity model Visual Studio Item Template. It is edited in Entity Developer for dotConnect.
The Update from Database wizard for Devart Entity models does not influence the properties of the entities that were not selected in the wizard, so the type will persist. The Professional and Developer editions of dotConnect for MySQL contain Entity Developer for dotConnect.

Sorry, maybe I am slow here, but is it possible to setup generally for the entire model that tinyint(1) should be converted to System.Boolean?

I have looked many places, but cannot find it...

And by the way I have the Professional edition...

AndreyR · Post by **AndreyR** » Wed 22 Jun 2011 13:20

We are investigating whether it is possible to add some functionality, so that TinyInt properties can be added as Boolean properties in Entity Developer.
I will let you know about the results of our investigation.

Miros · Post by **Miros** » Wed 22 Jun 2011 13:25

AndreyR wrote:We are investigating whether it is possible to add some functionality, so that TinyInt properties can be added as Boolean properties in Entity Developer.
I will let you know about the results of our investigation.

OK, Maybe as a part of your brilliant wizard, it would be nice to be able to "override" standards for type mappings...

Miros · Post by **Miros** » Fri 09 Sep 2011 21:30

I keep running into this thing, is there any news on how to map tinyint columns to bool datatype?

Shalex · Post by **Shalex** » Tue 13 Sep 2011 13:18

The TINYINT(1) to Boolean mapping in Entity Data Model Wizard/Update From Database Wizard when connection string includes "Tiny As Boolean=true;" is supported starting from the 6.30.196 version (28-Jul-2011) of dotConnect for MySQL. We recommend you to upgrade to the latest (6.50.214) version.

Miros · Post by **Miros** » Wed 14 Sep 2011 07:35

Shalex wrote:The TINYINT(1) to Boolean mapping in Entity Data Model Wizard/Update From Database Wizard when connection string includes "Tiny As Boolean=true;" is supported starting from the 6.30.196 version (28-Jul-2011) of dotConnect for MySQL. We recommend you to upgrade to the latest (6.50.214) version.

Sounds good, I will try it right away.

Miros · Post by **Miros** » Wed 14 Sep 2011 09:25

Shalex wrote:The TINYINT(1) to Boolean mapping in Entity Data Model Wizard/Update From Database Wizard when connection string includes "Tiny As Boolean=true;" is supported starting from the 6.30.196 version (28-Jul-2011) of dotConnect for MySQL. We recommend you to upgrade to the latest (6.50.214) version.

Hi again, I've made a small test, but I get the exception "Invalid datatype: BOOLEAN" when querying the database...

It seems that the tinyint is converted to an object, not a "real" boolean...?

Shalex · Post by **Shalex** » Tue 20 Sep 2011 15:27

I have checked the 6.50.214 version of dotConnect for MySQL: boolean values are inserted to the database and retrieved back via my ObjectConext descendant successfully.

1. Please specify your current version (x.xx.xxx) of dotConnect for MySQL. You can find it in the Tools > MySQL > About menu of Visual Studio.
2. Send us a small test project with the corresponding DDL/DML script to reproduce the problem in our environment.

Miros · Post by **Miros** » Tue 27 Sep 2011 09:50

Shalex wrote:The TINYINT(1) to Boolean mapping in Entity Data Model Wizard/Update From Database Wizard when connection string includes "Tiny As Boolean=true;" is supported starting from the 6.30.196 version (28-Jul-2011) of dotConnect for MySQL. We recommend you to upgrade to the latest (6.50.214) version.

Is it possible to add a property to the connection string, making table names capitalized in the Entity Data Model (.edmx) - like in the wizard for the LinqConnect Model?

Devart Forums

Mapping Bool mysql data types

Mapping Bool mysql data types

Changes lost when model updated in Visual Studio

Any news on this?