Overview

EF Core uses LINQ to query data from the database.

Loading all data

using var context = new BloggingContext();

var blogs = context.Blogs.ToList();

Loading a single entity

using var context = new BloggingContext();

var blog = context.Blogs.Single(b => b.BlogId == 1);

Filtering

using var context = new BloggingContext();

var blogs = context.Blogs.Where(b => b.Url.Contains("dotnet"))
                                          .ToList();