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.

Related Content you might be interested in

Current Title:

Small book image
Entity Framework Tutorial (Update) - Second Edition
Joydip Kanjilal
Aug, 2015 | 274 pages
No titles found
Table of Contents (16 chapters)
Entity Framework Tutorial Second Edition
Entity Framework Tutorial Second Edition
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Introducing the ADO.NET Entity Framework
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
2
Getting Started
Getting Started
Designing the UserAuthentication database
Creating the EDM
The DataSource controls
Implementing our first application using the Entity Framework
Summary
3
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
Summary
4
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
Summary
5
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
Summary
6
Working with LINQ to Entities
Working with LINQ to Entities
Introducing LINQ
Understanding the LINQ architecture
Parallel LINQ
Operators in LINQ
Querying data using LINQ
Summary
7
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
Summary
8
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
Summary
Advanced Concepts
Advanced Concepts
REST and REST-based service frameworks
HTTP methods, request, and response codes
Abbreviations
New features in Entity Framework 7
Suggested reading
Index
Index

About the Author

Joydip Kanjilal has won a Microsoft Most Valuable Professional (MVP) award in ASP.NET. He is a speaker and author of several books and articles. He has over 18 years of industry experience in IT, with more than 12 years in Microsoft .NET and its related technologies. Joydip is currently working as a Principal Architect at SenecaGlobal IT Services Private Limited, Hyderabad. He has been selected as an MSDN Featured Developer of the Fortnight (MSDN) a number of times and has also been a Community Credit Winner at www.community-credit.com several times. He has authored the following books:

  • ASP.NET Web API: Build RESTful Web Applications and Services on the .NET Framework by Packt Publishing

  • Visual Studio 2010 and .NET 4 Six-in-One by Wrox Publishers

  • ASP.NET 4.0 Programming by Mc-Graw Hill Publishing

  • Entity Framework Tutorial by Packt Publishing

  • Pro Sync Framework by APRESS

  • Sams Teach Yourself ASP.NET Ajax in 24 Hours by Sams Publishing

  • ASP.NET Data Presentation Controls Essentials by Packt Publishing

He has authored more than 250 articles for some of the most reputable sites, such as www.msdn.microsoft.com, www.code-magazine.com, www.asptoday.com, www.devx.com, www.ddj.com, www.aspalliance.com, www.aspnetpro.com, www.sql-server-performance.com, www.sswug.com, and so on. A lot of these articles have been selected at www.asp.net, Microsoft's official site on ASP.NET.

He has years of experience in designing and architecting solutions for various domains. His technical strengths include C, C++, VC++, Java, C#, Microsoft .NET, AJAX, WCF, web-based APIs, REST, SOA, design patterns, SQL Server, operating systems, and computer architecture.

He can be contacted at:

Writing a book has always been a rewarding experience for me. My special thanks to the entire Packt team for providing me with the opportunity to author this book—and turn this idea into reality. I am also thankful to the entire management team at SenecaGlobal for their continued support. I was delighted by the warm welcome I received when I joined the company and also for the inspiration I received from the management team here. I am very happy to be a part of this wonderful team.

My deepest respect and gratitude to my parents for their love, blessings, and encouragement. My special thanks to my wife for her continued inspiration and support. I am also thankful to my sister, and little Jini in particular, for their support.

Thank you all so much!

Previous Section
Next Chapter