Modern Data Access with Entity Framework Core

1. Front Matter

   Pages i-xxxiv

   PDF

2. Introducing Entity Framework Core

   • Holger Schwichtenberg

   Pages 1-14

3. Installing Entity Framework Core

   • Holger Schwichtenberg

   Pages 15-29

4. Concepts of Entity Framework Core

   • Holger Schwichtenberg

   Pages 31-35

5. Reverse Engineering of Existing Databases (Database First Development)

   • Holger Schwichtenberg

   Pages 37-59

6. Forward Engineering for New Databases

   • Holger Schwichtenberg

   Pages 61-86

7. Customizing the Database Schema

   • Holger Schwichtenberg

   Pages 87-110

8. Database Schema Migrations

   • Holger Schwichtenberg

   Pages 111-128

9. Reading Data with LINQ

   • Holger Schwichtenberg

   Pages 129-182

10. Object Relationships and Loading Strategies

    • Holger Schwichtenberg

    Pages 183-206

11. Inserting, Deleting, and Modifying Records

    • Holger Schwichtenberg

    Pages 207-249

12. Preventing Conflicts (Concurrency)

    • Holger Schwichtenberg

    Pages 251-273

13. Logging

    • Holger Schwichtenberg

    Pages 275-285

14. Asynchronous Programming

    • Holger Schwichtenberg

    Pages 287-293

15. Dynamic LINQ Queries

    • Holger Schwichtenberg

    Pages 295-304

16. Reading and Modifying Data with SQL, Stored Procedures, and Table-Valued Functions

    • Holger Schwichtenberg

    Pages 305-315

17. Tips and Tricks for Mapping

    • Holger Schwichtenberg

    Pages 317-376

18. Performance Tuning

    • Holger Schwichtenberg

    Pages 377-433

19. Software Architecture with Entity Framework Core

    • Holger Schwichtenberg

    Pages 435-445

20. Commercial Tools

    • Holger Schwichtenberg

    Pages 447-494

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. 

• Entity Framework Core
• EFCore
• Data Access
• No-SQL Database
• Relational Database
• Microsoft SQL Server
• SQLite
• ORM
• .NET
• .NET Core
• Object-Relational Mapper
• Universal Windows Platform
• UWP
• Entity Framework Profiler
• Xamarin
• EFPlus
• LINQPad
• AutoMapper
• Entity Developer
• EF Core 2.0

• Essen, Germany

  Holger Schwichtenberg

Dr. Holger Schwichtenberg is a .NET MVP with more than 20 years of experience as a developer and trainer. He is currently a technical lead with the German company IT-Visions, where he consults and trains at companies throughout Europe. He also serves as a software architect for 5Minds IT-Solutions. Holger is a huge fan of Entity Framework and Entity Framework Core and regularly speaks about both. He has used EF in projects of all sizes, most recently, on a big data project containing billions of records. He is a prolific writer, having published more than 65 books and 1,000 technical articles in well-known IT professional and developer journals, including MSDN. He has presented at events such as TechEd Europe, Microsoft IT Forum, Advanced Developer Conference, Microsoft Launch, MSDN Technical Summit, and others. Holger has a Ph.D. in business informatics. 

 

Policies and ethics