You are developing a library management application that uses the ADO.NET Entity Framework against a SQL
Server database. The application has a method that returns check outs filtered by date.
The Book class is shown below.

You must filter the data on the SQL server before it is returned to the application server.
You need to return books checked out more recently than the entered date.
Which code segment should you use?

You are developing an ASP.NET MVC application. The application is a loan processing system that uses the
ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that displays
all loans along with rate information. Lazy loading has been disabled.
The Loan class is shown below.

You need to return the loans and rate information in a single round trip to the database.
Which code segment should you use?

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?