WCF 4.5 Multi-Layer Services Development with Entity Framework -- Table of Contents -- WCF 4.5 Multi-Layer Services Development with Entity Framework -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Web Services and Windows Communication Foundation -- What is SOA? -- Web services -- What is a 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 -- Windows Communication Foundation (WCF) -- 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 or 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 IIS Express -- Creating the host application -- Testing the host application -- IIS Express -- 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 ASP.NET Development Server -- 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 the Internet Information Services server using the HTTP protocol -- 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 -- Hosting the service in the Internet Information Services server using the TCP protocol -- Benefits of hosting a WCF service using the TCP protocol -- Preparing the folders and files -- Enabling the non-HTTP WCF activation for the hosting machine -- Creating the IIS application -- Testing the WCF service hosted in IIS using the TCP protocol -- Other WCF service hosting options -- Debugging the HelloWorld WCF service -- Debugging from the client application -- Starting the debugging process -- Debugging on the client application -- Stepping into the WCF service -- Directly debugging the WCF service -- Starting the WCF service in debugging mode -- Starting the client application -- Attaching to a running WCF service process -- Running the WCF service and client applications in non-debugging mode -- Debugging the WCF service hosted in IIS -- Summary -- 4. Implementing a WCF Service in the Real World -- Why layer a service? -- Creating a new solution and project using WCF templates -- Creating the WCF service project -- 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 business domain object 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 -- 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 contract 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 -- Datatype 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 a database table -- Querying records -- Updating records -- Inserting records -- Deleting records -- Running the program -- Viewing generated SQL statements -- Viewing SQL statements using ToString -- Viewing SQL statements using SQL 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 with the Include method -- Comparing lazy loading and eager loading -- 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 -- 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 -- 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 -- Summary.

9. Applying LINQ to Entities to a WCF Service -- Creating the LINQNorthwind solution -- Modeling the Northwind database -- Creating the business domain object project -- Using LINQ to Entities in the data access layer -- Adding a reference to the BDO project -- Creating GetProduct in the data access layer -- Creating UpdateProduct in the data access layer -- Creating the business logic layer -- Creating the service interface layer -- Testing the service with the 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 updates 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 Microsoft Distributed Transaction Coordinator -- Configuring the firewall.

Propagating a transaction from the client to the WCF service.