|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
about Datatable and relationsI make a little words indexer (search engine like), without a SQL server. So I'm using Datatable to store data. The schema is like: table Words + WORD + IID table WordsIndex + WORDS_IID + NOTES_IID table Notes + IID + TEXT Relations are like : Words => WordsIndex <= Notes I've read in the documentation that I can only use the "parent" function to select data with method DataTable.Select(). Function 'child' is not available for select, only for aggregation. So, is the only solution is to make cascading foreach() using DataTable.GetChildRows() and GetParentRows() ??? How to manage cascading many-to-many relations with DataTables ? Hope to be clear enough ;o) Thanks, Cyrille. |
|||||||||||||||||||||||