0%

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. 

Table of Contents

  1. Cover
  2. Front Matter
  3. Part I. Getting Started
    1. 1. Installation
    2. 2. Project Structure
  4. Part II. Core Features
    1. 3. Entities
    2. 4. Database Context
    3. 5. Creating a Database from Code
    4. 6. Seeding Data
    5. 7. Getting Data
    6. 8. Inserting Data
    7. 9. Updating Data
    8. 10. Deleting Data
    9. 11. Navigation Properties
  5. Part III. Advanced Features
    1. 12. Aggregations
    2. 13. Stored Procedures
    3. 14. Migrations
  6. Part IV. A Model Web Application
    1. 15. Authentication on the Web
    2. 16. Displaying Data on the Web
    3. 17. Inserting Data on the Web
    4. 18. Updating Data on the Web
    5. 19. Deleting Data on the Web
    6. 20. Reporting on the Web
    7. 21. Authorization on the Web
  7. Part V. Learning More
    1. 22. Delving Deeper
    2. 23. Conclusion
  8. Back Matter
35.168.113.248