1
Vote

PowerTools Reverse engineer code first is not working when there is a filetable in the database

description

SQL 2012 has a new feature: fieltable
I have a database which has a filetable: tblFileTable

When i try to reverse engineer the code first model, i got the following error?

"One or more errors occurred while loading schema information.
error 6004: The table 'Development.dbo.tblFileTable' is referenced by a relationship, but cannot be found."

Filetables should be skipped by the code generator at least. As other unsupported objects. (e.g hierarchyid)

comments

moozzyk wrote Sep 13, 2013 at 3:27 PM

PowerTools uses System.Data.Entity.Design.dll which stops generating model when an error is encountered. The EF6 designer comments out the error.

RoMiller wrote Sep 16, 2013 at 6:15 PM

EF Team Triage: We have fixed this issue in the components that the EF6 Designer uses for reverse engineering. When we consolidate the Power Tools and main EF Tooling we can move the Power Tools to use the updated types. This is planned for the release after EF6.

RoMiller wrote Dec 12, 2013 at 8:33 PM

EF Team Triage: Moving issues with Impact set to Low out of the 6.1.0 release as we only have time to address High and Medium issues in this release. We will re-triage these issues for future releases.

This does not exclude someone outside of the Microsoft EF team from contributing the change/fix in 6.1.0.