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.
Table of Contents (16 chapters)
Entity Framework Tutorial Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Working with the ADO.NET Entity Client


The ADO.NET Entity Client is a data provider that provides a gateway to execute entity level queries using Entity Framework. You can use it to query against your conceptual model of data. Entity Client uses its own language called E-SQL, a storage independent language, to communicate with the conceptual model. You can execute the same E-SQL query against any data store. In other words, it is provider independent, and you need not make changes to your query if the underlying data store changes. Therefore, you can use the same E-SQL syntax to communicate to the conceptual model, regardless of the data store in use.

The E-SQL queries are converted to a command tree that is in turn passed to the storage-specific provider to generate native SQL statements. As an example, if you are using SQL Server as the database, the E-SQL queries that you are using will be converted to a command tree that will be passed to the ADO.NET provider for the SQL Server. This...