DataSet Limitations

[dxdunc4]

Would anyone know how to get around the dataSet limitation in C#? I am trying to build a dataset from an Oracle table that has more than 100 columns so that I can write it out to an xml file, along with it's schema, to use in Biztalk. The only way I can find to do this is the writeXml() function. Is there a way to build a dataset with more than 100 columns or can a dataview be built with more than 100 columns? Is this a limitiation of the OleDb adapter? Thanks for any suggestions.

 

[Alcar]

I've haven't heard of any column limitation in ado.net but you might want to perform a serch at support.microsoft.com on the subject. You might find useful information.