ADO.NET's WriteXML has BUG!!

5 Jan 2007 4:49 AM

ABC

I have a dataset which contains two tables, one is master and another is
child table with a relation join between tables.

When I use DataSet.WriteXML, it shows as:

<aDataSet>
    <MasterTable ID="1" ............... />
    <ChildTable ID="1" .................. />
    ...
</aDataSet>

It is not my expected (which used in DataSet.WriteXML on .NET 1.1) as:

<aDataSet>
    <MasterTable ID="1" ............... >
        <ChildTable ID="1" .................. />
        ...
    </MasterTable>
</aDataSet>

I think it is one BUG!!

5 Jan 2007 5:22 AM

Cor Ligthert [MVP]

ABC,

This newsgroup is not for reporting Bugs

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

By the way in my opinion is this no Bug in the Microsoft WriteXML but in
your program, there is a property to set it in the way that is wanted.

However I don't like those persons who want to shout on Internet that
Microsoft programmers have made bugs while they did not, therefore have a
search yourself for that.

Cor

5 Jan 2007 8:51 AM

Miha Markic [MVP C#]

Hi there,

I don't think this is a bug.
DataSet isn't a hierarchical structure - it is a container for tables that
might be referenced.
What if child table contains a reference to master table? How would xml then
look like?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"ABC" <a**@abc.com> wrote in message
news:%23v%23%23lTIMHHA.4888@TK2MSFTNGP02.phx.gbl...
>I have a dataset which contains two tables, one is master and another is
>child table with a relation join between tables.
>
> When I use DataSet.WriteXML, it shows as:
>
> <aDataSet>
>    <MasterTable ID="1" ............... />
>    <ChildTable ID="1" .................. />
>    ...
> </aDataSet>
>
> It is not my expected (which used in DataSet.WriteXML on .NET 1.1) as:
>
> <aDataSet>
>    <MasterTable ID="1" ............... >
>        <ChildTable ID="1" .................. />
>        ...
>    </MasterTable>
> </aDataSet>
>
> I think it is one BUG!!
>

5 Jan 2007 9:28 AM

ABC

If use .NET 1.1, the writeXml outcome like-as tree structure to display tag
and values.
But, if use .NET 2.0, the outcome like-as two tables list.

Show quote

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:8990687C-C1B6-4A9F-8F67-9B211155CFB4@microsoft.com...
> Hi there,
>
> I don't think this is a bug.
> DataSet isn't a hierarchical structure - it is a container for tables that
> might be referenced.
> What if child table contains a reference to master table? How would xml
> then look like?
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "ABC" <a**@abc.com> wrote in message
> news:%23v%23%23lTIMHHA.4888@TK2MSFTNGP02.phx.gbl...
>>I have a dataset which contains two tables, one is master and another is
>>child table with a relation join between tables.
>>
>> When I use DataSet.WriteXML, it shows as:
>>
>> <aDataSet>
>>    <MasterTable ID="1" ............... />
>>    <ChildTable ID="1" .................. />
>>    ...
>> </aDataSet>
>>
>> It is not my expected (which used in DataSet.WriteXML on .NET 1.1) as:
>>
>> <aDataSet>
>>    <MasterTable ID="1" ............... >
>>        <ChildTable ID="1" .................. />
>>        ...
>>    </MasterTable>
>> </aDataSet>
>>
>> I think it is one BUG!!
>>
>