Hello!
For a fairly complex (imho) job of making an XML data file fit into
our SQL database I'm using Rhino ETL for a couple of days and it's
been just wonderful, but I'm running into more complex types to import
now and I'm kind of stuck!
The situation is like this:
The XML object (Course) contains several instances of another object
(Theme) like this:
<Course>
<Themes>
<Theme />
<Theme />
<Theme />
</Themes>
</Course>
This is oversimplified of course but you get the idea.
Now Course has it's own table in the database, as does Theme. To link
them together we have a seperate table that just contains the keys to
the Course and the Theme.
Is there an easy way to fill this this linking table with Rhino ETL?
The solution I'm using now is just using a new EtlProcess with it's
own operation to read from the XML and the SqlBulkInsertOperation. But
this means I'm looping over all the Courses once to fill the Course
table itself, and then again for the Themes. And if it was just the
Themes it wouldn't be that big a deal, but there are 11 objects in
total linked to Course in this way (one Course, many objects). And
there are other objects like Course with some one-to-many
relationships too.
There has to be a better way to get this done?
Thank you!
Dirk
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en.
