I am developing extensions for an existing commercial sql server database and application.
I have to model the existing schema and create a separate model for the extension that refers to the objects in the existing schema.
I don't want to regenerate or alter the existing schema, so all the constraints pertaining to the whole system must be implemented in the extension schema only.
However, on the application side, whatever c# classes I generate from these two ORM's will refer to both the existing and extension databases.
I would like to know whether doing this is possible in the NORMA tool, and whether there are any pitfalls that I can avoid from the earliest stages of the project plan.
Any comments or suggestions are appreciated.
Thanks