You are developing an ASP.NET MVC application. The application is an order processing system that uses the
ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that displays
customers. Customers are filtered on Country and, if provided, on CompanyName.
You have an Entity Framework context named db.
The Customer class is shown below.

You need to execute a single deferred query to return the filtered list of customers.
Which code segment should you use?

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity including retrieving identical sets across reads in all situations that use
transactions.
Which isolation level should you use?

You are preparing to develop a set of libraries that uses large data sets.
The libraries must be shared across an organization and distributed to several servers.
You need to create a remote NuGet feed that exposes the libraries for developer use.
What should you do? (Each answer presents part of the solution. Choose all that apply.)

You are designing an ASP.NET Web API application.
You need to select an HTTP verb to allow blog administrators to modify the text of a comment.
Which HTTP verb should you use?

You are developing a new ASP.NET MVC application that does not have an existing database.
The requirements for the application are not complete, and the SQL data model will likely change.
You need to choose an approach to visually manage a data model.
Which approach should you use?

You are developing an ASP.NET MVC application. The application has a page that updates an image stored in
a database. Members of the EntityClient namespace are used to access an ADO.NET Entity Framework data
model. Images and associated metadata are stored in a single database table.
You need to run a single query that updates an image and associated metadata in the database while returning
only the number of affected rows.
Which method of the EntityCommand type should you use?

You are developing a .NET application that uses the HttpClient type to call an ASP.NET Web API application.
The API call returns a list of customers in JSON format and logs the results.
The URI for the API call is in a variable named address.
You need to make the API call without blocking.
Which code segment should you use?

You are developing an order processing application that uses the ADO.NET Entity Framework against a SQL
Server database. Lazy loading has been disabled. The application displays orders and their associated order
details. Order details are filtered based on the category of the product in each order.
The Order class is shown below.

The OrderDetail class is shown below.

The Product class is shown below.

The Category class is shown below.

You need to return orders with their filtered list of order details included in a single round trip to the database.
Which code segment should you use?

You are developing an ASP.NET MVC application. The application has a page that searches for and displays
an image stored in a database. Members of the EntityClient namespace are used to access an ADO.NET Entity
Framework data model. Images and associated metadata are stored in a database table.
You need to run a query that returns only the image while minimizing the amount of data that is transmitted.
Which method of the EntityCommand type should you use?

You are developing an ASP.NET MVC application that displays a report. The report includes large images that
are stored in a database. Members of the EntityClient namespace are used to access the database through the
ADO.NET Entity Framework data model. You need to prevent memory exceptions while generating a report
using the EntityDataRcader type.
Which CommandBehavior type should you use?