Joerg wrote:
Hi,
I wonder if somebody can help me decide on the following:
I have a hierarchy of objects. I want to serialize the complete hierarchy for a particualr entity of the top object. I then want to take that XML file, take it to another machine, and import it into an entity hierarchy, and then save the top most entity and all its related collections to the database - effectively importing a whole bunch of data. Some data will be new, other data will already by there.
A few questions:
Is this possible with the serialization stuff in LLBLGEN?
yes, both binary/soap serialization as XML serialization.
Is this even the recommended way of doing this, or is using DTS etc a better option?
For import/export/replication, DTS and special replication tools / services are always a better option. Nothing beats DTS in speed.
Or is using .NET serialization functionality a better option?
Generally no, it's slower than DTS by a magnitude.
And when I save the top most entity - what does it do with data already in the database - does it update it? Or try and insert it?
Thanks
Joerg
It doesn't do a thing, you have to set IsNew to true if you want an insert, and IsChanged flags on all fields if you want them to get inserted/updated