Building Data-Driven Web Services

One of the greatest strengths of Web services is their capability to return data from a database. This allows you to share data from your server without having to open up the database for direct access. SQL Server allows you to grant direct access to the database via HTTP, but the user is free to enter any kind of statement, including inserts, updates, deletes, and DDL statements. Giving this kind of open access to your database is almost always undesirable. Web services are one way in which you can restrict the access to the database while still making the necessary data available.

By creating methods, you control what data can be accessed. For example, a GetOrders method might be used to return one or more ...

Get A Programmer's Introduction to Visual Basic® .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.