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 WCF service.
B.
Use a separate library.
C.
Use SQL XML Services.
D.
Use stored procedures.
Explanation:
WCF is far more powerful and flexible than ASP.NET web services. With WCF, the developers
can offer a variety of bindings and support transactions, queuing, and additional security.WCF data services are useful when you need to create a data access layer
for applications connecting across the Internet. You can create a WCF data services
data access layer in only a few minutes.