Page 1 of 1

Pattern in prefix between column and property names

Posted: Fri 03 Jun 2011 10:46
by bruno92300
Is it possible to use a pattern toi define the prefix in the mapping between names during update process?

I hope to map column of table to property of entity like this:

Table = customer
Entity = Customer
Columns / properties mappings:
cust_id ==> Id
cust_name ==> Name

And for another table/entity:

Table = invoice
Entity = Invoice
Columns / properties mappings:
inv_id ==> Id
inv_date_send ==> DateSend

I found the options to capitalize first letter, to suppress underscore, but not to suppress the first part of the column name.

I'm using the free version for now.

Thanks

Bruno

Posted: Fri 03 Jun 2011 12:12
by AndreyR
Go to Model Settings->Synchronization->Model Naming, and provide the list of prefixes to be removed in the Remove prefix(es) text box separated by semicolon, for example cust;inv.

Posted: Fri 03 Jun 2011 13:37
by bruno92300
Thanks for info about ';' possibility. But I have 150 tables and 150 different prefixes :D I hope a solution like '*_' or aquivalent in regex

Posted: Fri 03 Jun 2011 15:02
by AndreyR
We will investigate the possibility to add this functionality.
I will let you know about the results of our investigation.