I'm developing a custom procedure to use with ExecuteLocalProcedure (my favorite method!)
For the first time since I've been using this, I'd really like to have the table names defined like all of the 'out of the box' methods (so in my code-behind I can use table["name"].row[ ] etc....)
Instead - the table names are returned simply as LocalProcedure1, 2, 3, etc.....-
I tried to make SQL output the dataset as XML using FOR XML PATH but that wasn't at all what I wanted.
AOE tried this? It's certainly no big deal and I can handle it either way - but just thought it would be handy
Thanks
Hi Nathan,
I do not think this is possible. The web api code is using a dataadapter to fill the dataset and it is supplying the table name as "LocalProcedure". So when you have multiple selects you get LocalProcedure,LocalProcedure1 etc.
What I have done before is create an enum.
Jon