This is a migrated thread and some comments may be shown as answers.

Field to Column Mapping in Reverse Wizard

2 Answers 53 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Ben
Top achievements
Rank 1
Ben asked on 18 May 2009, 04:28 AM
A picture is worth a thousand words. Too bad I can't embed one in this forum post. Please have a look at this screen capture I threw up on imageshack.

I'm not a long time user of OpenAccess. I just installed it a few days ago. I may very well be doing something wrong. I'm trying to create classes using the reverse engineering wizard for three tables. As shown in the screen cap, I have the phones table, the sipaccounts table, and the phonetoaccount table that joins them together. I'm pretty sure I understand how to use the wizard to create the classes. I just think the wizard is failing to do something that it should.

Shouldn't I be able to type a column name in the "Field to Column Mapping" section and have it generate some mapping xml? Also, shouldn't what I type in there *stay put* and be there when I come back into the wizard? I can enter the appropriate mapping information, click Generate & Save Config, and the wizard regenerates the class files and closes. When I go back into the wizard, the "Field to Column Mapping" information is gone.

I was able to work around this by manually editing the mapping xml, but I would like to confirm whether I am correct in assuming this is where and how the mapping information needs to be set.

Also, the following forum post suggests the same problem, but was never followed through to resolution.
http://www.telerik.com/community/forums/orm/general-discussions/one-to-one-relationships.aspx

Thanks,
Ben Holtsclaw

2 Answers, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 18 May 2009, 09:57 AM
Hello Ben,

 The behavior you describe was a regression in an earlier version which has been fixed. Referring to your image, you should see a combo-box in the 'Column' column where you can select a table column and should not have to manually type in stuff there.

This fix is available as an internal build for customers.

You can try the following as a workaround :

1.     Please select the tree node for the column that you want to specify in the grid. You can see the full column name on the right hand panel. For example in the phonetoaccount.AccountId table the column : AccountId INTEGER

2.     You should specify the value in the exact same format so that the reference is stored and retrieved when you save the mapping.

3.     Please note that there are 2 spaces between the column name and its type.


 Hope this helps.

Sincerely yours,
Ady
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Ady
Telerik team
answered on 18 May 2009, 10:03 AM
Hello Ben,

 I am not sure whether my previous reply was posted completely. I guess not, due to an internal error. Here is the workaround again
  1. Please select the tree node for the column that you want to specify in the grid. You can see the full column name on the right hand panel. For example in the phonetoaccount.AccountId table the column : AccountId INTEGER
  2. You should specify the value in the exact same format so that the reference is stored and retrieved when you save the mapping.
  3. Please note that there are 2 spaces between the column name and its type.

Greetings,
Ady
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
General Discussions
Asked by
Ben
Top achievements
Rank 1
Answers by
Ady
Telerik team
Share this question
or