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?

Question

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?

Accepted Answer

A. Use a WCF service.

Answer

B. Use a separate library.

Answer

C. Use SQL XML Services.

Answer

D. Use stored procedures.

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…

Question

Options

How the community answered

Community Discussion