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

  • 5h 38m
  • Holger Schwichtenberg
  • Apress
  • 2018

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.

About the Author

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.

In this Book

  • Introducing Entity Framework Core
  • Installing Entity Framework Core
  • Concepts of Entity Framework Core
  • Reverse Engineering of Existing Databases (Database First Development)
  • Forward Engineering for New Databases
  • Customizing the Database Schema
  • Database Schema Migrations
  • Reading Data with LINQ
  • Object Relationships and Loading Strategies
  • Inserting, Deleting, and Modifying Records
  • Preventing Conflicts (Concurrency)
  • Logging
  • Asynchronous Programming
  • Dynamic LINQ Queries
  • Reading and Modifying Data with SQL, Stored Procedures, and Table-Valued Functions
  • Tips and Tricks for Mapping
  • Performance Tuning
  • Software Architecture with Entity Framework Core
  • Commercial Tools
  • Additional Components
SHOW MORE
FREE ACCESS

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 43 users Rating 4.5 of 43 users (43)