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 (filte...

Full description

Bibliographic Details
Main Author: Gorman, Brian L.
Format: eBook
Language:English
Published: Berkeley, CA Apress 2022, 2022
Edition:2nd ed. 2022
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
LEADER 03546nmm a2200301 u 4500
001 EB002010159
003 EBX01000000000000001173058
005 00000000000000.0
007 cr|||||||||||||||||||||
008 220201 ||| eng
020 |a 9781484273012 
100 1 |a Gorman, Brian L. 
245 0 0 |a Practical Entity Framework Core 6  |h Elektronische Ressource  |b Database Access for Enterprise Applications  |c by Brian L. Gorman 
250 |a 2nd ed. 2022 
260 |a Berkeley, CA  |b Apress  |c 2022, 2022 
300 |a XXIX, 797 p. 449 illus  |b online resource 
505 0 |a 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 
653 |a Microsoft software 
653 |a Microsoft 
653 |a Database Management 
653 |a Microsoft .NET Framework 
653 |a Database management 
041 0 7 |a eng  |2 ISO 639-2 
989 |b Springer  |a Springer eBooks 2005- 
028 5 0 |a 10.1007/978-1-4842-7301-2 
856 4 0 |u https://doi.org/10.1007/978-1-4842-7301-2?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 5,268 
520 |a 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