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.