Entity Framework Tutorial (Update) - Second Edition

Book Image

Entity Framework Tutorial (Update) - Second Edition

By : Joydip Kanjilal

Book Image

Entity Framework Tutorial (Update) - Second Edition

By: Joydip Kanjilal

Overview of this book

The ADO.NET Entity Framework from Microsoft is a new ADO.NET development framework that provides a level of abstraction for data access strategies and solves the impedance mismatch issues that exist between different data models This book explores Microsoft’s Entity Framework and explains how it can used to build enterprise level applications. It will also teach you how you can work with RESTful Services and Google’s Protocol Buffers with Entity Framework and WCF. You will explore how to use Entity Framework with ASP.NET Web API and also how to consume the data exposed by Entity Framework from client applications of varying types, i.e., ASP.NET MVC, WPF and Silverlight. You will familiarize yourself with the new features and improvements introduced in Entity Framework including enhanced POCO support, template-based code generation, tooling consolidation and connection resiliency. By the end of the book, you will be able to successfully extend the new functionalities of Entity framework into your project.

Entity Framework Tutorial Second Edition

Entity Framework Tutorial Second Edition

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Introducing the ADO.NET Entity Framework

Introducing the ADO.NET Entity Framework

What you should know

What is the ADO.NET Entity Framework?

A comparative analysis of Entity Framework and other ORM tools

Entity Framework architectural components

System requirements

Performance improvements in Entity Framework 6

New features in Entity Framework 7

Getting Started

Getting Started

Designing the UserAuthentication database

Creating the EDM

The DataSource controls

Implementing our first application using the Entity Framework

Entities, Relationships, and the Entity Data Model

Entities, Relationships, and the Entity Data Model

Entities, entity types, and relationships in the EDM

Exploring the Security EDM

Working with Stored Procedures in the Entity Data Model

Working with Stored Procedures in the Entity Data Model

Creating a database using model-first development

Creating stored procedures

Mapping stored procedures to functions in the EDM

Executing stored procedures using the EDM

Mapping stored procedures that return custom entity types

Working with Entity Client and Entity SQL

Working with Entity Client and Entity SQL

An overview of the E-SQL language

From T-SQL to E-SQL

Why E-SQL when I already have LINQ to Entities?

Data paging using E-SQL

Working with the ADO.NET Entity Client

Other operations with E-SQL

Deferred, eager, and lazy loading

Working with LINQ to Entities

Working with LINQ to Entities

Introducing LINQ

Understanding the LINQ architecture

Operators in LINQ

Querying data using LINQ

Working with the Object Services Layer

Working with the Object Services Layer

What are Object Services?

Performing CRUD operations on objects

Attaching and detaching objects to and from ObjectContext

Serializing and deserializing entity instances

Change tracking and identity resolution using ObjectContext

Understanding the code-first, model-first, and database-first approaches to domain design

Inheritance in Entity Framework

Implementing complex types in the EDM

State management, identity management, and relationship management

Reading objects from the Security database

Inserting objects from the Security database

Editing objects from the Security database

Deleting objects from the Security database

Working with WCF Data Services

Working with WCF Data Services

Introducing WCF Data Services

Exposing data as a service using WCF Data Services

Why do we need REST?

What is the OData Protocol?

Working with WCF Data Services and Entity Framework

Working with OData Services using WCF and ASP.NET MVC Framework

Working with Protobuf WCF Services

Advanced Concepts

Advanced Concepts

REST and REST-based service frameworks

HTTP methods, request, and response codes

New features in Entity Framework 7

Suggested reading

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

HTTP methods, request, and response codes

The following table shows the common HTTP methods and their purposes:

Method name	Purpose
`DELETE`	This is used to delete a resource
`GET`	This is used to request a specific representation of a resource
`HEAD`	This is same as `GET`, but it retrieves only the headers and not the body
`OPTIONS`	This is used to retrieve the methods supported by the resource
`POST`	This is used to post or submit data to be processed by the resource
`PUT`	This is used to create or update data using a particular representation of a resource

The following table shows the HTTP status codes and their purposes:

Status code	Description
100	Informational
200	Successful
201	Created
202	Accepted
300	Redirection
304	Not modified
400	Client error
402	Payment required
404	Not found
405	Method not allowed
500	Server error
501	Not implemented

The following table shows the HTTP redirection status codes:

Status code	Description
300	Multiple choices
301	Moved permanently
302	Found (temporary redirection)

The following table shows the HTTP error status codes:

Status code	Description
400	Bad request
401	Unauthorized
403	Forbidden
404	Resource not found
405	Method not allowed
408	Request timeout
409	Conflict
413	Request entity too large
415	Unsupported media type

The following table shows the HTTP server error status codes:

Status code	Description
500	Internal server error
501	Not implemented
503	Service unavailable
505	HTTP version not supported

The following table lists some resource methods and how they can be implemented using the HTTP protocol:

Method name	Description	HTTP operation
`createResource`	This creates a new resource	`PUT`
`getResourceRepresentation`	This is used to retrieve the representation of a particular resource	`GET`
`deleteResource`	This deletes a resource	`DELETE`
`modifyResource`	This modifies a resource	`POST`
`getMetaInformation`	This retrieves metadata of a resource	`HEAD`