Tenny / Hirani Entity Framework 4.0 Recipes

A Problem-Solution Approach
1. Auflage 2010
ISBN: 978-1-4302-2704-5
Verlag: Apress
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 648 Seiten

provides an exhaustive collection of ready-to-use code solutions for Entity Framework, Microsoft’s vision for the future of data access. Entity Framework is a model-centric data access platform with an ocean of new concepts and patterns for developers to learn. With this book, you will learn the core concepts of Entity Framework through a broad range of clear and concise solutions to everyday data access tasks. Armed with this experience, you will be ready to dive deep into Entity Framework, experiment with new approaches, and develop ways to solve even the most difficult data access challenges. If you are a developer who likes to learn by example, then this is the right book for you.

• Gives ready-to-use, real-world recipes to help you with everyday tasks
• Provides guideposts for learning core concepts
• Maps out key landmarks for experimenting with your own solutions

Autoren/Hrsg.

Tenny, Larry

Hirani, Zeeshan

Inhaltsverzeichnis

1;Title Page;1
2;Copyright Page;2
3;Contents at a Glance;4
4;Table of Contents;5
5;About the Authors;30
6;About the Technical Reviewers;31
7;Acknowledgments;32
8;Preface;33
8.1;Who This Book Is For;33
8.2;What’s in This Book;34
8.3;About the Recipes;35
8.4;Stuff You Need to Get Started;36
8.5;Code Examples;36
8.6;The Database;36
8.7;Apress Website;37
9;CHAPTER 1 Getting Started With Entity Framework;38
9.1;A Brief Tour of the Entity Framework World;39
9.1.1;Models;39
9.1.2;Terminology;40
9.1.3;Code;41
9.1.4;Visual Studio 2010;41
9.2;Using Entity Framework;42
10;CHAPTER 2 Entity Data Modeling Fundamentals;46
10.1;2-1. Creating a Simple Model;46
10.1.1;Problem;46
10.1.2;Solution;46
10.1.3;How It Works;51
10.2;2-2. Creating a Model from an Existing Database;53
10.2.1;Problem;53
10.2.2;Solution;53
10.2.3;How It Works;56
10.3;2-3. Modeling a Many-to-Many Relationship with No Payload;59
10.3.1;Problem;59
10.3.2;Solution;59
10.3.3;How It Works;60
10.4;2-4. Modeling a Many-to-Many Relationship with a Payload;63
10.4.1;Problem;63
10.4.2;Solution;63
10.4.3;How It Works;64
10.5;2-5. Modeling a Self-Referencing Relationship;66
10.5.1;Problem;66
10.5.2;Solution;66
10.5.3;How It Works;67
10.6;2-6. Splitting an Entity Across Multiple Tables;70
10.6.1;Problem;70
10.6.2;Solution;70
10.6.3;How It Works;72
10.7;2-7. Splitting a Table Across Multiple Entities;74
10.7.1;Problem;74
10.7.2;Solution;74
10.7.3;How It Works;77
10.8;2-8. Modeling Table per Type Inheritance;79
10.8.1;Problem;79
10.8.2;Solution;79
10.8.3;How It Works;81
10.9;2-9. Using Conditions to Filter an ObjectSet;83
10.9.1;Problem;83
10.9.2;Solution;83
10.9.3;How It Works;85
10.10;2-10. Modeling Table per Hierarchy Inheritance;86
10.10.1;Problem;86
10.10.2;Solution;86
10.10.3;How It Works;89
10.11;2-11. Modeling Is-a and Has-a Relationships Between Two Entities;91
10.11.1;Problem;91
10.11.2;Solution;92
10.11.3;How It Works;93
10.12;2-12. Creating, Modifying, and Mapping Complex Types;94
10.12.1;Problem;94
10.12.2;Solution;95
10.12.3;How It Works;96
11;CHAPTER 3 Querying an Entity Data Model;99
11.1;3-1. Executing an SQL Statement;99
11.1.1;Problem;99
11.1.2;Solution;99
11.1.3;How It Works;101
11.2;3-2. Returning Objects from a SQL Statement;102
11.2.1;Problem;102
11.2.2;Solution;102
11.2.3;How It Works;103
11.3;3-3. Returning Objects from an Entity SQL Statement;104
11.3.1;Problem;104
11.3.2;Solution;104
11.3.3;How It Works;106
11.4;3-4. Specifying Fully Qualified Names in Entity SQL;108
11.4.1;Problem;108
11.4.2;Solution;108
11.4.3;How It Works;110
11.5;3-5. Finding a Master that Has Detail in a Master-Detail Relationship;110
11.5.1;Problem;110
11.5.2;Solution;110
11.5.3;How It Works;112
11.6;3-6. Setting Default Values in a Query;113
11.6.1;Problem;113
11.6.2;Solution;113
11.6.3;How It Works;115
11.7;3-7. Returning Multiple Result Sets From a Stored Procedure;116
11.7.1;Problem;116
11.7.2;Solution;116
11.7.3;How It Works;117
11.8;3-8. Comparing Against a List of Values;118
11.8.1;Problem;118
11.8.2;Solution;118
11.8.3;How It Works;120
11.9;3-9. Building and Executing a Query Against an ObjectSet