A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projectsAbout This Book• Create Entity data models from your database and use them in your applications• Learn about the Entity Client data provider and write statements in Entity SQL to perform CRUD operations• Explore ADO.NET Data Services and how they work with the Entity FrameworkWho This Book Is ForIf you are a C# developer who wants to learn a new way of querying data and utilizing it in applications efficiently for data binding or other operations, then this book is for you. Basic knowledge of ADO.NET is assumed.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 approachesIn DetailThe 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.Style and approachThis book is a step-by-step tutorial providing hands-on code examples with detailed explanations. The book aims to explain the concepts of the Entity Framework and illustrate how you can use these in applications with a tutorial based approach.

A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projects About This Book Create Entity data models from your database and use them in your applications Learn about the Entity Client data provider and write statements in Entity SQL to perform CRUD operations Explore ADO.NET Data Services and how they work with the Entity Framework Who This Book Is For If you are a C# developer who wants to learn a new way of querying data and utilizing it in applications efficiently for data binding or other operations, then this book is for you. Basic knowledge of ADO.NET is assumed. 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 In Detail 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. Style and approach This book is a step-by-step tutorial providing hands-on code examples with detailed explanations. The book aims to explain the concepts of the Entity Framework and illustrate how you can use these in applications with a tutorial based approach.

In addition to Code First, EF 4.1 introduces simpler EF coding patterns with the DbContext, DbSet, ChangeTracker and Validation APIs. This mini-book will take the reader on a tour of these features and how to take advantage of them.

Annotation Code first is an additional means of building a model to be used with the Entity Framework and is creating a lot of excitement in the .NET development community. The reader will begin with an overview of what code first is, why it was created, how it fits into the Entity Framework and when to use it over the alternatives.

Summary Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. Following the crystal-clear explanations, real-world examples, and around 100 diagrams, you'll discover time-saving patterns and best practices for security, performance tuning, and unit testing. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology There's a mismatch in the way OO programs and relational databases represent data. Entity Framework is an object-relational mapper (ORM) that bridges this gap, making it radically easier to query and write to databases from a .NET application. EF creates a data model that matches the structure of your OO code so you can query and write to your database using standard LINQ commands. It will even automatically generate the model from your database schema. About the Book Using crystal-clear explanations, real-world examples, and around 100 diagrams, Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. You'l start with a clear breakdown of Entity Framework, long with the mental model behind ORM. Then you'll discover time-saving patterns and best practices for security, performance tuning, and even unit testing. As you go, you'll address common data access challenges and learn how to handle them with Entity Framework. What's Inside Querying a relational database with LINQ Using EF Core in business logic Integrating EF with existing C# applications Applying domain-driven design to EF Core Getting the best performance out of EF Core Covers EF Core 2.0 and 2.1 About the Reader For .NET developers with some awareness of how relational databases work. About the Author Jon P Smith is a full-stack developer with special focus on .NET Core and Azure. Table of Contents Part 1 - Getting started Introduction to Entity FrameworkCore Querying the database Changing the database content Using EF Core in business logic Using EF Core in ASP.NET Core web applications Part 2 - Entity Framework in depth Configuring nonrelational properties Configuring relationships Configuring advanced features and handling concurrency conflicts Going deeper into the DbContext Part 3 - Using Entity Framework Core in real-world applications Useful software patterns for EF Core applications Handling database migrations EF Core performance tuning A worked example of performance tuning Different database types and EF Core services Unit testing EF Core applications Appendix A - A brief introduction to LINQ Appendix B - Early information on EF Core version 2.1

Your hands-on guide to Entity Framework fundamentals Expand your expertise—and teach yourself the fundamentals of the Microsoft ADO.NET Entity Framework 5. If you have previous programming experience but are new to the Entity Framework, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. Discover how to: Access data in a managed way—using minimal code Apply three workflows supported by the Entity Framework Perform essential tasks with full automation in place Manipulate data with both LINQ and Entity SQL Create examples that rely on Table-Valued Functions Determine the remedies for Entity-specific exceptions Explore the use of optimistic and pessimistic concurrency Define mappings between your applications and data sources

If you use Entity Framework in Visual Studio 2008 and .NET 3.5, this is the book you want. Programming Entity Framework, 1st Edition offers experienced developers a thorough introduction to Microsoft's core framework for modeling and interacting with data in .NET applications. This hands-on tour provides a deep understanding of Entity Framework's architecture and APIs, and explains how to use the framework in a variety of applications built with Visual Studio 2008 and .NET 3.5. From the Entity Data Model (EDM) and Object Services to EntityClient and the Metadata Workspace, this highly acclaimed first edition covers it all. Understand the core concepts you need to make the best use of the Entity Framework (EF) in your applications Learn to query your data, using either LINQ to Entities or Entity SQL Create Windows Forms, WPF, and ASP.NET applications Build ASMX web services and WCF services Use Object Services to work directly with your entity objects Delve into model customization, relationship management, change tracking, data concurrency, and more One important note: while many of the lessons from this book will continue to be valuable as you move to .NET 4, the thoroughly revised second edition of Programming Entity Framework (August 2010) specifically targets Visual Studio 2010 and .NET 4 -- where there have been many advancements and additions to the framework.