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