Brian Gorman is a Microsoft Azure MVP, 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 re-certified with MCSA: Web Apps and MCSD: App Builder certifications in 2019. From 2019 to 2021, Brian has earned nine Azure certifications, including Azure and Data Fundamentals, Azure Administrator, Database Administrator, Security Engineer and Developer Associate certifications, Azure Solutions Architect and DevOps Expert certifications, and an IoT Specialty certification. 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.

• 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.

Brian Gorman is a Microsoft Azure MVP, 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 re-certified with MCSA: Web Apps and MCSD: App Builder certifications in 2019. From 2019 to 2021, Brian has earned nine Azure certifications, including Azure and Data Fundamentals, Azure Administrator, Database Administrator, Security Engineer and Developer Associate certifications, Azure Solutions Architect and DevOps Expert certifications, and an IoT Specialty certification. 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.

• 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.

Brian Gorman is a Microsoft Azure MVP, 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 re-certified with MCSA: Web Apps and MCSD: App Builder certifications in 2019. From 2019 to 2021, Brian has earned nine Azure certifications, including Azure and Data Fundamentals, Azure Administrator, Database Administrator, Security Engineer and Developer Associate certifications, Azure Solutions Architect and DevOps Expert certifications, and an IoT Specialty certification. 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.

• 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.