Here is what I need to figure out, any suggestions would really help. Thanks.
We have a db which is laid like hierachy style, so lets say we have a top level table of object, all other tales begin with an entry from object, so newobject would create an entry in object table and will have its own details, a further table could again be added to the newobject table and use the id from there to link itself to its parent. Object will link to many other tables that use its ID and inherit properties, you should start to get the picture.
All works fine in NHibernate as its the choice for this project. Heres where the issue is.
I need to be able to export a reocd from a db, say from newobject into xml this is easy as sql does this with the FOR XML command.
The result I end up with is what I want i.e
select * from object where objectid=1 for xml auto
all good so far
next I do
select * from newobject where objectid=1 for xml auto
again all good and gives me
View Complete Post