High Value Microsoft 70-487 Forum

None

Azure Service Bus Messaging can safely use the QueueClient object for sending messages from concurrent asynchronous operations and multiple threads.
Scenario: The action in the Web API that returns the car brand must be asynchronous, while all other actions must be synchronous.
References: https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-performance-improvements

You should use a Publishing Profile with Microsoft Visual Studio Publishing.
References: https://msdn.microsoft.com/en-us/library/dd465337(v=vs.110).aspx

None

To create a duplex contract
(C) Create the interface that makes up the server side of the duplex contract.
(E) Apply the ServiceContractAttribute class to the interface.
Declare the method signatures in the interface.
(E) Apply the OperationContractAttribute class to each method signature that must be part of the public contract.
Create the callback interface that defines the set of operations that the service can invoke on the client.
Declare the method signatures in the callback interface.
Apply the OperationContractAttribute class to each method signature that must be part of the public contract.
(F) Link the two interfaces into a duplex contract by setting the CallbackContract property in the primary interface to the type of the callback interface.
Reference: How to: Create a Duplex Contract

* gt
Greater than Example:
filter= Entry_No gt 610
Query on GLEntry service. Returns entry numbers 611 and higher.
* startswith filter=startswith(Name, \'S\')
Query on Customer service. Returns all customers names beginning with “S”.

None

None

None

None

None

http://msdn.microsoft.com/en-us/library/aa347733.aspx

http://www.robbagby.com/entity-framework/entity-framework-modeling-table-per-type- inheritance/

None

http://msdn.microsoft.com/en-us/library/system.xml.linq.xstreamingelement.aspx and
http://msdn.microsoft.com/en-us/library/bb551307.aspx

If the class that wraps the external resource is shareable and thread-safe, create a shared singleton instance or a pool of reusable instances of the class.
The following example uses a static HttpClient instance, thus sharing the connection across all requests.
public class SingleHttpClientInstanceController : ApiController
{
private static readonly HttpClient httpClient; static SingleHttpClientInstanceController()
{
httpClient = new HttpClient();
}
// This method uses the shared instance of HttpClient for every call to GetProductAsync. public async Task<Product> GetProductAsync(string id)
{
var hostName = HttpContext.Current.Request.Url.Host;
var result = await httpClient.GetStringAsync(string.Format("http://{0}:8080/api/...", hostName));
return new Product { Name = result };
}
}
References: https://docs.microsoft.com/en-us/azure/architecture/antipatterns/improper- instantiation/

None

None

Package the component with the NuGet pack command.
References: https://docs.microsoft.com/en-us/nuget/guides/create-net-standard-packages-vs2015

EntitySqlException: Represents errors that occur when parsing Entity SQL command text. This exception is thrown when syntactic or semantic rules are violated.
SqlException: The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
EntityCommandExecutionException : Represents errors that occur when the underlying storage provider could not execute the specified command. This exception usually wraps a provider-specific exception.
Case Study: 2
ASP.NET MVC
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used to process orders.
Business Requirements
The application contains the following three pages:
✑ A page that queries an external database for orders that are ready to be processed. The user can then process the order.
✑ A page to view processed orders.
✑ A page to view vendor information.
The application consumes three WCF services to retrieve external data.
Technical Requirements Visual Studio Solution:
The solution contains the following four projects.
✑ ExternalQueue: A WCF service project used to communicate with the external order database.
✑ OrderProcessor: An ASP.NET MVC project used for order processing and logging order metadata.
✑ OrderUpload: A WCF service project used to submit order data to an external data source.
✑ Shipping: A WCF service project used to acquire shipping information.
ExternalQueue Project:
Entity Framework is used for data access. The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

The project contains two services defined in the following files.
✑ IExternalQueueService.es
✑ ExternalQueueService.svc.
The ExternalQueue.Helpers namespace contains a definition for a class named OrderNotFound Exception.
OrderProcessor Project:
Entity Framework is used for data access. The entities are defined in the ProcessedOrders.edmx file as shown in the following diagram.

The classes are contained in the OrderProcessor.Entities namespace. The project contains the following two controllers.
✑ InboundQueueController.es
✑ ProcessedOrderController.es
WCF service proxies to the ExternalQueue, Shipping and OrderUpload services have been generated by using the command prompt. The ExecuteCommandProcedure() method in the ExternalQueueService.svc file must run asynchronously.
The ProcessedOrderController controller has the following requirements.
The GetVendorPolicy() method must enforce a 10 minute absolute cache expiration policy. The GetProcessedOrders() method must return a view of the 10 most recently processed orders.
OrderUpload Project:
The project contains two services defined in the following files:
✑ IUploadCallbackService.es
✑ UploadCallbackService.svc
Data Access is maintained in a file named UploadOrder.es.
Shipping Project:
Entity Framework is used for data access. The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

The Custom Tool property for ExternalOrders.edmx has been removed.
POCO classes for the Entity Model are located in the ShippingAddress.es file. The POCO entity must be loaded by using lazy loading.
The project contains two services defined in the following files.
✑ IShippingService.es
✑ ShippingService.svc.
The IShippingService contract must contain an operation that receives an order number as a parameter. The operation must return a class named ShippingInfo that inherits from a class named State.
Application Structure

None

Package the component with the NuGet pack command, for example: nuget pack AppLogger.nuspec
This generates AppLogger.YOUR_NAME.1.0.0.nupkg.
References: https://docs.microsoft.com/en-us/nuget/guides/create-net-standard-packages- vs2015

With the model first workflow, you can design a model in a designer.