Modern Data Access with Entity Framework Core

Description

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 LearnUnderstand 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 appsBonus 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. Front Matter ....Pages i-xxxiv Introducing Entity Framework Core (Holger Schwichtenberg)....Pages 1-14 Installing Entity Framework Core (Holger Schwichtenberg)....Pages 15-29 Concepts of Entity Framework Core (Holger Schwichtenberg)....Pages 31-35 Reverse Engineering of Existing Databases (Database First Development) (Holger Schwichtenberg)....Pages 37-59 Forward Engineering for New Databases (Holger Schwichtenberg)....Pages 61-86 Customizing the Database Schema (Holger Schwichtenberg)....Pages 87-110 Database Schema Migrations (Holger Schwichtenberg)....Pages 111-128 Reading Data with LINQ (Holger Schwichtenberg)....Pages 129-182 Object Relationships and Loading Strategies (Holger Schwichtenberg)....Pages 183-206 Inserting, Deleting, and Modifying Records (Holger Schwichtenberg)....Pages 207-249 Preventing Conflicts (Concurrency) (Holger Schwichtenberg)....Pages 251-273 Logging (Holger Schwichtenberg)....Pages 275-285 Asynchronous Programming (Holger Schwichtenberg)....Pages 287-293 Dynamic LINQ Queries (Holger Schwichtenberg)....Pages 295-304 Reading and Modifying Data with SQL, Stored Procedures, and Table-Valued Functions (Holger Schwichtenberg)....Pages 305-315 Tips and Tricks for Mapping (Holger Schwichtenberg)....Pages 317-376 Performance Tuning (Holger Schwichtenberg)....Pages 377-433 Software Architecture with Entity Framework Core (Holger Schwichtenberg)....Pages 435-445 Commercial Tools (Holger Schwichtenberg)....Pages 447-494 Additional Components (Holger Schwichtenberg)....Pages 495-542 Case Studies (Holger Schwichtenberg)....Pages 543-630 Internet Resources (Holger Schwichtenberg)....Pages 631-631 New Features in Entity Framework Core 2.1 (Holger Schwichtenberg)....Pages 633-633 Back Matter ....Pages 635-644