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();