Professional Entity Framework Core 2.0 & 6.x with Examples: .NET Core, C#, Entity Framework Core

by John Kocer

Professional Entity Framework Core 2.0 & 6.x with .NET Core, C#, Entity Framework Core

Professional Entity Framework Core 2.0 and 6.X present a fast jump start for developers who wants to create modern web application with latest web technologies using Visual Studio 2017 ASP.NET Core 2.0, Web APIs and Entity Framework.
Professional Entity Framework Core 2.0 and 6.x with Examples teaches developers using database functionality to .NET applications with EF Core and EF 6.x.
We will have comprehensive code creating walk through with SmartIT CodeCamp Web Application with Entity Framework Core Generic Async Operations.
We will create Code-First and Database-First SPA with ASP.NET Web API (REST) responsive design Simple Employee CRUD web application.
Create a SPA Blog Manager Web Application with jQuery .NET Entity Framework Core Generic async Operations with Generic Repository.
Entity Framework 6.x Code-First and Data-First examples are including end of the book.
We also learn best tools for verifying and testing Application APIs and much more examples and explanations…

After completing this course, you will be able
EF Core
Code-First Approached
Database-First
add migration - [Package Manager console]
update-database -verbose
DbContext
DbSet
DataContext
Loading a single entity
Update StartUp
Why chose Entity Framework Core?
LINQ
AddRange/Attach/Create/Create/Find/FindAsync
Remove/RemoveRange/SqlQuery
Lazy loading
Raw SQL Queries
Explicit data loading
Microsoft.EntityFrameworkCore.Tools.DotNet
Inserting Data/Updating data/Deleting records
EF Core and EF6 Feature by Feature Comparison
One-To-Many
Many-To-Many
One-To-One
NotMapped
Code-First Examples
Handling Concurrency
Generating entities from the database
Entity Framework Core Migrations
Creating a Migration
Removing A Migration
Applying A Migration
Reversing A Migration
Applying A Migration to A Remote Database
Migration Walk through with examples
Examine the Up and Down methods
Examine the data model snapshot
Package Manager Console Commands
Scaffold-DbContext
Script-Migration
Updating changes between Migrations
Business Layer/DataAccess Layer/UI layer
Modifying launchsettings.json
Setting your custom port number
Modifying appsettings.json file
async/await
Overriding onModelCreating
Overriding SaveChanges
Overriding Update
Overriding UpdateAsync
Overriding SaveChangesAsync
Creating audit structure
Dispose
Creating Abstract classes
Creating a new insert item
Setting start controller Route to Home Index method.
Entity Framework 6.x Database-First
Entity Framework 6.x Code-First
Creating audit structure
Add dependency Injection
Creating a new insert item
Updating an Item
Deleting an Item
Use Postman to test REST APIs (GET, PUT, POST, DELETE)
Asynchronous Queries
Three Tier Project
Change Tracking
Performance improvement
Bundling and minification
Optimize page loads with AJAX calls
Create a new Web API controller
Configure API routes
Setting of project default IIS values
Route table
Create a functional ASP.NET EF Core Web API Blog Application
Creating Generic Repository with Entity Framework.
Taking advantage of .NET generics
Creating ASP.NET Core custom API controller CRUD operations
Adding Statistic and Consuming Raw SQL Queries
Exception handling/Try/catch
Paginating View data
Lab Exercises to practice learned materials
Data Annotations
Filtering/Sorting/Paging /Grouping
Row Versioning
Change Tracking with inheritance
Debugging
Taking advantage of .NET generics
in-memory database
Interface/Generic

558 pages, Kindle Edition

Published December 2, 2017