WCF 4.0 Multi-tier Services Development with LINQ to Entities电子书

WCF 4.0 Multi-tier Services Development with LINQ to Entities

Table of Contents

WCF 4.0 Multi-tier Services Development with LINQ to Entities

Credits

About the Author

About the Reviewers

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Introducing Web Services and Windows Communication Foundation

What is SOA?

Web services

What is a web service?

Web service WSDL

Web service proxy

SOAP

Web services: standards and specifications

WS-I Profiles

WS-Addressing

WS-Security

WS-ReliableMessaging

WS-Coordination and WS-Transaction

WCF: Windows Communication Foundation

What is WCF?

Why is WCF used for SOA?

WCF architecture

Basic WCF concepts—WCF ABCs

Address

Binding

Contract

Service contract

Operation contract

Message contract

Data contract

Fault contract

Endpoint

Behavior

Hosting

Self hosting

Windows services hosting

IIS hosting

Windows Activation Services hosting

Channels

Metadata

WCF production and development environments

Summary

2. Implementing a Basic HelloWorld WCF Service

Creating the HelloWorld solution and project

Creating the HelloWorldService service contract interface

Implementing the HelloWorldService service contract

Hosting the WCF service in ASP.NET Development Server

Creating the host application

Testing the host application

ASP.NET Development Server

Adding an SVC file to the host application

Modifying the web.config file

Starting the host application

Creating a client to consume the WCF service

Creating the client application project

Generating the proxy and configuration files

Customizing the client application

Running the client application

Setting the service application to AutoStart

Summary

3. Hosting and Debugging the HelloWorld WCF Service

Hosting the HelloWorld WCF service

Hosting the service in a managed application

Hosting the service in a console application

Consuming the service hosted in a console application

Hosting the service in a Windows service

Hosting the service in Internet Information Server

Preparing the folders and files

Turn on Internet Information Services

Creating the IIS application

Starting the WCF service in IIS

Testing the WCF service hosted in IIS

Other WCF service hosting options

Debugging the HelloWorld WCF service

Debugging from the client application

Starting the debugging process

Debugging on the client application

Attaching to ASP.NET Development Server

Stepping into the WCF service

Debugging only the WCF service

Starting the WCF Service in debugging mode

Starting the client application in non-debugging mode

Starting the WCF service and client applications in debugging mode

Attaching to a WCF service process

Running the WCF service and client applications in non-debugging mode

Debugging the WCF service hosted in IIS

Just-In-Time debugger

Summary

4. Implementing a WCF Service in the Real World

Why layer a service?

Creating a new solution and project using WCF templates

Using the C# WCF service library template

Using the C# WCF service application template

Creating the service interface layer

Creating the service interfaces

Creating the data contracts

Implementing the service contracts

Modifying the app.config file

Testing the service using WCF Test Client

Testing the service using our own client

Adding a business logic layer

Adding the product entity project

Adding the business logic project

Calling the business logic layer from the service interface layer

Testing the WCF service with a business logic layer

Summary

5. Adding Database Support and Exception Handling to the RealNorthwind WCF Service

Adding a data access layer

Creating the data access layer project

Calling the data access layer from the business logic layer

Preparing the database

Adding the connection string to the configuration file

Querying the database (GetProduct)

Testing the GetProduct method

Updating the database (UpdateProduct)

Adding error handling to the service

Adding a fault contract

Throwing a fault exception

Updating the client program to catch the fault exception

Testing the fault exception

Summary

6. LINQ—Language Integrated Query

What is LINQ

Creating the test solution and project

New data type var

Automatic properties

Object initializer

Collection initializer

Anonymous types

Extension methods

Lambda expressions

Built-in LINQ extension methods and method syntax

LINQ query syntax and query expression

Built-in LINQ operators

Summary

7. LINQ to Entities: Basic Concepts and Features

ORM—Object-Relational Mapping

Entity Framework

LINQ to Entities

Comparing LINQ to Entities with LINQ to Objects

LINQ to SQL

Comparing LINQ to SQL with LINQ to Entities

Creating a LINQ to Entities test application

Creating the Data Model

Adding a LINQ to Entities item to the project

Generated LINQ to Entities classes

Querying and updating the database with a table

Querying records

Updating records

Inserting records

Deleting records

Running the program

View Generated SQL statements

View SQL statements using ToTraceString

View SQL statements using Profiler

Deferred execution

Checking deferred execution with SQL profiler

Deferred execution for singleton methods

Deferred execution for singleton methods within sequence expressions

Deferred (lazy) loading versus eager loading

Lazy loading by default

Eager loading the with Include method

Joining two tables

Querying a view

Summary

8. LINQ to Entities: Advanced Concepts and Features

Calling a stored procedure

Mapping a stored procedure to a new entity class

Modeling a stored procedure

Querying a stored procedure

Mapping a stored procedure to an existing entity class

Compiled query

Direct SQL

Dynamic query

Dynamic query with expressions

Dynamic query with parameters

Inheritance

LINQ to Entities Table per Hierarchy inheritance

Modeling the BaseCustomer and USACustomer entities

Modeling the UKCustomer entity

Generated classes with TPH inheritance

Testing the TPH inheritance

LINQ to Entities Table per Type inheritance

Preparing database tables

Modeling USACustomer1 and UKCustomer1 entities

Generated classes with TPT inheritance

Testing the TPT inheritance

Handling simultaneous (concurrent) updates

Detecting conflicts using a data column

Explaining the Concurrency Mode property

Adding another Entity Data Model

Writing the test code

Testing the conflicts

Turning on concurrency control

Detecting conflicts using a version column

Adding a version column

Modeling the Products table with a version column

Writing the test code

Testing the conflicts

Transaction support

Implicit transactions

Explicit transactions

Adding validations to entity classes

Debugging LINQ to Entities programs

Summary

9. Applying LINQ to Entities to a WCF Service

Creating the LINQNorthwind solution

Modeling the Northwind database

Copying the connection string to the service layer

Using LINQ to Entities in the data access layer

Modifying GetProduct in the data access layer

Modifying UpdateProduct in the data access layer

Testing LINQ to Entities with the WCF Test Client

Adding concurrency support

Turning on RowVersion concurrency mode

Modifying the ProductEntity class

Modifying the ProductDAO class

Modifying the GetProduct method

Modifying UpdateProduct method

Modifying the business logic layer classes

Modifying the service interface layer classes

Testing concurrency with WCF Test Client

Testing concurrency with our own client

Creating the test client

Implementing the GetProduct functionality

Implementing the UpdateProduct functionality

Testing the GetProduct and UpdateProduct operations

Testing concurrent update manually

Testing concurrent update automatically

Summary

10. Distributed Transaction Support of WCF

Creating the DistNorthwind solution

Hosting the WCF service in IIS

Testing the transaction behavior of the WCF service

Creating a client to call the WCF service sequentially

Testing the sequential calls to the WCF service

Wrapping the WCF service calls in one transaction scope

Testing multiple database support of the WCF service

Creating a new WCF service

Calling the new WCF service in the client application

Testing the WCF service with two databases

Enabling distributed transaction support

Enabling transaction flow in service binding

Enabling transaction flow on the service hosting application

Modifying the service operation contract to allow a transaction flow

Modifying the service operation implementation to require a transaction scope

Understanding the distributed transaction support of a WCF service

Testing the distributed transaction support of the WCF service

Configuring the Distributed Transaction Coordinator

Configuring the firewall

Propagating a transaction from the client to the WCF service

Testing distributed transaction support with one database

Testing distributed transaction support with two databases

Summary

Index