June 6, 2011 at 7:33 am
I want to create a really basic web service to insert and delete records. MS has deprecated the T-sql XML services to do this. What is MSs recommended method at present. ASP.net?, WCF? or somethin else?
Obviously, if they move such task from the database engine, they have to put it somewhere else. Which is the one that is going to be most supported/recommeded by in the future?
June 6, 2011 at 12:40 pm
Direct from Kevin Cox (on Microsoft SQLCAT Team) in a "What's new in SQL 'Denali'?" presentation HTTP endpoints were pulled from the SQL Server product almost as a direct result of security concerns raised by "large SQL Server customers".
I thought Microsoft went too far adding that feature myself and am happy to see it removed.
For your scenario I would create a WCF web service with the intention of hosting it in IIS on a server other than the server hosting SQL Server. Then have the web service call a stored procedure on the SQL Server.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply