MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Entity Framework Basics

Course Summary

In this course, you'll learn how to use Microsoft's Entity Framework to persist application data to a database. By the end of the course, you'll have learned how to use the Code First workflow, create entity classes, write LINQ queries, perform CRUD operations, and more.


  • +

    Course Syllabus

    Introducing Entity Framework

    We'll start with an introduction of Entity Framework, including an overview of the Database First and Model First workflows. Then we'll use the Code First workflow to add our first entity class and database context class. We'll also see how to use the context to add an entity to the database and retrieve a list of entities from the database. 11 steps
    • Welcome to Entity Framework Basics 2:37
    • What is Entity Framework? 4:19
    • Entity Framework Review 5 questions
    • Workflows: Database First 6:19
    • Workflows: Model First 5:50
    • Adding Our First Entity Using the Code First Workflow 6:02
    • Adding an Entity 2 objectives
    • Adding Our Context 3:03
    • Adding a Context 2 objectives
    • Using the Context 5:03
    • Section Review 10 questions

    Entity Framework and Databases

    We'll see how to confirm that SQL Server LocalDB is installed and configured correctly for Entity Framework. We'll also locate and review the database that EF generated for us in the previous section, customize the database name, and configure EF's database initializer. 8 steps

    Extending Our Entity Data Model

    We'll extend our model by adding entities and defining relationships between our entities. Then we'll see how to refine our model using data annotation attributes on our entities or by using the fluent API. We'll also see how to use a custom database initializer to seed our database with data. 14 steps

    LINQ Queries

    We'll see how to write LINQ to Entities queries including how to filter and sort data. Then we'll see the options that EF gives us for loading related data and how they compare to one another. We'll also see the options that EF provides for retrieving a single entity from the context. 10 steps

    CRUD Operations

    We'll take a look at a console application that was built on top of our comic book model. We'll also learn how to perform CRUD operations with the database context. As we do that, we'll implement various Repository class methods in the console application. 9 steps


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top