Under Construction
GenWise supports several legacy scenarios:
 | Supports Composite Primary Keys |
| Supports foreign primary keys |
Composite Foreign Keys
If you have two foreign keys that are composite and that they share a column then you have a problem. This case is not easy to map in NHibernate and the current version (RC3) of the Template cannot handle it.
Example:
Project -> ProjectID
Project_Version --> ProjectID + VersionID
ErrorReport
--> ProjectID (related to Project)
--> ProjectID + VersionID (related to Project_Version)
As you can see, the class ErrorReport needs to use the Column ProjectID 2 times and therefore the generated mapping XML will be invalid (repeated column..)
For this case we are currently showing a validation error.
See also
If your legacy database is missing keys and/or relations required by the NHibernate Templates, this may be resolved by Adding virtual keys and relations in the Database Repository.