views:

56

answers:

0

Sqlmetal creates "embedded" properties for any foreign key it finds for table. Nice. The problem is when I have several foreign keys which refers to the same (foreign) table.

This I like:

FK_Company_Post

then I can write in code:

company.Post

But this I don't like -- cutting suffixes:

FK_Company_Post_HQ
FK_Company_Post_Mailing

then I have such code:

company.Post  // refers to Post_HQ
company.Post_Mailing

The second one is 100% clear, but the first one is not.

Question How to preserve full names (suffixes) of foreign keys, so for the first foreign key the ending would not be cut off. I.e. how to force sqlmetal to preserve the names?

Thank you in advance.