Practical Entity Framework Core 6: Database Access for Enterprise Applications

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. 

Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.

What You Will Learn

• Build robust and maintainable databases using a code first approach
• Create and execute stored procedures, triggers, and functions
• Analyze and optimize performance of database queries
• Ensure data integrity through keys, constraints, and relationships
• Encrypt your database columns at rest with TDE and Always-On Encryption 
• Leverage the FluentAPI and attributes for entity configuration

Who This Book Is For
.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

這本書是一個開發者的旅程，從.NET和C#開始，使用選擇的物件關聯映射器（ORM）來實現企業級數據庫訪問。第二版修訂了Entity Framework Core 5和6（EF），並包括有關表對類型映射、LINQ改進（過濾包含）、多對多導航更改、分割查詢、使用DBCommandInterceptor進行簡單日誌記錄以及EF Core 6中的其他改進的新內容。本書提供了實際的示例和考慮因素，以幫助您創建強大而高效的數據庫解決方案。在整個文本中，我們提供了實際問題、問題和常見陷阱，以幫助您識別在不同應用場景中實現最佳解決方案以取得最大成功的方法。

《實用Entity Framework Core 6》專注於使用代碼優先方法開發數據庫。使用代碼優先方法，可以使用EF Core 6在代碼中構建和維護整個數據庫，因此永遠不會出現無法還原數據庫模式的情況。此外，代碼優先方法在源代碼控制系統（如GitHub）中創建了對數據庫更改的完全透明記錄，易於跟踪。本書強調讓您在組織中具備架構和領導數據開發工作的良好位置。

您將學到以下內容：
- 使用代碼優先方法構建強大且易於維護的數據庫
- 創建和執行存儲過程、觸發器和函數
- 分析和優化數據庫查詢的性能
- 通過鍵、約束和關係確保數據完整性
- 使用TDE和Always-On Encryption在休息時加密數據庫列
- 利用FluentAPI和屬性進行實體配置

本書適合以下讀者：
- .NET開發人員，他們處理企業級應用程序並需要與後端數據存儲中的數據結構和數據進行交互
- 希望採用代碼優先方法構建數據庫應用程序以防止衝突並優化效率的開發人員
- 那些轉向全棧角色、高級和架構角色的人，將負責數據庫設計和實施

Brian Gorman is a developer, computer science instructor, and trainer, and has been working in .NET technologies as long as they have existed. He was originally MCSD certified in .NET 1 and has recently re-certified with MCSA: Web Apps and MCSD: App Builder certifications. Additionally, he became an MCT as of April 2019, and is focusing on developing and training developers with full-stack web solutions with .NET Core and Azure. In addition to working with .NET technologies, Brian also teaches computer science for Franklin University, where his courses have included data structures, algorithms, design patterns, and, more recently, full-stack solutions in the capstone practicum course.

Brian Gorman 是一位開發人員、計算機科學講師和培訓師，並且在 .NET 技術領域工作已經有很長時間了。他最初在 .NET 1 中獲得了 MCSD 認證，最近又通過了 MCSA: Web Apps 和 MCSD: App Builder 認證重新認證。此外，他於2019年4月成為了MCT，並專注於使用.NET Core和Azure開發和培訓全棧網絡解決方案的開發人員。除了使用.NET技術外，Brian還在Franklin大學教授計算機科學，他的課程包括數據結構、算法、設計模式，以及最近的全棧解決方案在實踐課程中的應用。