Learning Entity Framework Core

Course

Online

£ 150 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Learning Entity Framework Core from scratch for building efficient and secure web applications.Entity Framework is a highly recommended Object Relation Mapping tool used to build complex systems. This course provides a full learning path to getting productive with the Entity Framework Core. Designed with the intermediate developer in mind and utilizing all of the latest features introduced by EF Core 2.0 and ASP.NET Core 2.0. In this course, you will learn how to create, execute and rollback your own migrations. You will also get familiar with everything you need to create complex relational models. You will explore some of the most important advanced features of the entity framework like shadow properties, database generated values and raw SQL queries. You will know how to take an existing database and write a project based upon it with minimal intervention.By the end of this course, you will certainly have added Entity Framework Core to your toolbox.About The AuthorDimitris Loukas is a software engineer currently writing Single Page Applications and APIs using Aurelia, ASP.NET Core, and Entity Framework for a trading software firm. He is also finishing his Computer Science studies at the University of Athens. He has worked for two start-ups in the past, is active in the open source community, and loves taking up small side projects. He is fascinated by modern JavaScript, C#, and the .NET Core.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Yes need to create account on microservice
Explore object-relational mapping
Install Entity Framework Core
Create a database context
Create, execute, and roll back migrations
Execute complex relational models
Seed the database
Write custom SQL queries
Work with existing databases

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Application Development
  • Project
  • ASP
  • Database training
  • SQL
  • Database
  • ASP training
  • Server
  • ASP net training

Course programme

Introduction to Entity Framework Core 6 lectures 30:19 The Course Overview This video provides an overview of the entire course. What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database Introduction to Entity Framework Core 6 lectures 30:19 The Course Overview This video provides an overview of the entire course. What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. This video provides an overview of the entire course. This video provides an overview of the entire course. What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core What is an O/RM Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core Some of the viewers might not have any prior experiences with O/RMs so they might not know what an O/RM is. • Understand O/RM • Learn about EF Core Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project Starting a New Project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project We need to work on a small starting project. • Start a new ASP.NET Core 2.0 project The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext The Database Context The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext The Database context is vital to application development with Entity Framework Core. The viewers need to know more about it. • Show an example of DbContext • Create a new DbContext • Add two DbSets to the newly created DbContext Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated Creating the Database The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated The viewers have created a new project, installed EF Core and even created a DbContext but they haven’t yet seen a database. • Register the DbContext with DI • Create a static DbInit class • Get an instance of the DbContext and call EnsureCreated The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The SQL Server Object Explorer The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database The viewers would want to view the fake data inserted in the database. The SQL Server Object Explorer is a very helpful tool for that job. • Pull up the SQL Server Object Explorer • Use the View Data feature • Drop the database Create, Execute, and Roll Back Migrations 5 lectures 32:13 What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations Our First Migration Following a theoretical introduction the viewers will need to know how to create their own migrations. • Add entities to the project • Add a DbContext • Execute the migrations and update the database Updating a Table In order to demonstrate one of the key benefits of using migrations we need to attempt to update a table. • Make the change in the model • Create a new migration • Execute the migration and inspect the change in SQL Server Object Explorer Rolling Back After having created and updated a table the viewers will want to know how they can go a step back. • Make an intentional mistake during the creation of an entity • Apply that migration • Roll back to a correct state An Alternative: The Command Prompt In the videos so far we’ve used the PMC to work with migrations. Migrations are still possible with the command line. • Create a new project add entities and a DbContext • Guide the viewer through the installation of the required packages • Demonstrate the basic migration operations in the CMD Create, Execute, and Roll Back Migrations. 5 lectures 32:13 What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations Our First Migration Following a theoretical introduction the viewers will need to know how to create their own migrations. • Add entities to the project • Add a DbContext • Execute the migrations and update the database Updating a Table In order to demonstrate one of the key benefits of using migrations we need to attempt to update a table. • Make the change in the model • Create a new migration • Execute the migration and inspect the change in SQL Server Object Explorer Rolling Back After having created and updated a table the viewers will want to know how they can go a step back. • Make an intentional mistake during the creation of an entity • Apply that migration • Roll back to a correct state An Alternative: The Command Prompt In the videos so far we’ve used the PMC to work with migrations. Migrations are still possible with the command line. • Create a new project add entities and a DbContext • Guide the viewer through the installation of the required packages • Demonstrate the basic migration operations in the CMD What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations What is a Migration Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is. • Provide a detailed explanation of what migrations are • Describe the advantages of using migrations Viewers without prior exposure to O/RMs have no knowledge of what an O/RM is max length. • Use the MaxLength attribute in a model • Describe what changes in the migration when we use...

Additional information

Front End Web Development, c#

Learning Entity Framework Core

£ 150 + VAT