dbForge Fusion for MySQL 4.50.304.0
When I use the Entity Developer Create Model Wizard to create EDML, all bit(1) fields are mapped as bigint values. The Entity Framework Data Type Mapping documentation says these should be boolean which should translate to System.Boolean. There doesn't appear to be a place in the wizard to change data types, but why is this happening, and how can I change it? It doesn't make sense to change my boolean values to long in my C# code.
Should I go back to using .edmx (ADO.NET data classes)? The Devart Entity Model seems to be buggy. Is it because I'm using a beta? How can I upgrade?
Thanks in advance!
Update
The correct data types are generated when I create a LinqConnect model. I haven't used this model before, but it breaks my foreign key relationships. e.g. I can't use code like:
Code: Select all
Staff.Role.RoleName == "CustomerService"