Discover Entity Framework Core for efficient data access and relational mapping. Gain insights into workflows, model configuration, querying, change tracking, logging, and testing to boost productivity and code maintainability.

Using Entity Framework Core for Data Access & Relational Mapping.png

ScaffoldDB.tar.gz

EFCore

EFCorePreCreateTablesInOutputDir

EFCorePreCreateTablesAndViewInOutputDir

EFCoreWithProxies

EFCoreWithXunit

CreateSchoolTablesInOutputDir

This course introduces Entity Framework Core for data access and object-relational mapping. Entity Framework Core provides benefits such as the ability to work with databases using .NET objects without the concern for underlying database tables. This leads to less code for data access and improved performance. 

You’ll begin with the workflows of Entity Framework Core—reverse engineering and migrations. Next, you’ll learn model configuration and relationships. Then, you’ll cover various methods for querying and saving data. You’ll also learn about change tracking and its relationship with queries. Finally, you’ll learn about logging and testing.

Entity Framework Core simplifies app development. By the end of this course, you’ll be able to improve code maintainability and concentrate on business logic by generating SQL, materializing results, and performing other tasks. You’ll have a good understanding of Entity Framework Core, which will improve your productivity and efficiency on your development journey.

Using Entity Framework Core for Data Access & Relational Mapping

Which method of DbContext saves entities to the database?

Which method of DbContext saves entities to the database?

(**Fill in the blank.**) Entities created or retrieved out of the scope of the current `DbContext` have the ________ entity state.

(Fill in the blank.) Entities created or retrieved out of the scope of the current <code>DbContext</code> have the ________ entity state.

The code below will translate to which command in the database?

```C#
using var context = new StudentsContext();
        context.Students.Add(new Student() { StudentId = 1001, CourseId = "A39"});
        context.SaveChanges();

```

The code below will translate to which command in the database?
<pre><code class="language-C#">using var context = new StudentsContext();
 context.Students.Add(new Student() { StudentId = 1001, CourseId = &quot;A39&quot;});
 context.SaveChanges();

</code></pre>

```C#
context.Students.Update(student);
```

```C#
context.Students.AddEntity(student);
```

```C#
context.Students.Adds(student);
```

Which option results in an `INSERT` operation on the student instance below?

```C#

var student = new Student
        {

            Firstname="Martin",
            Lastname ="Joseph",
            CourseId=2
        };

        using var context = new ArtistsContext();
        //Complete the code        
        context.SaveChanges();

```

Which option results in an <code>INSERT</code> operation on the student instance below?
<pre><code class="language-C#">
var student = new Student
 {

 Firstname=&quot;Martin&quot;,
 Lastname =&quot;Joseph&quot;,
 CourseId=2
 };

 using var context = new ArtistsContext();
 //Complete the code 
 context.SaveChanges();

</code></pre>

From the code snippet below, identify the state of the `Student` instance before and after the `Add` method is called.

```C#

var student = new Student
        {

            Firstname="Martin",
            Lastname ="Joseph",
            CourseId=2
        };

        using var context = new ArtistsContext();
        context.Students.Add(student);
        context.SaveChanges();
```

From the code snippet below, identify the state of the <code>Student</code> instance before and after the <code>Add</code> method is called.
<pre><code class="language-C#">
var student = new Student
 {

 Firstname=&quot;Martin&quot;,
 Lastname =&quot;Joseph&quot;,
 CourseId=2
 };

 using var context = new ArtistsContext();
 context.Students.Add(student);
 context.SaveChanges();
</code></pre>

Quiz on Save Data

Quiz on Save Data

Review your knowledge of saving data in EF Core.

Getting Started

Reverse Engineering

Migrations

Configuring a Model

Query Data

Save Data

Logging and Testing

Conclusion

Appendix

Quiz: Save Data