Practical Entity Framework Core 6
Description
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
More details
Other editions
Additional editions
Person
Additionally, Brian 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. Most recently, Brian has been employed as a Senior Training Architect with Opsgility.
In addition to working with .NET technologies, Brian has been an adjunct faculty member in the computer science department for Franklin University for the last 11 years, where his courses have included data structures, algorithms, design patterns, and, more recently, full-stack solutions in the capstone practicum course.
Content
Introduction.- Part I. Getting Started.- 1. Introduction to Entity Framework.- 2. Working with an Existing Database.- 3. Entity Framework: Code First.- Part II. Building the Data Solution.- 4. Models and the Data Context.- 5. Constraints, Keys, and Relationships.- 6. Data Access (Create, Read, Update, Delete).- 7. Stored Procedures, Views, and Functions.- 8. Sorting, Filtering, and Paging.- Part III. Enhancing the Data Solution.- 9. LINQ for Queries and Projections.- 10. Encryption of Data.- 11. Repository and Unit of Work Patterns.- 12. Unit Testing, Integration Testing, and Mocking.- 13. Asynchronous Data Operations and Multiple Database Contexts.- Part IV. Recipes for Success.- 14. .NET 5 and EFCore5.- 15. .NET 6 and EF Core 6.- 16. Appendix A: Troubleshooting.
