Hi Pavel,
Thanks for the reply. I saw that sample on you web site but I don't want to generate the ER diagram dynamically rather user go and manually do the drag and drop the tables on the Nevron canvas and maps the fields individually.
For example,
Database A has Patient table (fields such as Id, Firstname, Lastname, Address1, Address2) and Database B also has PatientDemographic table (fields such as PatientId, Firstname, Surname, AddressOne, AddressTwo) with different field names. I need to transfer the records from Patient (Database A) table to PatientDemographic (Database B) table. So using Nevron, user needs to visually drag Patient table from Database A and PatientDemographic from Database B, then map field by field using Nevron connectors (say Patient.Id is mapped with PatientDemographic.PatientId, Patient.Firstname is mapped with PatientDemographic.Firstname, Patient.Lastname is mapped with PatientDemographic.Surname ct.). After finished the mapping, user will click save button, I need to programatically go through the Nevron shapes and find out which field is mapped which field then save the results into database.
So this is my requirement. Please give a right direction.
Regards
Montford Anslum
Hi Montford,
If you use the database schema importer it will automatically create diagram shapes (of type NErmShape) for the tables and connect them based on their relationships. For an example of how to use the database schema importer take a look at this online example.
Questions or comments, please let me know.
Best Regards,Pavel Vladov
Hi,
I have a tree control and that contains two databases with tables as tree nodes. I have a requirement to drag couple of tables from these databases (from tree) and drop on them as Nevron shape on Nevron canvas. What is the recommended shape you suggest? (I need to display table columns and data type and PK/FK relation text)
After drag and drop of these tables, I need to visually map the fields between tables using Nevron connectors, what type of connector shape can I use?
After mapping the fields visually, I need to identify the mapping relationship (which field is mapped with which field between table shapes) by .NET code in the diagram. How can I do this?
Please suggest me the recommended shapes and methodology. I have tried couple of shapes (NErmShape and NTableShape) I could not find out the mapping relationship.
Thanks in advance.