Modern Data Access with Entity Framework Core

Modern Data Access with Entity Framework Core: Database Programming Techniques for .NET, .NET Core, UWP, and Xamarin with C#

C# developers, here’s your opportunity to learn the ins-and-outs of Entity Framework Core, Microsoft’s recently redesigned object-relational mapper. Benefit from hands-on learning that will teach you how to tackle frustrating database challenges, such as workarounds to missing features in Entity Framework Core, and learn how to optimize the performance of your applications, head-on! 

Modern Data Access with Entity Framework Core teaches best practices, guidance, and shortcuts that will significantly reduce the amount of resources you internally dedicate to programming data access code. The proven methods and tools taught in this book, such as how to get better performance, and the ability to select the platform of your choice, will save you valuable time and allow you to create seamless data access. Dive into succinct guidance that covers the gamut– from installing Entity Framework Core, reverse engineering, forward engineering (including schema migrations), and data reading and modification with LINQ, Dynamic LINQ, SQL, Stored Procedures, and Table Valued Functions- to using third-party products such as LINQPad, Entity Developer, Entity Framework Profiler, EFPlus, and AutoMapper. You’ll also appreciate excerpts of conceptual software architecture discussion around Entity Framework Core that might otherwise take years to learn.

What You’ll Learn

• Understand the core concepts of Entity Framework Core, as well process models for existing databases (reverse engineering) and the generation of database schemas from object models (forward engineering)
• Study real-world case studies for hands-on EF Core instruction
• Get up to speed with valuable database access scenarios and code samples
• Discover workarounds to augment missing features in Entity Framework Core
• Use Entity Framework Core to write mobile apps
• Bonus online appendix covers Entity Framework Core 2.1 release updates

Who This Book Is For

Software developers who have basic experience with .NET and C#, as well as some understanding of relational databases. Knowledge of predecessor technologies such as ADO.NET and the classic ADO.NET Entity Framework is not necessary to learn from this book.

Table of Contents

Chapter 1: Introducing Entity Framework Core
Chapter 2: Installing Entity Framework Core
Chapter 3: Concepts of Entity Framework Core
Chapter 4: Reverse Engineering of Existing Databases (Database First Development)
Chapter 5: Forward Engineering for New Databases
Chapter 6: Customizing the Database Schema
Chapter 7: Database Schema Migrations
Chapter 8: Reading Data with LINQ
Chapter 9: Object Relationships and Loading Strategies
Chapter 10: Inserting, Deleting, and Modifying Records
Chapter 11: Preventing Conflicts (Concurrency)
Chapter 12: Logging
Chapter 13: Asynchronous Programming
Chapter 14: Dynamic LINQ Queries
Chapter 15: Reading and Modifying Data with SQL, Stored Procedures, and  Table-­Valued Functions
Chapter 16: Tips and Tricks for Mapping
Chapter 17: Performance Tuning
Chapter 18: Software Architecture with  Entity Framework Core
Chapter 19: Commercial Tools
Chapter 20: Additional Components
Appendix A: Case Studies
Appendix B: Internet Resources
Appendix C: New Features in Entity Framework Core 2.1