Any idea of Store and retrieve this tree structure in Microsoft Structured Query Language (sql) server. However I get manage to store data of each class as table, such as Root Table, Marriage Table, Spouse Table, Child Table, Extra Table. but problem occurred when I try to retrieve one root parent with Three children along with their wife(spouse), the last children wife(spouse) get attached to all children. I am using C# mvc code.
Has anybody use database to store and retrieve family tree, Please response.
Any idea of Store and retrieve this tree structure in Microsoft Structured Query Language (sql) server. However I get manage to store data of each class as table, such as Root Table, Marriage Table, Spouse Table, Child Table, Extra Table. but problem occurred when I try to retrieve one root parent with Three children along with their wife(spouse), the last children wife(spouse) get attached to all children. I am using C# mvc code. Has anybody use database to store and retrieve family tree, Please response.