ASP.NET auto generate web services from stored procedures

Question

Hey guys,

I have looking for a code generation tool, that could auto generate web services based on feeding a tool the stored procedure that I would like.

Is there something that could achieve this for me ?

Answer 1

You can use codesmith with a combination of netTiers, or if netTiers is too much for your requirement you can code on codesmith anyway

Answer 2

The best solution may be to use SQL Server endpoints, which do just that without generating code and without even needing .Net.

The other solution is to roll your own tool. I have created a tool similar to this but it doesn't create a web service, only the calls to the database stored procedures through function wrappers.

Answer 3

check this :

http://www.codeproject.com/KB/reporting-services/CreateStoredProcedure.aspx