Sams Teach Yourself the Ado.net Entity Framework in 24 Hours

by Kimmel, Paul

• ISBN13: 9780672330537
• ISBN10: 0672330539
• Edition: 1st
• Format: Paperback
• Copyright: 2020-02-09
• Publisher: Sams Publishing

Summary

The complete hands-on tutorial for Microsoft' breakthrough ADO.NET Entity Framework- ADO.NET Entity Framework offers unprecedented power in accessing data, but requires radically new skills: this book is the fastest, easiest way to master those skills.- Covers everything from building Entity Data Models to advanced techniques such as native views and IPOCO.- A complete tutorial package: step-by-step instructions, QandAs, quizzes, exercises, tips, shortcuts, and more The ADO.NET Entity Framework is radically different from earlier versions of ADO.NET: even experienced ADO.NET programmers will have to master completely new skillsets to make the most of it. When they do, however, they will be rewarded with remarkable power and flexibility in how they use data in their applications. In just 24 step-by-step lessons of one hour or less, Samswill help readers start using the Teach Yourself the ADO.NET Entity Framework ADO.NET Entity Framework to solve real-world business problems. This friendly, accessible book covers the entire framework, without ever becoming overwhelming or intimidating. Readers will learn how to build and query entity data models; perform advanced querying with Entity SQL and LINQ to Entities; create relationships, stored procedures, and transactions; integrate with WinForms, ASP.NET, and WCF Services; and even use native views, multiple entity sets, and IPOCO. Step-by-step instructions walk readers through their most common questions, issues, and tasks... Q and As, Quizzes, and Exercises help them test their knowledge... 'Did You Know?' tips offer insider advice and shortcuts... and 'Watch Out!' alerts help them avoid problems.

Author Biography

Paul Kimmel (Lansing, MI) is a five-time Microsoft MVP, and the author of over a dozen books on object-oriented programming and UML, including three books on Microsoft .NET. He is also a columnist for codeguru.com, developer.com, informit.com, devsource.com, and devx.com; a co-founder of the Greater Lansing Area .NET Users Group (glugnet.org, East Lansing and Flint); and a full-time software developer. After 15 years of independent consulting, he now works for EDS as an application architect. His books include LINQ Unleashed for C#.

Table of Contents

Creating and Querying an Entity Data Model

Learning Scenarios that Warrant the Entity Framework

Creating an Entity Data Model (14 Pages)

Querying with Entity SQL

Mapping Relationships

Querying with LINQ to Entities

Defining Advanced Mapping Relationships

Advanced Querying with Entity SQL and LINQ to Entities

Exploring Entity SQL Further

Mapping Many to Many Relationships s

Creating an Entity Data Model with EdmGen.exe

Writing Advanced Queries with LINQ to Entities

Updating Data with Entity SQL

Updating Data with LINQ to SQL

Exploring Relationships, Stored Procedures and Transactions

Using Stored Procedures and Transactions with the Entity Framework

Defining Inheritance Relationships

Using Referential Integrity Constraints

Tracking Entity Instances and Relationships with the ObjectStateManager

WinForms, ASP.NET, and WCF Services

Databinding in WinForms and WPF

Programming ASP.NET with the Entity Framework

Spanning and Relationship Spanning

Using the Entity Framework for Services

Native Views, Multiple Entity Sets, and IPOCO

Using Directory Macros

Using Read-Only Native SQL Views

Using Multiple Entity Sets per Type

IPOCO

Table of Contents provided by Publisher. All Rights Reserved.