You are designing an ASP.NET Web application to manage and display sensitive
information stored in a Microsoft SQL Server database. The database also provides
authorization information for users. All Web pages that display sensitive information require
an authenticated login. There is no visitor access to these pages. You have the following
requirements: • Separate authorization logic from the application. • Prevent the application
from directly accessing the database server. You need to design a data access and
authorization solution. Which approach should you recommend?
A.
Use a separate library.
B.
Use SQL XML Services.
C.
Use a WCF service.
D.
Use stored procedures.