Hi all,

I like to have MS SQL expose stored procedures as web services so that I only have to download the WSDL files and generate proxies based on these WSDLs. After that, I can call SPs through proxies which make my Data Access Layer clean and easy since I don't have to worry about DB connection or how to set input/output parameters of SPs. However, only if this feature is available in MS SQL. I know it's inefficient, but just want to try.

Otherwise, do we have any code generator that can query MS SQL for SPs and generates proxies? Ideally, the generated code should correctly handle all parameters to SPs and convert the result back to some easy- to-use format, not the DataReader (as in VB.NET if we call SPs directly).

Please advice,