Use Entity Framework Core as the Object-Relational Mapping (ORM) tool for .NET Core applications. Entity Framework Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework ORM. It provides a simple way to interact with databases using C# code, without having to write SQL queries.

Using Entity Framework Core has several benefits. First, it allows developers to work with databases using C# code, which is more intuitive and easier to read than SQL queries. Second, it provides a layer of abstraction between the application and the database, which makes it easier to switch between different database providers. Third, it provides features such as change tracking, which makes it easier to work with data in the application. Finally, it supports LINQ queries, which are more powerful and flexible than SQL queries.

Here is an example of how to use Entity Framework Core to retrieve data from a database using LINQ queries:

using (var context = new MyDbContext())
{
    var customers = context.Customers
        .Where(c => c.City == "London")
        .OrderBy(c => c.LastName)
        .ToList();
}

In the above example, we are using Entity Framework Core to retrieve all customers from the database whose city is "London", and then ordering them by their last name. The ToList() method is used to execute the query and return the results as a list of Customer objects.