Disabling Guids from CHAR(36) columns?

[Dan Guisinger]

We have a SugarCRM system that we inherited. I am trying to talk to the MySQL database via a .NET MVC4 app using either Entity Framework or ADO.NET.

The problem I am running into is who ever did the initial SugarCRM install initially had it setup to use integer IDs before switching over to GUIDs.

While a majority of the keys I run across are standard GUIDs, others are "1", "2", or even "" instead of NULL.

Since SugarCRM is so large, I don't want to change a key and track down all of the places it is referenced that also have to be changed.

Is there a way to stop Connector/NET from recognizing CHAR(36) as GUID?
I've tried to override by changing the entity properties it created to string, however that just throws compile time errors stating I have a mismatch.