In the previous chapter, we created a WCF service with two layers. We didn't add the third layer, that is, the data access layer. Therefore, all of the service operations just returned a fake result from the business logic layer.
In this chapter, we will add the third layer to the WCF service. We will also introduce fault contracts for service error handling.
We will accomplish the following tasks in this chapter:
Creating the data access layer project
Calling the data access layer from the business logic layer
Preparing the
Northwinddatabase for the serviceAdding the connection string to the configuration file
Querying the database using
GetProductTesting the
GetProductmethodUpdating the database using
UpdateProductTesting the
UpdateProductmethodAdding a fault contract to the service
Throwing a fault contract exception to the client
Updating the client program to catch the fault exception
Changing exception options
Testing the service fault...