CodeSmith Community
Your Code. Your Way. Faster!

Consuming a FOR XML Proc

Latest post 06-16-2008 2:29 PM by picasso566. 2 replies.
  • 06-16-2008 1:19 PM

    Consuming a FOR XML Proc

    I am in the process of converting a site (written by someone else) to use .net tiers on the back end. We have a number of stored procs which return XML. The reasoning behind generating the XML within a proc is solid and is the most efficient way getting the desired data. I've been searching the forums trying to figure out how .net tiers handles FOR XML from custom stored procs, but because the search contains FOR and XML is returns all the articles for XML datatypes, etc...

     

    Does .net tiers automatically return an xmldocument object for the proc results?

     

    Thanks in advance, 

    Paul 

    • Post Points: 35
  • 06-16-2008 1:41 PM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 341
    • Points 8,605

    Re: Consuming a FOR XML Proc

    No it doesn't.  My guess it would return a dataset with 1 table, 1 column, 1 row...just a guess though.  Nettiers does not code for this.  Best thing to do would be to give it a whirl and hope see if you get a dataset back.

    jeff

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 35
  • 06-16-2008 2:29 PM In reply to

    Re: Consuming a FOR XML Proc

    I'm sorry for laughing, but I did...

     

    Thanks for you quick response.

    It shouldn't be that big a deal to throw the DS->table->row->column into an xmldocument.

     

    Paul 

     

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems