Hardly any application can do without access to the database. In this workshop you will learn the features of Entity Framework Core (EF Core) for practical use in both web and Windows applications. You will also get an insight into Azure technologies for storage like SQL Database, Table Storage, as well as Azure Cosmos DB.
Content
- Introduction to EF Core
- History of Entity Framework
- Introduction to EF Core
- Creating a Model
- Conventions, Annotations, and the Fluent API
- Creating a Context
- Creating and deleting the database from code
- Create/Read/Update/Delete (CRUD) records
- Logging- Using Dependency Injection
- Creating a Model
- Creating Relations
- Data Annotations
- Fluent API
- Self-contained Type Configurations
- Scaffolding models from the database
- Mapping to fields
- Shadow Properties
- Queries
- Basic Queries
- Client & Server Evaluation
- Raw SQL Queries
- Compiled Queries
- Global Query Filters
- EF.Functions
- Relationships
- Using Conventions
- Explicit Loading related data
- Eager Loading related data
- Relationships using annotations
- Relationships using the Fluent API
- Table per Hierarchy (TPH)
- Table per Type (TPT)
- Table per Concrete Type (TPC)
- Table Splitting
- Owned Entities
- Saving Data
- Saving relations
- Object Tracking
- Updating objects
- Dealing with untracked objects
- Batching
- Conflict Handling
- Last One Wins
- First One Wins
- Context Pooling
- Using Transactions
- Migrations
- Migrations with ASP.NET Core
- Migrations with .NET Core Console Applications
- Creating Migrations
- Applying Migrations programmatically
- Applying Migrations from the command line
- Non-relational Databases with EF Core
- SQL Database with Microsoft Azure
- Azure Table Storage
- Azure Cosmos DB