How to Read Record from Database in ASP.MVC Core using Entity Framework Core 1.0

Question

Aryan Kumar · Answer

To read a table in asp.net core using the database-first appraoch, follow these steps:

Create a DbContext class that inherits from DbContext.
In the DbContext class, add a property for the table that you want to read. The property should be of type DbSet.
Create a controller that will exposes data to the users. The controller should have a methods to retrieve the data from the DbContext class.
In the view, bind the data from the controller to the UI.

Here's is an example that shows how a table is read a record from a database in ASP.NET MVC Core using a database-first approach:

C#

public class MyContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
}

public class CustomerController : Controller
{
    private readonly MyContext _context;

    public CustomerController(MyContext context)
    {
        _context = context;
    }

    public ActionResult Index()
    {
        var customer = _context.Customers.Find(1);
        return View(customer);
    }
}

In this example, we first create a DbContext class called MyContext. The MyContext class has a property called Customers of type DbSet. This property represents the Customers table in the database.

Next, create a controller called CustomerController. The CustomerController class has a method called Index(). The Index() method gets the record with the ID of 1 from the Customers table in the database and returns it to the view.

The view then binds the data from the controller to the UI.

Here are some other things to keep in mind when reading records from a database in ASP.NET MVC Core using Entity Framework Core 1.0:

You can use the Find method to get a single record from the database.
You can use the ToList() method to get a list of records from the database.
You can use the Where method to filter the results of the query.
You can use the OrderBy method to order the results of the query.

forum

How to Read Record from Database in ASP.MVC Core using Entity Framework Core 1.0

Can you answer this question?

1 Answers