You are designing an application that will use Entity Framework to access a SQL Server database. The application must adhere to the following security requirements:

* Applications cannot store connection strings that include user and password information and applications cannot prompt the user for this information.
* Nonadministrator Windows logins can only be granted permission to read from tables and execute stored procedures.

You need to ensure that your connection type and Entity Data Model meet these requirements.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 921 | Points: 40
Select from following answers:
  1. Use a connection string that specifies Windows integrated security. Configure stored procedures for entity update, delete, and insert operations.
  2. Use a connection string that specifies Windows integrated security. Use the Entity Data Model Wizard to generate default entity operations.
  3. Use a connection string that uses a SQL Server login created for the application. Use the Entity Data Model Wizard to generate default entity operations.
  4. All Above

Show Correct Answer


Source: MeasureUp.com | | Alert Moderator 

Comments or Responses

Login to post response