Hello,
I have this need for a user customisable datastructure. I've toyed around with the idea of having a field table and then fieldvalue tables that are referenced by the container entity but it tends to get exponentially complex when you consider issues like field values that come from a list, reporting, strong typing of data etc.
I used xml in SQL 2000 (wrote queries that returned xml). The experience was horrible so I'm a little scared of xml+sql. But the xml column is a different concept. Its would seem to allow reporting on the data contained within as well being a lot more easier to manage than a series of tables. I was wondering what LLBL 2.6 did with an xml column. Does it just come out as a string, if theres a schema attached to the column is there a facility (code generated) to access it's data in a strongly typed fashion?
I'm working with SQL 2005, LLBL 2.6, .net 3.5
