Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying WCF Multi-layer Services Development with Entity Framework - Fourth Edition
  • Table Of Contents Toc
WCF Multi-layer Services Development with Entity Framework - Fourth Edition

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

By : Mike Liu
4.2 (13)
Buy this Book
close
close
WCF Multi-layer Services Development with Entity Framework - Fourth Edition

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

4.2 (13)
By: Mike Liu
Buy this Book

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.
Table of Contents (15 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Implementing a Basic HelloWorld WCF Service
Icon
1. Implementing a Basic HelloWorld WCF Service
Icon
The basic WCF concepts
Icon
Creating the HelloWorld solution and project
Icon
Defining the HelloWorldService service contract interface
Icon
Implementing the HelloWorldService service contract
Icon
Hosting the WCF service in IIS Express
Icon
Creating a client to consume the WCF service
Icon
Summary
2
2. Hosting the HelloWorld WCF Service
Icon
2. Hosting the HelloWorld WCF Service
Icon
WCF hosting options
Icon
Summary
3
3. Deploying the HelloWorld WCF Service
Icon
3. Deploying the HelloWorld WCF Service
Icon
Publishing the HelloWorldService from Visual Studio
Icon
Publishing the HelloWorldService using a deployment package
Icon
Summary
4
4. Debugging the HelloWorld WCF Service
Icon
4. Debugging the HelloWorld WCF Service
Icon
Debugging a WCF service from a client application
Icon
Directly debugging the WCF service
Icon
Attaching the debugger to a running WCF service process
Icon
Debugging a WCF service hosted in the cloud
Icon
Summary
5
5. Implementing a Three-layer WCF Service
Icon
5. Implementing a Three-layer WCF Service
Icon
Why layer a service?
Icon
Creating a new solution and project using the built-in WCF service template
Icon
Creating the service interface layer
Icon
Adding a business logic layer
Icon
Summary
6
6. Adding Database Support and Exception Handling
Icon
6. Adding Database Support and Exception Handling
Icon
Adding a data access layer
Icon
Adding error handling to the service
Icon
Summary
7
7. LINQ to Entities – Basic Concepts and Features
chevron up
Icon
7. LINQ to Entities – Basic Concepts and Features
Icon
LINQ to Entities
Icon
Creating a LINQ to Entities test application
Icon
Creating the data model
Icon
Querying and updating a database table
Icon
Viewing the generated SQL statements
Icon
Deferred execution
Icon
Deferred execution – lazy loading versus eager loading
Icon
Joining two tables
Icon
Querying a view
Icon
Summary
8
8. LINQ to Entities – Advanced Concepts and Features
Icon
8. LINQ to Entities – Advanced Concepts and Features
Icon
Calling a stored procedure
Icon
Handling simultaneous (concurrent) updates
Icon
Transaction support
Icon
Summary
9
9. Applying LINQ to Entities to a WCF Service
Icon
9. Applying LINQ to Entities to a WCF Service
Icon
Creating the LINQNorthwind solution
Icon
Installing Entity Framework
Icon
Modeling the Northwind database
Icon
Creating the business domain object project
Icon
Using LINQ to Entities in the data access layer
Icon
Creating the business logic layer
Icon
Creating the service interface layer
Icon
Testing the service with the WCF Test Client
Icon
Testing concurrency with our own client
Icon
Hosting the WCF service in IIS
Icon
Summary
10
10. Distributed Transaction Support of WCF
Icon
10. Distributed Transaction Support of WCF
Icon
Creating the DistNorthwind solution
Icon
Hosting the WCF service in IIS
Icon
Testing the transaction behavior of the existing WCF service
Icon
Enabling distributed transaction support
Icon
Understanding the distributed transaction support of a WCF service
Icon
Testing the distributed transaction support of the new WCF service
Icon
Trade-offs of distributed transactions
Icon
Summary
11
11. Building a RESTful WCF Service
Icon
11. Building a RESTful WCF Service
Icon
SOAP versus REST
Icon
WCF REST versus the ASP.NET Web API
Icon
Creating the RESTNorthwind solution
Icon
Creating the RESTful service
Icon
Testing the RESTful service in a browser
Icon
Testing the RESTful WCF service with a C#/XAML client
Icon
Testing the RESTful WCF service with a JavaScript client
Icon
Summary
12
12. WCF Security
Icon
12. WCF Security
Icon
WCF security components
Icon
Hosting a WCF service using basic authentication
Icon
Hosting a WCF service with Windows authentication
Icon
Summary
13
13. Extending WCF Services
Icon
13. Extending WCF Services
Icon
The WCF runtime architecture
Icon
Why extend WCF services?
Icon
WCF extension points
Icon
Extending a WCF service
Icon
Extending HelloWorldService
Icon
Summary
14
Index
Icon
Index

Viewing the generated SQL statements

You might wonder which SQL statements are used by LINQ to Entities to interact with the databases. In this section, we will use two ways to view the generated SQL statements used by LINQ to Entities queries. The first one is to use the ToString method and the second one is to use SQL Profiler.

Viewing the SQL statements using ToString

First, let's write a new test method to contain one LINQ to Entities query:

        static void ViewGeneratedSQL()
        {
            using(var NWEntities = 
                new NorthwindEntities())
           {

            var beverages = 
                from p in NWEntities.Products
                where p.Category.CategoryName == "Beverages"
                orderby p.ProductName
                select p;
            }
        }

Now, we can print out the SQL statement of the LINQ to Entities query using the following statement:

       // view SQL using ToString method
       Console.WriteLine("The SQL statement is:" +...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 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
End of Section 7
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon