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

Querying and updating a database table

Now that we have the entity classes created, we will use them to interact with the database. We will first work with the Products table to query and update records as well as to insert and delete records.

We will put our code in the Program.cs file. To make it easier to maintain, we will create a method, TestTables, put the code inside this method, and then call this method from the Main method.

Querying records

First, we will query the database to get some products. To query a database by using LINQ to Entities, we first need to construct a DbContext object as follows:

var NWEntities = new NorthwindEntities();

We can then use the LINQ query syntax to retrieve records from the database using the following code:

IEnumerable<Product> beverages = from p in NWEntities.Products
                     where p.Category.CategoryName == "Beverages"
                     orderby p.ProductName
                     select p;

The preceding code will retrieve all of...

Visually different images

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