Can't see tables

Nov 11, 2012 at 12:53 PM

Hi, I am using a VFP8 database. I have installed the VFP EF provider. When I go to add a new item I can see all the tables in the dbc. When I select the tables I need, none of them appear in the designer.

For example, if I select update model from database. I then select a single small table (3 fields), nothing appears in the designer and there is a message that reads:

"Unable to generate the model because of the following exception: 'The item with identity 'Refno' already exists in the metadata collection.Parameter name: item"

Refno is the field that I use as a unique record ID, it is a character field. 

What am I doing wrong? Will this work with VFP8 data and can it handle character IDs?


Nov 11, 2012 at 10:17 PM

Could I get a copy of your data structure (no data... zapped tables) to use for debugging this issue?  If so, you can email me

Nov 12, 2012 at 1:55 AM

Thanks for sending me your data structure.  It helped me identify the problem.  I've posted an new build to fix this issue.