Hi,

I've got a SQL Server with various enitities. Now I want to make the following XML:

A Client, with it's contacts, orders & notes. (But to the client are also related to support issues , contracts and meetings (all entities)).

How can I start and how should I do this? So I would like to end up with a strcuture like:

<clients> <client> <name/> <addres/> <contacts> <contact> <contactname/> </contact> <contact> <contactname/> </contact> </contacts> etc...

Any pointers would be greatly appericiated + also any easy resources for learning how to make templates or solutions so I can convert the above asked XML to XLS and HTML (XSLT or something? can't find good intro articles)

Thank u!

You can use the WriteXml() & ReadXml() functions available in the Entity and EntityCollection classes.

And to have the hierarchy needed, you should fetch your main entity (entities), with the needed related entities. by using the PrefetchPaths.

Please refer to the LLBLGen Pro documentation, in the "Using the generated code -> Adapter/Selfservice -> Prefetch paths" section.

And for the second question about XML - XSL & HTML, you will find many resources in the internet, and this is a link you may refer to http://www.w3.org/TR/xslt

Good Luck.