MySQL Connector/Net EF Database First Spatial Datatypes

Question

Using:

• Entity Framework 5
• MySQL Connector Net 6.8.4
• MySQL 5.6.21
• Visual Studio 2013
• MySQL Workbench 6.2

Created the following table in MySQL using the workbench

Opened my application in Visual Studio 2013, navigated to my data access layer project, opened the .edmx, right-clicked on the canvas and chose "Update model from database...". I proceeded to add the new table, clicked finish, and this is what got spit out:

As you can see all the spatial data types were just ignored.

The Data Access project include (among other things) the following references:

• EntityFramework
• MySql.Data
• MySql.Data.Entity.EF5
• MySql.Web
• System.Data.Entity

I realize that in EF they'll be of type DbGeometry, but I feel like the update process should be able to figure this out for itself. And while I could manually add the mappings, I would prefer not to since they would get blown away next time someone runs the "Update model from database..."

Any insights or suggestions? Thanks!

Edit: Tested with Entity Framework 6 and continued to have the issue

Answer 1

Looking at the Error List Warnings after attempting an "Update Model from Database" I now see:

Error 6005: The data type 'geometry' is currently not supported for the target Entity Framework version; the column 'test_geometry' in the table 'def.spatialdb.routegeometry' was excluded.

This is using latest Entity Framework 6, so I guess it's not possible using code-first only.

Possible solution would be to edit the auto-generated classes to add the DBGeometry properties, but those would get blown away every time the model is updated.