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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.