دانلود کتاب Beginning Entity Framework Core 5: From Novice to Professional

فهرست مطالب :

Table of Contents
About the Author
About the Technical Reviewer
Introduction
Part I: Getting Started
Chapter 1: Installation
Install Visual Studio
Create a Project
Install Entity Framework
Install the Core Tools Package
SQL Server Database
Summary
Chapter 2: Project Structure
Core Project
Unit Testing Overview
Data Access Layer Project
Main Project References
Summary
Part II: Core Features
Chapter 3: Entities
Person Entity
Address Entity
Simple Navigation Property
Entity Property Constraints
Entity Schema Attributes
More Entity Schema Attributes
Mapping of the Primary Key Column
Enum Mapping
Entity Inheritance Mapping
Table-per-Hierarchy
Table-per-Type
Summary
Chapter 4: Database Context
Creating a Simple Database Context
Connecting to Our Database
Accessing Entities in a Database Context
Saving Entity Changes
Configuring a Database Context
Set a Database Schema for All Entities
Composite Key Constraint
Primary Key Constraint
Default Property Value
Hardcoded Default Value
SQL Computer Default Value
Foreign Key Relationships
Summary
Chapter 5: Creating a Database from Code
Setting the Connection String
Creating the Initial Migration
Creating the Database from the Migration
Connect to the New Database from Visual Studio
Summary
Chapter 6: Seeding Data
Populating Lookup Data
Seeding Test Persons
Seeding Addresses
Summary
Chapter 7: Getting Data
LINQ Queries
Select Anonymous Types
Select Object Transformation
Joins in LINQ
Select the Navigation Property
Sorting Data
Method Syntax Queries
Testing Our Data
Summary
Chapter 8: Inserting Data
Inserting the Root Entity
Inserting Child Records
Primary Key Values
Identity Seeded Primary Key
Guid Primary Key
Non-computed Primary Key
Foreign Key Values
Default Values
Record Insertion Integration Tests
Summary
Chapter 9: Updating Data
Updating the Root Entity
Updating a Child Entity
Integration Test
Summary
Chapter 10: Deleting Data
Deleting the Root Entity
Deleting a Child Entity
Cascade Delete
Client Set Null Delete Behavior
Restrict Delete Behavior
Set Null Delete Behavior
Integration Test
Summary
Chapter 11: Navigation Properties
Mapping a Parent Entity in a One-to-Many Relationship
Mapping a Related Entity to Parent
One-to-Many Integration Test
Many-to-Many Relationships
Map a Relationship Through Navigation Properties
Create and Run Migration
Many-to-Many Integration Test
Summary
Part III: Advanced Features
Chapter 12: Aggregations
Unit Test Setup
Count
Adding Age to Person
Min
Max
Average
Average Unit Test
Sum
Group By
Direct Group By
Group By with Count
Group By with Min
Group By with Max
Group By with Average
Group By with Sum
Summary
Chapter 13: Stored Procedures
Add Stored Procedures to a Database
Set Up Unit Tests
Test the GetPersonsByState Stored Procedure
Test the AddLookUpItem Stored Procedure
Summary
Chapter 14: Migrations
What Is a Migration?
How to Add a Migration?
The Migration API
Common Schema Commands
Add a Column to a Table
Change a Column in a Table
Common Data Commands
Inserting Data
Deleting Data
Delete a Single Row
Delete Multiple Rows of Data
Update Data in a Migration
How to Run Migrations
Update to the Most Recent Migration
Migrate to a Specific Migration
Run Migration from Code
Automatic Data Migrations
Summary
Part IV: A Model Web Application
Chapter 15: Authentication on the Web
Install Identity NuGet Packages
Initialize Identity on App Startup
Scaffold UI
Update Database
Updating UI
Summary
Chapter 16: Displaying Data on the Web
Scaffolding UI
Generated List View and Model
Generated Details View and Model
Adding Addresses to the Details View
Adding Contacts to Navigation
Testing the App
Adding Some Polish
Summary
Chapter 17: Inserting Data on the Web
Generated Create Razor Page
Generated View
Generated Model
Person Model Validation
Adding Addresses
Address Model Validation
Enforce Address Validation in Database
Updating UI
Update the Razor Page Model
Running the App
Adding Some Polish
Update the Model
Update the UI
Summary
Chapter 18: Updating Data on the Web
Generated Edit Razor Page View
Generated Edit Razor Model
Add a Friendly Address Update
Update the Model
Update the UI
Running the App
Summary
Chapter 19: Deleting Data on the Web
Generated Delete Razor Page View
Generated Model
Updating Page Controller Code to Delete Addresses
Running the App
Showing a Person’s Address on the Delete Form
Update the Page Controller
Update the UI
Summary
Chapter 20: Reporting on the Web
Creating the Razor Page
Updating the Razor Model
Updating the Razor View
Add a Link to Navigation
Running the Report
Adding Pagination
Adding Sample Data
Adding Pagination Support
Updating the Model for Pagination
Add Pagination to the Razor View
Running the Finished Report
Summary
Chapter 21: Authorization on the Web
Enable Roles
Add Test Users
Add and Assign Roles on Startup
Enforce Authorization
Authorize the Contacts Menu Item
Secure Razor Pages
Page Access Roles
Base Secured Page Model
Secure the Contacts Index Page
Secure the Contact Details Page
Secure the Create Contact Page
Secured Contact Edit Page
Secured Contact Delete Page
Summary
Part V: Learning More
Chapter 22: Delving Deeper
Chapter 23: Conclusion
Index