Beginning Entity Framework Core 5: From Novice to Professional

Book Description Use the code-driven approach of Entity Framework Core 5 to build a functional web application that accesses a database on the backend server. This book covers the common use cases of Entity Framework that a developer needs to master in order to begin building applications that run against a database. Throughout the book you will be shown how to use Entity Framework Core 5 by implementing a simple ASP.NET Core Razor Pages line-of-business application. This example application will be similar to those you might write yourself and deploy to your users on a web or intranet site via a browser. 

This book takes a code-first approach in which your database will be created and seeded programmatically. You won’t need to create the database through your database engine’s interface. Instead, you will be shown how to define your data model in Entity Framework, and then let Entity Framework do the work of creating your database and schema for you. From there you will learn how to seed your database with example data, then to implement the common, so-called CRUD operations consisting of creating, retrieving, updating, and deleting rows of data. By the end of the book you will have built a well-designed application that you can use as the basis for future applications that you create in your job. 

What You Will Learn

• Download and install Entity Framework Core 5
• Perform create, read, update, and delete (CRUD) operations
• Create and seed a database with example data using Entity Framework Core 5
• Incrementally add new database functionality through Entity Framework Core 5 migrations
• Recognize when to take advantage of new features introduced in Entity Framework Core 5
• Deliver line-of-business applications using ASP.NET Core that run in a browser

Who This Books Is For
Developers who are familiar with C# and the .NET Framework who want to learn database access using Entity Framework Core 5. For developers creating web-based, line-of-business applications who want to create those applications more quickly and efficiently when databases are involved. 

Content

Part I: Getting Started
Chapter 1: Installation
Chapter 2: Project Structure

Part II: Core Features
Chapter 3: Entities
Chapter 4: Database Context
Chapter 5: Creating a Database from Code
Chapter 6: Seeding Data
Chapter 7: Getting Data
Chapter 8: Inserting Data
Chapter 9: Updating Data
Chapter 10: Deleting Data
Chapter 11: Navigation Properties

Part III: Advanced Features
Chapter 12: Aggregations
Chapter 13: Stored Procedures
Chapter 14: Migrations

Part IV: A Model Web Application
Chapter 15: Authentication on the Web
Chapter 16: Displaying Data on the Web
Chapter 17: Inserting Data on the Web
Chapter 18: Updating Data on the Web
Chapter 19: Deleting Data on the Web
Chapter 20: Reporting on the Web
Chapter 21: Authorization on the Web

Part V: Learning More
Chapter 22: Delving Deeper
Chapter 23: Conclusion