Can't see tables

Nov 11, 2012 at 11:53 AM

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?

Thanks.

Coordinator
Nov 11, 2012 at 9: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 tombrothers@outlook.com.

Coordinator
Nov 12, 2012 at 12: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.