Entity Framework Core is a modern, lightweight, open-source, cross-platform object-relational mapper.

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

```C#

on ord.OrderId == sup.SupplierId
```

```C#

on ord.OrderId into sup.SupplierId
```

```C#

on ord.OrderId != sup.SupplierId
```

```C#

on ord.OrderId equals sup.SupplierId
```

Which option best completes the inner join below?

```C#
var orderSupplierQuery = from ord in orders
join sup in suppliers

 //complete the code              
 select new 
 {
   OrderId = ord.Id, 
   SupplierName=sup.Title
 };

```

Which option best completes the inner join below?
<pre><code class="language-C#">var orderSupplierQuery = from ord in orders
join sup in suppliers

 //complete the code 
 select new 
 {
 OrderId = ord.Id, 
 SupplierName=sup.Title
 };

</code></pre>

What is the output of the code sample below?

```C#
using System;
using System.Linq;

class Program
{
    static void Main()
    {
        int[] numbers1 = { 17, 12, 5, 21, 30 };

        var query = from element in numbers1 orderby element  select element;

        int[] numbers2 = query.ToArray();

        foreach (int value in numbers2)
        {
            Console.Write("{0} ",value);
        }
            Console.WriteLine();
    }
}

```

What is the output of the code sample below?
<pre><code class="language-C#">using System;
using System.Linq;

class Program
{
 static void Main()
 {
 int[] numbers1 = { 17, 12, 5, 21, 30 };

 var query = from element in numbers1 orderby element select element;

 int[] numbers2 = query.ToArray();

 foreach (int value in numbers2)
 {
 Console.Write(&quot;{0} &quot;,value);
 }
 Console.WriteLine();
 }
}

</code></pre>

What type of syntax is the following query an example of?
```C#
var student = students.Where(s => s.Age>12).ToList<Student>();
```

What type of syntax is the following query an example of?
<pre><code class="language-C#">var student = students.Where(s =&gt; s.Age&gt;12).ToList&lt;Student&gt;();
</code></pre>

What is the output of the code sample below?

```C#

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        int[] numbers = { 17, 12, 5, 21, 30 };

        var selection = numbers.OrderBy(n => n).Skip(2).Take(2);
        foreach (int item in selection)
        {
            Console.Write("{0} ", item);
        }
        Console.WriteLine();
    }
}

```

What is the output of the code sample below?
<pre><code class="language-C#">
using System;
using System.Linq;

class Program
{
 static void Main()
 {
 int[] numbers = { 17, 12, 5, 21, 30 };

 var selection = numbers.OrderBy(n =&gt; n).Skip(2).Take(2);
 foreach (int item in selection)
 {
 Console.Write(&quot;{0} &quot;, item);
 }
 Console.WriteLine();
 }
}

</code></pre>

(**Fill in the blank.**) Explicit loading is achieved using the ________ method.

(Fill in the blank.) Explicit loading is achieved using the ________ method.

Getting Started

Reverse Engineering

Migrations

Configuring a Model

Query Data

Save Data

Logging and Testing

Conclusion

Appendix

Quiz: Query Data