Learn Entity Framework Core 2.0 (EFC2) using ASP.Net Core

Create author and book models with a one-to-one relationship and navigational properties, using a library context in EF Core and DbSet properties for Author and Book.

Register library context with dependency injection, configure sql server via UseSqlServer and appsettings, and create the database with EnsureCreated for Author and Book tables.

Perform create operations in entity framework core 2.0 using asp.net core by adding author and book data to the database, validating fields, and using save changes or save changes async.

Retrieve all books and their author details using ef core 2.0 in asp.net core with Include and AsNoTracking, and build results with StringBuilder in a BookDetails action using SingleOrDefaultAsync.

Update existing book details for a given bookId using two EF Core 2.0 methods: the context Update() with a newBook, or fetch and modify properties then save changes.

Delete a book record by retrieving it with a lambda query, removing it from the context, and saving changes, while handling invalid ids and missing records.

Explore the 10th session of Entity Framework Core 2.0 tutorials, covering create operations on book and author and update, delete, and read for book, with encouragement to practice all examples.

Explore the data first approach in entity framework core by scaffolding an existing database into models using scaffold-DbContext or dotnet ef dbcontext scaffold, generating Author, Book, and TutorialsTeamContext.

Sort and filter data with entity framework core 2.0 by retrieving books, sorting by id, price, or title, and filtering by id, price, author, or title.

Learn how entity state is tracked in Entity Framework Core 2.0, using AsNoTracking, attach, and Entry to inspect added, modified, detached, and unchanged states, and persist changes with SaveChanges.

Explore native sql statements in EF Core 2.0 by executing queries with FromSql on DbSet, using ExecuteSqlCommand for dml, and retrieving results via a db connection and data reader.

Learn to execute store procedures with Entity Framework Core 2.0 using FromSql and ADO.NET–like syntax, handling GetBooks and DeleteBook with optional id and parameters.

Learn how to perform automated and code-based migrations in Entity Framework Core 2.0, configuring the project, enabling migrations, and applying schema changes with _context.Database.Migrate().

Perform manual migrations in a code-first project using the package manager console and dotnet ef commands to add, update, and remove migrations for LibraryContext, then apply changes to the database.

Seed the database with dummy data by calling DBInitializer.Initialize during startup and ensuring the database is created. Add authors and books using AddRange and SaveChanges after checking tables are empty.

Explore data annotations in EF Core 2.0 to validate inputs and adjust schema with StringLength and Required, and use RegularExpression and Range for MVC validation (no schema change).

Disable identity on a primary key with the DatabaseGenerated attribute set to none. Use the Key attribute for custom primary keys like ISBN, and apply ForeignKey to map to AuthorIdentity.

Modify column name and type in entity framework core 2.0 by applying Column and DataType attributes to rename PublishedOn to PublishedDate for date-only storage in asp.net core.

rename a database table in entity framework core 2.0 by using Table attribute at the model class level or ToTable method in OnModelCreating, with modelBuilder.Entity showing AllBooks and Publisher.

Explore configuring models with the fluent API in Entity Framework Core 2.0, including setting keys with HasKey, disabling identity with ValueGenerateNever, and applying IsRequired, HasMaxLength, HasColumnName, and HasColumnType.

Apply a global query filter with HasQueryFilter to hide soft-deleted records by the IsDeleted flag, using HasField and EF.Property to access a private ISBN field in the Book model.

Learn to boost EF Core 2.0 performance with compiled queries using EF.CompileQuery to precompile a query that fetches book titles by id in a loop.

Learn how EF.Functions provides a like search in EF Core 2.0, using EF.Functions.Like in a SearchBook action to filter books by title with a %title% pattern and return matching results.

Discover C# string interpolation in EF Core 2.0 by using the $ sign and curly braces to build a raw SQL query with FromSql, filtering book titles and returning results.

Discover how OwnOne() in Entity Framework Core 2.0 maps two author models into a single book table, and configure Author1 and Author2 in OnModelCreating.

Learn optimistic concurrency in entity framework core 2.0 using a rowversion timestamp column and two contexts to detect and handle the db concurrency exception.

Learn how to manually manage transactions in entity framework core 2.0 using context.Database.BeginTransaction(), Commit(), and Rollback(), with SaveChanges() and EF's default transactional behavior in ASP.NET Core.

Enable and view sql queries executed by Entity Framework Core 2.0 using a custom logger provider. Bind the provider to LoggerFactory and log to both a file and the console.

Apply Entity Framework Core 2.0 concepts in ASP.NET Core applications, including data annotation and Fluent API for ASP.NET MVC. Access the full solution on GitHub to revise lessons.

Unlock bonus discounts on JSON datatype, JSON schema, ASP.Net web API 2, and Cordova—three courses for ten dollars—with a Razor View Engine course and coupons via YouTube, blog, and Facebook.