Entity Framework Tutorial - Second Edition

A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projects

Entity Framework Tutorial - Second Edition

This ebook is included in a Mapt subscription
Joydip Kanjilal

1 customer reviews
A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projects
$0.00
$35.99
$44.99
$29.99p/m after trial
RRP $35.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781783550012
Paperback274 pages

Book Description

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.

Table of Contents

Chapter 1: Introducing the ADO.NET Entity Framework
What you should know
Looking back
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
Summary
Chapter 2: Getting Started
Designing the UserAuthentication database
Creating the EDM
The DataSource controls
Implementing our first application using the Entity Framework
Summary
Chapter 3: Entities, Relationships, and the Entity Data Model
Entities, entity types, and relationships in the EDM
Exploring the Security EDM
Summary
Chapter 4: 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
Summary
Chapter 5: 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
Summary
Chapter 6: Working with LINQ to Entities
Introducing LINQ
Understanding the LINQ architecture
Parallel LINQ
Operators in LINQ
Querying data using LINQ
Summary
Chapter 7: 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
Summary
Chapter 8: 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
Summary

What You Will Learn

  • Explore the features of the ADO.NET Entity Framework
  • Understand the concepts of entities and their relationships
  • Create an Entity Data Model using the ADO.NET Entity Data Model Designer and the EdmGen tool
  • Extend existing Entity Types to create your own Entity Types
  • Write programs against the Entity Data Model to perform CRUD operations
  • Discover ADO.NET Data Services and learn how they can be used with the Entity Framework
  • Familiarize yourself with WCF Data Services (formerly ADO.NET Data Services)
  • Apply Code First, Model First and Database First approaches

Authors

Table of Contents

Chapter 1: Introducing the ADO.NET Entity Framework
What you should know
Looking back
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
Summary
Chapter 2: Getting Started
Designing the UserAuthentication database
Creating the EDM
The DataSource controls
Implementing our first application using the Entity Framework
Summary
Chapter 3: Entities, Relationships, and the Entity Data Model
Entities, entity types, and relationships in the EDM
Exploring the Security EDM
Summary
Chapter 4: 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
Summary
Chapter 5: 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
Summary
Chapter 6: Working with LINQ to Entities
Introducing LINQ
Understanding the LINQ architecture
Parallel LINQ
Operators in LINQ
Querying data using LINQ
Summary
Chapter 7: 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
Summary
Chapter 8: 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
Summary

Book Details

ISBN 139781783550012
Paperback274 pages
Read More
From 1 reviews

Read More Reviews