Modern Data Access with Entity Framework Core

Database Programming Techniques for .NET, .NET Core, UWP, and Xamarin with C#

  • Holger Schwichtenberg

Table of contents

  1. Front Matter
    Pages i-xxxiv
  2. Holger Schwichtenberg
    Pages 1-14
  3. Holger Schwichtenberg
    Pages 15-29
  4. Holger Schwichtenberg
    Pages 31-35
  5. Holger Schwichtenberg
    Pages 61-86
  6. Holger Schwichtenberg
    Pages 87-110
  7. Holger Schwichtenberg
    Pages 111-128
  8. Holger Schwichtenberg
    Pages 129-182
  9. Holger Schwichtenberg
    Pages 183-206
  10. Holger Schwichtenberg
    Pages 207-249
  11. Holger Schwichtenberg
    Pages 251-273
  12. Holger Schwichtenberg
    Pages 275-285
  13. Holger Schwichtenberg
    Pages 287-293
  14. Holger Schwichtenberg
    Pages 295-304
  15. Holger Schwichtenberg
    Pages 317-376
  16. Holger Schwichtenberg
    Pages 377-433
  17. Holger Schwichtenberg
    Pages 435-445
  18. Holger Schwichtenberg
    Pages 447-494
  19. Holger Schwichtenberg
    Pages 495-542
  20. Holger Schwichtenberg
    Pages 543-630
  21. Holger Schwichtenberg
    Pages 631-631
  22. Holger Schwichtenberg
    Pages 633-633
  23. Back Matter
    Pages 635-644

About this book


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 optimizing 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. Get ready to learn everything 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
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. 

​Holger Schwichtenberg is a Microsoft MVP and a technical lead with the German company IT-Visions, where he consults and trains developers throughout Europe. He also serves as software architect for 5Minds IT-Solutions. Holger is a huge fan of Entity Framework and Entity Framework Core and regularly speaks on the topics at events. Holger has a Ph.D. in business informatics.


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

Authors and affiliations

  • Holger Schwichtenberg
    • 1
  1. 1.EssenGermany

Bibliographic information

Industry Sectors
Finance, Business & Banking
IT & Software