7. LINQ to Entities – Basic Concepts and Features | WCF Multi-layer Services Development with Entity Framework - Fourth Edition

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

WCF Multi-layer Services Development with Entity Framework - Fourth Edition

By : Mike Liu

4.2 (13)

WCF Multi-layer Services Development with Entity Framework - Fourth Edition

4.2 (13)

By: Mike Liu

Overview of this book

If you are a C#, VB.NET, or C++ developer and want to get started with WCF and Entity Framework, then this book is for you. Competence in Entity Framework will be needed to follow the examples in the book, but experience in creating WCF services using Entity Framework is not necessary. Developers and architects evaluating SOA implementation technologies for their company will find this book useful.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Implementing a Basic HelloWorld WCF Service

1. Implementing a Basic HelloWorld WCF Service

The basic WCF concepts

Creating the HelloWorld solution and project

Defining the HelloWorldService service contract interface

Implementing the HelloWorldService service contract

Hosting the WCF service in IIS Express

Creating a client to consume the WCF service

Summary

2. Hosting the HelloWorld WCF Service

2. Hosting the HelloWorld WCF Service

WCF hosting options

Summary

3. Deploying the HelloWorld WCF Service

3. Deploying the HelloWorld WCF Service

Publishing the HelloWorldService from Visual Studio

Publishing the HelloWorldService using a deployment package

Summary

4. Debugging the HelloWorld WCF Service

4. Debugging the HelloWorld WCF Service

Debugging a WCF service from a client application

Directly debugging the WCF service

Attaching the debugger to a running WCF service process

Debugging a WCF service hosted in the cloud

Summary

5. Implementing a Three-layer WCF Service

5. Implementing a Three-layer WCF Service

Why layer a service?

Creating a new solution and project using the built-in WCF service template

Creating the service interface layer

Adding a business logic layer

Summary

6. Adding Database Support and Exception Handling

6. Adding Database Support and Exception Handling

Adding a data access layer

Adding error handling to the service

Summary

7. LINQ to Entities – Basic Concepts and Features

7. LINQ to Entities – Basic Concepts and Features

LINQ to Entities

Creating a LINQ to Entities test application

Creating the data model

Querying and updating a database table

Viewing the generated SQL statements

Deferred execution

Deferred execution – lazy loading versus eager loading

Joining two tables

Querying a view

Summary

8. LINQ to Entities – Advanced Concepts and Features

8. LINQ to Entities – Advanced Concepts and Features

Calling a stored procedure

Handling simultaneous (concurrent) updates

Transaction support

Summary

9. Applying LINQ to Entities to a WCF Service

9. Applying LINQ to Entities to a WCF Service

Creating the LINQNorthwind solution

Installing Entity Framework

Modeling the Northwind database

Creating the business domain object project

Using LINQ to Entities 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

Hosting the WCF service in IIS

Summary

10. Distributed Transaction Support of WCF

10. Distributed Transaction Support of WCF

Creating the DistNorthwind solution

Hosting the WCF service in IIS

Testing the transaction behavior of the existing WCF service

Enabling distributed transaction support

Understanding the distributed transaction support of a WCF service

Testing the distributed transaction support of the new WCF service

Trade-offs of distributed transactions

Summary

11. Building a RESTful WCF Service

11. Building a RESTful WCF Service

SOAP versus REST

WCF REST versus the ASP.NET Web API

Creating the RESTNorthwind solution

Creating the RESTful service

Testing the RESTful service in a browser

Testing the RESTful WCF service with a C#/XAML client

Testing the RESTful WCF service with a JavaScript client

Summary

12. WCF Security

12. WCF Security

WCF security components

Hosting a WCF service using basic authentication

Hosting a WCF service with Windows authentication

Summary

13. Extending WCF Services

13. Extending WCF Services

The WCF runtime architecture

Why extend WCF services?

WCF extension points

Extending a WCF service

Extending HelloWorldService

Summary

Index

Index

Deferred execution – lazy loading versus eager loading

In one of the preceding examples, we retrieved the category name of a product using the following expression:

p.Category.CategoryName == "Beverages"

Even though there is no field called categoryname in the Products table, we can still get the category name of a product because there is an association between the Products and Category tables. In the Northwind.edmx design pane, click on the line that connects the Products and Categories tables and you will see all of the properties of the association. Note that its Referential Constraint property is Category.CategoryID -> Product.CategoryID, meaning that category ID is the key field to link these two tables.

Because of this association, we can retrieve the category for each product and also retrieve products for each category.

Lazy loading by default

Even with an association, the associated data is not loaded when the query is executed. For example, suppose we use the following test method...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

WCF Multi-layer Services Development with Entity Framework - Fourth Edition

Search

Your notes and bookmarks