I'm not sure how to proceed because any table that contains an ENUM (and I guess SET) can't be used. Sure you can use every column bar that those ones, but this isn't a good situation to be in.

I wondering if you could make sense to convert MySQL Enum or Set to type string? I envision ENUM would be plain old string and SET would be comma separated string.

At least this way you would work with tables which contain these types. I read awhile ago that Enum support in the EDM isn't planned until version 2, so a long way off. I guess SET (ENUM with flags) would be never.

Yeah I figure this would be a tuff one. May I suggest the conversion to a string type for the following reasons. When MS do implement Enum support you don't want be stuck supporting two implementations. An Enum can easily be converted to a string. You've already got support for an the string type.

Your suggestion is reasonable and it's likely we will stick to the idea,
because it is the most natural way.
Apparently, we will implement ENUMs in the next build which is planned to be release in tree - four weeks.

The ENUM and SET types are implemented and will be available in the next build.
By the way, if you have any more suggestions on the Entity Framework support, feel free to tell us, your help wil be appreciated.